Hello,
I have some suggestions to improve the PostgreSQL support in TDM
-
allow the Not null constraints to be named (the way this is possible in Oracle, Postgres supports the same syntax)
-
Map TDM domains to real Postgres domains. Postgres supports domains directly, so TDM could generate the approriate CREATE DOMAIN statement instead of re-mapping the datatypes for the columns during DDL generation. Something like this:
CREATE DOMAIN d_lastname AS varchar(50) NOT NULL;
CREATE TABLE person (
id serial not null,
lastname d_lastname
);
-
drop the addition of “with (oids=false)” completely in the generated SQL (if it’s unchecked). It only clutters the generated SQL and nowadays does not server any purpose as it’s the default anyway (as oids are deprecated).
-
Allow comments for sequences, views and domains (if generated). Currently sequences neither have “Notes” nor "Comments. And Views only have “Notes” which are not generated into SQL comments. I know this can be worked around using the “After Script”, but a “real” comment would be cleaner.
-
Add the option to specify “UNLOGGED” tables. This is a new feature in Postgres 9.1