Re: [BUGS] BUG #6086: Segmentation fault

2011-07-21 Thread Robert Haas
On Thu, Jun 30, 2011 at 3:32 AM, Dennis wrote: > For some reason a 9.0.4 server which has always run completely stable, and > without any recent changes, crashed ("WARNING:  terminating connection > because of crash of another server process" ..) > > Since it is not a debug build the backtrace is

[BUGS] BUG #6126: CC parameter in to_char() behaves incorrectly

2011-07-21 Thread Artem Andreev
The following bug has been logged online: Bug reference: 6126 Logged by: Artem Andreev Email address: ar...@oktetlabs.ru PostgreSQL version: 9.0.4 Operating system: Debian 6.0 Description:CC parameter in to_char() behaves incorrectly Details: CC parameter in to_char

[BUGS] BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Greg Johnson
The following bug has been logged online: Bug reference: 6127 Logged by: Greg Johnson Email address: greg.john...@interprose.com PostgreSQL version: pg_dump (Postgr Operating system: CentOS release 5.6 (Final) Description:pg_restore failing: unexpected message type 0x

Re: [BUGS] BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Tom Lane
"Greg Johnson" writes: > I am running into an error loading a backup of the production database.. > ERROR: unexpected message type 0x58 during COPY from stdin > CONTEXT: COPY form_big, line 9195632 This looks like pg_restore is terminating unexpectedly. What do you see on the client end of it

Re: [BUGS] BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Tom Lane
Greg Johnson writes: > On Thu, Jul 21, 2011 at 11:44 AM, Tom Lane wrote: >> This looks like pg_restore is terminating unexpectedly. What do you see >> on the client end of it? > pg_restore: [custom archiver] could not read from input file: end of file Well, that suggests you have a truncated o

Re: [BUGS] BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Tom Lane
Greg Johnson writes: > Interesting.. I was able to pg_restore -f to a file... and then psql -f the > resulting file. and it loaded just fine.. the down side to this method is I > cannot use the parallel load function (and the extra time). but I am glad > that I got the data loaded. Let me know if

[BUGS] BUG #6128: A boolean variable doesn't evaluate properly in an IF conditional...

2011-07-21 Thread
The following bug has been logged online: Bug reference: 6128 Logged by: Email address: dani...@megasystems.us PostgreSQL version: 8.3 Operating system: Windows XP Description:A boolean variable doesn't evaluate properly in an IF conditional... Details: I wrote som

Re: [BUGS] BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

2011-07-21 Thread Greg Johnson
pg_restore: [custom archiver] could not read from input file: end of file Thanks for your help! On Thu, Jul 21, 2011 at 11:44 AM, Tom Lane wrote: > "Greg Johnson" writes: > > I am running into an error loading a backup of the production database.. > > > ERROR: unexpected message type 0x58 dur

Re: [BUGS] BUG #6128: A boolean variable doesn't evaluate properly in an IF conditional...

2011-07-21 Thread Tom Lane
"" writes: > For some reason, POSTGRESQL does not evaluate ((put_the_in_city_online = > FALSE) = true) correctly. This is pretty hard to believe, and you're not going to get anyone to think it's anything except pilot error unless you provide a complete, reproducible example. Selectively quoting