Re: [HACKERS] Difference when using ZIC vs. Timezone Abbr - Bug? - SOLVED

2008-08-22 Thread Dave Witt
Ah.. my definition of MDT was flawed; thanks for the help! Alvaro Herrera wrote: Tom Lane wrote: Dave Witt <[EMAIL PROTECTED]> writes: These two queries produce different output, using version 8.3.3: SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'MDT

[HACKERS] Difference when using ZIC vs. Timezone Abbr - Bug?

2008-08-21 Thread Dave Witt
uot;="MDT" (from pg_timezone_names) Best regards, -- Dave Witt -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Truncated queries when select * from pg_stat_activity - wishlist / feature request

2008-07-03 Thread Dave Witt
Hi Everyone, My first posting to the group.. I came from a mysql background (~7 years, small/mid database, about 55gig), where I could do "SHOW FULL PROCESSLIST;" to see all the queries currently queued/running on the system. I found it a very useful feature. The Postgres equivalent is (rou