Re: How to INSERT empty line into SEQUENTIAL table from PHP

True indeed... With

SELECT setval('page_input_id_seq', 89);

it works then with this:

INSERT INTO page_input (id, page, text_en, text_fr, text_es, text_ar)
VALUES (nextval('page_input_id_seq'::regclass), '', '', '', '', '')

Thanks a lot!!

Stef

> I guess you get duplicate value error because you have previously
> inserted ID column with your own values. Check the sequence
> page_input_id_seq if it points to the right next value. If not -
> correct it to a MAX(ID) +1
>
> Julius Tuskenis
>
>
>
> Stefan Schwarzer rašė:
>> It doesn't work like this:
>>
>> INSERT INTO page_input (id, page, text_en, text_fr, text_es,
>> text_ar) VALUES (NULL, '', '', '', '', '')
>>
>> --> ERROR: null value in column "id" violates not-null constraint
>>
>> nor like this:
>>
>> INSERT INTO page_input (page, text_en, text_fr, text_es,
>> text_ar) VALUES ('', '', '', '', '')
>>
>> --> ERROR: duplicate key value violates unique constraint
>> "id_unique"
>>
>> nor like this:
>>
>> INSERT INTO page_input (id, page, text_en, text_fr, text_es,
>> text_ar) VALUES (nextval('page_input_id_seq'::regclass), '', '',
>> '', '', '')
>> --> ERROR: duplicate key value violates unique constraint
>> "id_unique"
>>
>>
>>
>> On Jun 16, 2008, at 8:54 AM, Julius Tuskenis wrote:
>>
>>> Hi, Stefan.
>>>
>>> your second example should work for you.
>>> INSERT INTO table_xx (field2, field3, field4) VALUES ('', '', '');
>>> (keeping in mind, that your ID column is of type serial or has
>>> DEFAULT NEXTVAL('some_sequence') ).
>>> You can also insert values yourself:
>>> INSERT INTO table_xx (ID, field2, field3, field4) VALUES
>>> (NEXTVAL('some_sequence'), '', '', '');
>>>
>>> Julius Tuskenis
>>>
>>>
>>>
>>> Stefan Schwarzer rašė:
>>>> 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
>>>>
>>>>
>>
>>