Strange insert
От | thiemo |
---|---|
Тема | Strange insert |
Дата | |
Msg-id | 30AB1B2F-43BF-11D6-9B49-000A27D62F9E@gmx.ch обсуждение исходный текст |
Список | pgsql-novice |
Hi, when I issue in dbvisualizer 2.1 "INSERT INTO pwd (programm, link, schluessel, seriennummer, user_id, passwort, bemerkungen, guetlig_bis, benutzer) VALUES ('Windows 95', '', '', '09898-OEM-0031692-03738', '', '', '', to_date('2002-03-29', 'yyyy-mm-dd'), 'thiemo');" then I get alternatingly that one row was successfully inserted and "ERROR Bad date external representation". s_pwd is a sequence for the primary key. "CREATE SEQUENCE s_pwd ( INCREMENT 1 MINVALUE 1 START 1 CACHE 1 );" Does anybody have an idea, what I am doing wrong? Thx Thiemo <fontfamily><param>Helvetica</param> -- Thiemo Kellner Tösstalstrasse 146 CH-8400 Winterthur </fontfamily>Hi, when I issue in dbvisualizer 2.1 "INSERT INTO pwd (programm, link, schluessel, seriennummer, user_id, passwort, bemerkungen, guetlig_bis, benutzer) VALUES ('Windows 95', '', '', '09898-OEM-0031692-03738', '', '', '', to_date('2002-03-29', 'yyyy-mm-dd'), 'thiemo');" then I get alternatingly that one row was successfully inserted and "ERROR Bad date external representation". s_pwd is a sequence for the primary key. "CREATE SEQUENCE s_pwd ( INCREMENT 1 MINVALUE 1 START 1 CACHE 1 );" Does anybody have an idea, what I am doing wrong? Thx Thiemo -- Thiemo Kellner Tösstalstrasse 146 CH-8400 Winterthur
В списке pgsql-novice по дате отправления: