Re: [PATCHES] Proposed patch for sequence-renaming problems - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] Proposed patch for sequence-renaming problems
Date
Msg-id 200509291426.j8TEQhg19142@candle.pha.pa.us
Whole thread Raw
In response to Re: [PATCHES] Proposed patch for sequence-renaming problems  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> On Wed, Sep 28, 2005 at 10:41:12PM -0400, Bruce Momjian wrote:
> > 
> > Also, why is the nextval ::text casting output by pg_dump anyway?
> 
> AFAICS, pg_dump outputs "serial" (at least in 7.4.7 which is what I
> have to hand) when it should meaning that dumps restored will get the
> new syntax anyway. Or am I missing something?
> 
> Isn't this what adddepend was for? I can beleive there are version
> dependancies here...

Right, we think we can get SERIAL to work fine.  It is manual use of
nextval() in DEFAULT that we are worried about, and there is probably
not too much use of that.  There is no dependency info about that.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_total_relation_size() could not open relation with OID X
Next
From: Bruce Momjian
Date:
Subject: Re: [DOCS] Added documentation about caching, reliability