Samuele, I did reply to your original email on this problem. Here is my reply again:
Hi, The error message you are getting actually comes from the PostgreSQL server - pgAdmin is just displaying it. Basically, it can't understand '2001-12-04 00.00.00' as a timestamp. I've tried this on my system and get the same result as you, however if I change the data to '2001-12-04 00:00:00' (which is the standard ISO format) it works fine. I would suggest either: - Adjusting the date format on your SQL system to ISO. or - If the . notation is valid for your locale, check with one of the PostgreSQL mailing lists (probably [EMAIL PROTECTED]) to ensure that your system is setup correctly and that it isn't an actual bug in PostgreSQL. Regards, Dave. > -----Original Message----- > From: Samuele Brignoli [mailto:[EMAIL PROTECTED]] > Sent: 26 February 2002 09:02 > To: jack; [EMAIL PROTECTED] > Subject: R: [pgadmin-support] table and column comment > > > Still here this question on date. This query cannot execute : > > > INSERT INTO "ahepatch" ("ptcodrel", "ptreleas", "ptnumpat", > "ptdatins", > "ptdescri", "cpccchk") VALUES ('1.02-A0001 ', '1.2 ', '1', > '2001-12-04 00.00.00', 'Aggiornamento EURO-KIT > ', > 'kfdujcqkgp') > > when i run migration wizard from a sql server db to a > postgresql one. I obtain the follow error : > > > -----Messaggio originale----- > Da: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]Per conto di jack > Inviato: marted� 26 febbraio 2002 3.23 > A: [EMAIL PROTECTED] > Oggetto: [pgadmin-support] table and column comment > > > Hi, Dave > > I'm using pgadmin2 to develope an apllication on postgreSQL > server. Would you please advise if I want to use sql > statements to retrieve or update table and column comment, > what can I do? Thank you! > > jack > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an > appropriate subscribe-nomail command to > [EMAIL PROTECTED] so that your message can get through > to the mailing list cleanly >
