| From: | thiemo <thiemo(at)gmx(dot)ch> |
|---|---|
| To: | pgNovice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Strange insert |
| Date: | 2002-03-30 09:19:08 |
| Message-ID: | 30AB1B2F-43BF-11D6-9B49-000A27D62F9E@gmx.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pg sql | 2002-03-31 00:57:12 | Upgrading - How? |
| Previous Message | Tom Lane | 2002-03-30 04:13:17 | Re: CURRENT_USER |