Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
ptrwis
on Sept 15, 2021
|
parent
|
context
|
favorite
| on:
PostgreSQL 15: default permissions for everyone is...
In example pgcrypto extension has a lot of functions, if you have more stored functions it might be worth to install pgcrypto in dedicated schema.
chromatin
on Sept 15, 2021
|
next
[–]
Thank goodness with Postgres 13 the uuidv4 function got moved into core (not requiring pgcrypto installation)
leetrout
on Sept 16, 2021
|
parent
|
next
[–]
Maybe you are thinking of uuid-ossp? I'm not aware of pgcrypto being required for UUIDs.
chromatin
on Sept 16, 2021
|
root
|
parent
|
next
[–]
> If you only need randomly-generated (version 4) UUIDs, consider using the gen_random_uuid() function from the pgcrypto module instead.
https://www.postgresql.org/docs/12/uuid-ossp.html
leetrout
on Sept 17, 2021
|
root
|
parent
|
next
[–]
Ah! Well TIL. Thank you
tragomaskhalos
on Sept 16, 2021
|
prev
[–]
Yeah in general
any
extension should go in its own schema.
Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
