Postgres Pro
Downloads
Home   >   mailing lists

Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef - Mailing list pgsql-jdbc

From Dickson S. Guedes
Subject Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
Date
Msg-id 1236686408.7858.17.camel@analise3.cresoltec.com.br
Whole thread Raw
In response to Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Tree view 
Em Seg, 2009-03-09 às 23:28 -0400, Tom Lane escreveu:
> But maybe it's only being used to check if the column
> has a default, in which case the possible staleness of the string
> value isn't important.

Some Java programs (as DBVis and Aqua for example), are using it to get
column default value, but are showing an old information after we rename
the sequence.

Regards,
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br

pgsql-jdbc by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: [PERFORM] Query much slower when run from postgres function
Next
From: Kris Jurka
Date:
Subject: Re: [PERFORM] Query much slower when run from postgres function