postgresql constraints all get the same name

[torbjorn]

It seems postgresql schemas get the same name for all constraints for a table (which obviously won't work)

I tried setting up a simple table with a id auto_increment primary key and a code text column that's unique:

This is what it generated:

    CREATE TABLE test (
     id BIGSERIAL,
     code TEXT NOT NULL
    );


    ALTER TABLE test ADD CONSTRAINT test_pkey PRIMARY KEY (id);
    ALTER TABLE test ADD CONSTRAINT test_pkey UNIQUE (code);

Notice how they are both named test_pkey. This does not work.

If I give the constraints specific names, it still doesn't change this behavior.

[p43k]

my solution, maybe you can think of something similar ....;)
postgresql_keys-tunning.zip

[p43k]

deal with default value:

<xsl:if test="default and not ( default = 'NULL' or default = &quot;'NULL'&quot; )">
<xsl:text> DEFAULT </xsl:text>
<xsl:value-of select="default" />
<xsl:text></xsl:text>
</xsl:if>