A. Kretschmer wrote:
insert into table_xx (id, field2, ...) values (NULL, ...)
I'd say it should be DEFAULT instead of NULL :-)
T.
smime.p7s
Description: S/MIME Cryptographic Signature
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 err
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:
I
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)
V
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, fiel
am Mon, dem 16.06.2008, um 8:33:27 +0200 mailte Stefan Schwarzer folgendes:
> 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,
