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

From: Kris Jurka
Subject: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
Date: ,
Msg-id: Pine.BSO.4.64.0903120001010.30563@leary.csoft.net
(view: Whole thread, Raw)
In response to: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  (Tom Lane)
Responses: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  (Tom Lane)
List: pgsql-jdbc



On Tue, 10 Mar 2009, Tom Lane wrote:

> Oliver Jowett <> writes:
>> Tom Lane wrote:
>>> pg_catalog.pg_get_expr(adbin, adrelid)
>
>> I don't think DBMD.getColumns() is expected to be called all that much,
>> certainly not in performance-critical paths, so perhaps the more complex
>> expression is the way to go. How far back, version-wise, will that
>> expression work?
>
> According to the pg_dump sources, that's good back to 7.3 ... do you
> care about earlier?

It works for 7.2 as well.  Prior to that we'll continue using adsrc.
Committed to CVS and backpatched to 8.0.

Kris Jurka



pgsql-jdbc by date:

From: Kris Jurka
Date:
Subject: Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
From: "Peter"
Date:
Subject: Re: Totally weird behaviour in org.postgresql.Driver