How to INSERT empty line into SEQUENTIAL table from PHP

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема How to INSERT empty line into SEQUENTIAL table from PHP
Дата
Msg-id 990632DA-983C-4F0E-B54F-4CEC104DB023@grid.unep.ch
обсуждение исходный текст
Ответы Re: How to INSERT empty line into SEQUENTIAL table from PHP  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: How to INSERT empty line into SEQUENTIAL table from PHP  (Julius Tuskenis <julius.tuskenis@gmail.com>)
Список pgsql-general
Hi,

rahter dump question, I guess....

But I have a table with a sequential index field, into which I would
like to add from time to time another line (via webbrowser), which in
turn, stays first empty, before it's being filled in later (via
webbrowser).

Because the ID field is sequential and indexed, I can't use

    INSERT INTO table_xx (ID, field2, field3, field4) VALUES ('', '', '',
'');

neither (skipping ID because it should be filled in automatically):

    INSERT INTO table_xx (field2, field3, field4) VALUES ('', '', '');

How am I supposed to do it?

Thanks for any hints,

Stef


В списке pgsql-general по дате отправления:

Предыдущее
От: "John Tregea"
Дата:
Сообщение: PostgreSQL and AMD?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How to INSERT empty line into SEQUENTIAL table from PHP