Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group