From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'samuele(dot)brignoli(at)darpha(dot)com'" <samuele(dot)brignoli(at)darpha(dot)com>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: table and column comment |
Date: | 2002-02-26 10:23:52 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB1047617@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)postgresql(dot)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(dot)brignoli(at)darpha(dot)com]
> Sent: 26 February 2002 09:02
> To: jack; pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org]Per conto di jack
> Inviato: martedì 26 febbraio 2002 3.23
> A: pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org so that your message can get through
> to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ligia María Pimentel C. | 2002-02-26 18:26:00 | PGAdmin behaviour that is starting to get me angry... |
Previous Message | Samuele Brignoli | 2002-02-26 09:02:40 | migration wizard question with timestamps |