Use of Serial type
От | Jim Beckstrom |
---|---|
Тема | Use of Serial type |
Дата | |
Msg-id | 3D88C991.54BF238E@voyager.net обсуждение исходный текст |
Ответы |
Re: Use of Serial type
Re: Use of Serial type Re: Use of Serial type |
Список | pgsql-php |
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? Jim Beckstrom
В списке pgsql-php по дате отправления: