Re: [BUGS] date_trunc check constraint causes errors when restoring in a db with a different time zone

2011-01-18 Thread Anthony Manfredi
Thanks, that is helpful. There was a separate reason it didn't appear to be happening before the 8.4 upgrade. I couldn't find this mentioned in the documentation anywhere. Should it be included in the pg_restore section? -Anthony On Sun, Jan 16, 2011 at 11:06 AM, Denish Patel wrote:

[BUGS] date_trunc check constraint causes errors when restoring in a db with a different time zone

2011-01-15 Thread Anthony Manfredi
test_table" violates check constraint "time_days_start_time_ck" CONTEXT: COPY test_table, line 1: "2010-01-14 19:00:00-05" WARNING: errors ignored on restore: 1 Best, Anthony -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4133: Installation error

2008-04-29 Thread Anthony
The following bug has been logged online: Bug reference: 4133 Logged by: Anthony Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows Vista Home Premium Description:Installation error Details: I have a problem with installation. 1

[BUGS] BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms

2007-02-13 Thread Anthony Taylor
The following bug has been logged online: Bug reference: 2996 Logged by: Anthony Taylor Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux kernel 2.6.11 (based on Gentoo) Description:to_char( timestamp, 'DD-Mon- HH24:MI:

[BUGS] PostgreSQL 8.1.3.6044 crashes randomly.

2006-04-04 Thread Anthony Ransley
The Windows version of PostgreSQL 8.1.3.6044 has randomly crashed a few times now. Can anyone supply me with the symbol set for the 8.1.3.6044 Windows release, so I can provide more information and maybe even debug it. Thanks, Anthony Ransley.

[BUGS] BUG #2373: postgres.exe crashes

2006-04-03 Thread Anthony Ransley
The following bug has been logged online: Bug reference: 2373 Logged by: Anthony Ransley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3.6044 Operating system: Windows XP SP2 Description:postgres.exe crashes Details: postgres.exe craches randomly. Where

[BUGS] BUG #1469: ECPG : Can't delete an item pointed by a cursor

2005-02-07 Thread Anthony COMMUNIER
The following bug has been logged online: Bug reference: 1469 Logged by: Anthony COMMUNIER Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Aix 5.2,UnixWare 7.1.3,Win32 Description:ECPG : Can't delete an item pointed by a cursor De

[BUGS] SSL password problem in PG-WIN32

2004-10-29 Thread Anthony
When I startup using myself compiled PG.(use MINGW,OPENSSL,ZLIB) And I use pg_ctl start -o -i, it work fine. But when use pg_ctl start -o -il, it will prompt: Enter PEM pass phrase: when I input password, it fails. it say " NO THIS COMMAND" I think this problem exist in postmaster don't have one

[BUGS] pg_restore many errors

2004-08-13 Thread anthony . caduto
Hi, I created a new database in the win32 version of 8.0 beta1 and added some functions. I then did a pg_dump like so: C:\Program Files\PostgreSQL\8.0-beta1\bin>pg_dump --username=postgres --format=c  --file=c:\testdb.bak testdb the backup is created successfully. I then try to restore with pg_r