Re: [GENERAL] COPY FROM and sequences

2007-01-09 Thread Bruno Wolff III
On Mon, Jan 08, 2007 at 20:20:42 -0500, Matthew Terenzio <[EMAIL PROTECTED]> wrote: > Is it true that you can't use COPY FROM to fill a table with a SERIAL > type column? > > Or rather, how does one approach that situation most effectively? In older versions of postgres you couldn't, in recent

Re: [GENERAL] COPY FROM and sequences

2007-01-08 Thread Matthew Terenzio
On Jan 8, 2007, at 9:20 PM, Matthew Terenzio wrote: On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote: On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote: On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote: Is it true that you can't use COPY FROM to fill a table with a SERIAL type co

Re: [GENERAL] COPY FROM and sequences

2007-01-08 Thread Matthew Terenzio
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote: On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote: On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote: Is it true that you can't use COPY FROM to fill a table with a SERIAL type column? Or rather, how does one approach that situation

Re: [GENERAL] COPY FROM and sequences

2007-01-08 Thread Matthew Terenzio
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote: On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote: Is it true that you can't use COPY FROM to fill a table with a SERIAL type column? Or rather, how does one approach that situation most effectively? Could you give an example of what

[GENERAL] COPY FROM and sequences

2007-01-08 Thread Matthew Terenzio
Is it true that you can't use COPY FROM to fill a table with a SERIAL type column? Or rather, how does one approach that situation most effectively? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to