Strange insert - Mailing list pgsql-novice

From thiemo
Subject Strange insert
Date
Msg-id 30AB1B2F-43BF-11D6-9B49-000A27D62F9E@gmx.ch
Whole thread Raw
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: CURRENT_USER
Next
From: "pg sql"
Date:
Subject: Upgrading - How?