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,
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
