Re: [BUGS] COPY and sequences

#1

"Przemys=B3aw" <przemyslaw.slupkowski (AT) euro (DOT) coig.pl> writes:

Quote:

Hello
I dont know is this a bug but when I use COPY to load data into table
sequence of the primary key in this table have always start value =3D
1.

Doesn't sound like a bug. If the input data for COPY does not include
PK values, you should not include the PK column in the COPY's column
list, and make sure the PK column's default value gets the nextval()
from the sequence.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] COPY and sequences

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] COPY and sequences - 11-10-2003 , 01:40 PM