From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: autoupdate sequences after copy |
Date: | 2003-10-09 19:10:44 |
Message-ID: | 20031009191044.46997.qmail@web40613.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 09 October 2003 08:10, CSN wrote:
> Is there a way to have p/k sequences get
automatically
> set to max(id)+1 after COPY's like the following?
>
> copy table1 (id,name) from stdin;
> 1 abc
> 2 def
> 3 fhi
> \.
Not really - if you don't use the sequence it keeps
its value. If you look at
pg_dump it issues an explicit setval() after a copy.
I'm not sure you can even work around it with a BEFORE
trigger to check and
update the sequence, the nextval() call will probably
be processed before the
trigger gets called (haven't checked). In any case,
performance would be a
bit poor.
Is there any reason why you're supplying your own id
values when you already
have a sequence?
--
Richard Huxton
Archonet Ltd
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Is there any reason why you're supplying your own id
values when you already have a sequence?
I'm importing a lot of data and tables (from mysql)
and want to keep the ID's the same.
CSN
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-10-09 19:27:14 | Re: Response from MySql AB (Re: Humor me: Postgresql vs. |
Previous Message | Bruno Wolff III | 2003-10-09 19:05:36 | Re: [SQL] SQL query problem |