I'm using my phone right now so I can't check, but I'm pretty sure that's not a bug. Isn't timestamptz a timestamp with
timezonee.g. 2002-02-21 19:00:00+00?
Anyway, pgAdmin gets this by looking up the typename from pg_type using pg_attribute.atttypid (iirc) so if it's broken
forone type it probably would be for all types.
I'll check when I can...
Regards, Dave
_____________Original message ____________
Subject: [pgadmin-hackers] Timestamp reverse engeneering bug
Sender: Jean-Michel POURE <jm.poure@freesurf.fr>
Date: Thu, 21 Feb 2002 18:57:05 +0000
Hi Dave,
Table definition with timestamps under 7.2 return "timestamptz".
Cheers,
Jean-Michel POURE
---------------------------(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