Re: table and column comment

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 pgsql-general@postgresql.org) 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:samuele.brignoli@darpha.com]
> Sent: 26 February 2002 09:02
> To: jack; pgadmin-support@postgresql.org
> 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: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org]Per conto di jack
> Inviato: martedì 26 febbraio 2002 3.23
> A: pgadmin-support@postgresql.org
> 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
> majordomo@postgresql.org so that your message can get through
> to the mailing list cleanly
>