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

From: Tom Lane
Subject: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
Date: ,
Msg-id: 20795.1236655715@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  ("Dickson S. Guedes")
Responses: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  (Oliver Jowett)
Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  ("Dickson S. Guedes")
List: pgsql-jdbc


"Dickson S. Guedes" <> writes:
> Shouldn't the JDBC driver use another query instead that, since docs
> alerts[1] to this problem?

What's the default value being used for anyway?  If it's to determine
which sequence is associated with the column, I think you shouldn't be
looking at pg_attrdef at all; you should look for a dependent sequence
via pg_depend.  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.

            regards, tom lane


pgsql-jdbc by date:

From: Oliver Jowett
Date:
Subject: Re: [PERFORM] Query much slower when run from postgres function
From: Guillaume Cottenceau
Date:
Subject: Re: [PERFORM] Query much slower when run from postgres function