postgres server_default as PK

[cmflynn]

Hey guys, perhaps I'm missing something basic but when I tried to use a postgres server_default func as a primary key, i get errors on model.save(). here is the issue I opened up: #744. any help is appreciated. ty 🙏

[SepehrBazyar]

Hi @cmflynn
I am not very sure, but maybe this part of the fastapi-utils doucment related to server_default settings is the answer:

Note this will only work if you have installed the pgcrypto extension in your postgres instance. If the user you connect with has the right privileges, this can be done by calling the fastapi_utils.guid_type.setup_guids_postgresql function.

The settings required are very simple just run this:
engine.execute('create EXTENSION if not EXISTS "pgcrypto"')

[cmflynn]

interesting -- will look into this. tyvm

[SepehrBazyar]

interesting -- will look into this. tyvm

I would be happy to know if this was the reason or not.