| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: serial columns & loads misfeature? |
| Date: | 2002-06-28 20:26:54 |
| Message-ID: | 20020628162654.Q32484@mail.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jun 28, 2002 at 02:50:46PM -0400, Gregory Seidman wrote:
>
> SELECT setval('seq_name', max(serial_column)) FROM appropriate_table;
>
> Unfortunately, I don't think even pg_dump produces this line, though I
> could be wrong.
You are indeed wrong. It is produced by pg_dump (well, actually, it
doesn't use the max() function, but the result is the same).
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-28 20:42:27 | Re: One source of constant annoyance identified |
| Previous Message | Darko Prenosil | 2002-06-28 20:17:17 | Re: Acessing columns of parent tables with PL/pgSQL |