Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
Date: 2009-03-10 12:00:08
Message-ID: 1236686408.7858.17.camel@analise3.cresoltec.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Frank Ch. Eigler 2009-03-10 14:40:51 Re: Query much slower when run from postgres function
Previous Message Guillaume Cottenceau 2009-03-10 09:41:19 Re: [PERFORM] Query much slower when run from postgres function