Skip site navigation (1) Skip section navigation (2)

Strange insert

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 (view raw or flat)
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

pgsql-novice by date

Next:From: pg sqlDate: 2002-03-31 00:57:12
Subject: Upgrading - How?
Previous:From: Tom LaneDate: 2002-03-30 04:13:17
Subject: Re: CURRENT_USER

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group