Re: [GENERAL] Behavior of "at time zone"

something the AT TIME ZONE construct is swapping the signs of the offset when specifying the timezone numerically. Cheers, Andrew -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Friday, 29 January 2010 11:57 AM To: pgsql-general@postgresql.org Cc: And

[GENERAL] Behavior of "at time zone"

Hi there, I'm looking to use the "at time zone" language feature, however the results below don't really agree with my expectations. Is this a bug in 8.4 or am I misinterpreting the results? If it is a bug, has it been fixed in the development releases? psql (8.4.0) Type "help" for

Re: [GENERAL] Archive command seem to be working.

Hi Chris, Assuming the error condition is resolved, the process should restart automatically. However, one issue we have found is that there appears to be an upper limit to how many files `test` can actually check for existence. We found that it was returning 1 in error and henc

[GENERAL] Large Files?

[postres@kc131-161 /usr/local/opt/Postgres/data/global]# ls -la total 170 drwx-- 2 postgres dbadmin 512 Oct 15 18:09 . drwx-- 5 postgres dbadmin 512 Oct 15 18:00 .. -rw--- 1 postgres dbadmin8192 Oct 15 18:10 1260 -rw--- 1 postgres dbadmin 0 Oct 15 17:59