Re: Sequences/defaults and pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nikolay(at)samokhvalov(dot)com
Cc: PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequences/defaults and pg_dump
Date: 2006-02-07 15:36:00
Message-ID: 7236.1139326560@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> writes:
> Forget about SERIAL. I have INTEGER column with some expression as
> DEFAULT in it.

No, you have a SERIAL column that you've improperly mucked with the
implementation of. If you'd declared it as INTEGER to start with,
you could do whatever you wanted to its default expression.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Arai 2006-02-07 15:59:33 Syncing Databases Weekly
Previous Message Bruce Momjian 2006-02-07 15:34:22 Re: Sequences/defaults and pg_dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-07 15:45:43 Re: streamlined standby procedure
Previous Message Bruce Momjian 2006-02-07 15:34:22 Re: Sequences/defaults and pg_dump