#34 PostgreSQL supported?

[Peter De Baets]

The script generated when comparing two snapshots in my PostgreSQL project is not compatible with Postgres:

alter table public.room_restrictions
   modify column restriction_id integer;

alter table public.room_restrictions
   modify column created_at timestamp without time zone;

alter table public.room_restrictions
   modify column updated_at timestamp without time zone;

"modify" is not a Postgress verb. It should be "alter".

Also, the new data type should be preceded with "Type". Ex.:

alter table public.room_restrictions alter column created_at type timestamp without time zone;

With these issues in mind, does ApricotDB support Postgres? Or did I miss something in my setup?

Thanks.

[Anton Nazarov]

Hi Peter,
Thank you for the info. You are right - currently Apricot only supporting the basic ANSI- based scripting (fully tested against SQLServer only).
I will have this ticket in mind for future development of the app.
regards,

Anton