Re: [PATCHES] Proposed patch for sequence-renaming problems

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems
Date: 2005-09-29 14:26:43
Message-ID: 200509291426.j8TEQhg19142@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-09-29 14:40:51 Re: Added documentation about caching, reliability
Previous Message Alvaro Herrera 2005-09-29 14:19:14 Re: pg_total_relation_size() could not open relation with OID X

Browse pgsql-patches by date

  From Date Subject
Next Message Deyan Chepishev 2005-09-30 08:07:42 BUG #1927: incorrect timestamp returned
Previous Message Karel Zak 2005-09-29 09:48:12 COPY view