Re: pg_dump versus SERIAL, round N

From: Morus Walter <morus(dot)walter(at)experteer(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump versus SERIAL, round N
Date: 2006-08-21 08:18:49
Message-ID: 1156148329.7339.319.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, 2006-08-19 at 16:01 -0400, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > The only complaint I can see is that someone
> > who wants pg_dump to dump out SERIAL so it appears just as he created
> > the table, doesn't get that. Could we have pg_dump do that if the
> > sequences all match the creation (weren't modified)?
>
> pg_dump's output is often very far from what you typed in anyway.
> My response to that person would be "get a life" ...
>
As the one who brought up the issue (again) I'd like to add that the
suggested solution sounds good to me.

Thanks a lot for your great work on postgres. You rock!

Morus

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Kirpa 2006-08-21 09:00:58 Re: PostgreSQL on 64 bit Linux
Previous Message Alvaro Herrera 2006-08-21 06:07:41 Updatable views