Thread: Timestamp reverse engeneering bug

Timestamp reverse engeneering bug

From
Jean-Michel POURE
Date:
Hi Dave,

Table definition with timestamps under 7.2 return "timestamptz".

Cheers,
Jean-Michel POURE

Re: Timestamp reverse engeneering bug

From
Dave Page
Date:
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



Re: Timestamp reverse engeneering bug

From
Jean-Michel POURE
Date:
L 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 timezone e.g. 2002-02-21
> 19:00:00+00?
You are right.