Open torbjorn opened 2 years ago
my solution, maybe you can think of something similar ....;) postgresql_keys-tunning.zip
deal with default value:
<xsl:if test="default and not ( default = 'NULL' or default = "'NULL'" )"> <xsl:text> DEFAULT </xsl:text> <xsl:value-of select="default" /> <xsl:text></xsl:text> </xsl:if>
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 acode
text column that's unique:This is what it generated:
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.