Re: Use of Serial type

Jim,

> Using php, I create a table with a SERIAL field. In the same
> script, the last thing I do is a COPY ... FROM ... USING DELIMITERS...to
> load data I have outputted from another system into a text delimited
> file. I didn't get the autoincrementing of the serial field to work, so
> I modified my output-from-another-system program to "manually" set the
> serial field value. That worked. However, it does not seem to have
> done a default SETVAL. Do I do a "manual" SETVAL of 1 greater than the
> highest value from the input text file, or am I missing something in the
> create and copy process?

That sounds fine. However, I would bundle everything in a transaction to be
safe. Otherwise, you risk having a user access the table without the serial
value correctly set.

--
-Josh Berkus
Aglio Database Solutions
San Francisco