Re: [BUGS] BUG #5557: Problema com Bytea

2010-07-13 Thread Tom Lane
Jaime Casanova writes: > he's saying that some code for retrieving bytea that works in 8.4 > doesn't work in 9.0, so i ask him some code to try... anyone remeber > some change in that area or in an area that could affect the npgsql > driver? Per previous response: the default text output format f

Re: [BUGS] BUG #5557: Problema com Bytea

2010-07-13 Thread Jaime Casanova
On Tue, Jul 13, 2010 at 4:07 AM, Rafael Almeida wrote: > > The following bug has been logged online: > > Bug reference:      5557 > Logged by:          Rafael Almeida > Email address:      raf...@rafaeldeveloper.com > PostgreSQL version: 9.0 > Operating system:   Windows XP > Description:        P

Re: [BUGS] BUG #5560: pg_dump generates invalid DDL

2010-07-13 Thread Tom Lane
"Shigeru Hanada" writes: > When target database contains user mapping for public, pg_dump generates > invalid DDL with empty string like this. > CREATE USER MAPPING FOR "" SERVER srv; I can reproduce this behavior. Another serious problem with the pg_dump code for user mappings is that it fails

Re: [BUGS] BUG #5561: Tsearch across schemas

2010-07-13 Thread Tom Lane
"Satish Kumar" writes: > We decided to use gist text search on two columns in our database (both on > different tables) and hence decided we required the tsearch2.sql > functionalities. We ran tsearch2.sql and create index across 5 schemas. > CREATE INDEX case_attributes_text ON case_attributes

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-13 Thread Tom Lane
"Christopher Head" writes: > When establishing a connection to a PostgreSQL server using a connection > string, there are two parameters that can be provided to specify where to > connect to: "host" and "hostaddr". If both are provided, the documentation > states that "hostaddr" is used to actuall

Re: Fwd: Re: [BUGS] BUG #5556: "cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash

2010-07-13 Thread Heikki Linnakangas
I found the issue earlier today and posted a small test case to reproduce it: http://archives.postgresql.org/pgsql-bugs/2010-07/msg00084.php I must've clicked the wrong teply button as you were not CC'd on that. Sorry. The bug should be fixed now. On 13/07/10 17:57, Robert Walker wrote: A

Fwd: Re: [BUGS] BUG #5556: "cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash

2010-07-13 Thread Robert Walker
Attached are text files with the output from the debugging tool. The "startup" text file is when the backend was first started, the "crash" text file has content that was triggered in the tool when the crash occurred, and the "crash_info" text file is additional information I requested with "~*k"

[BUGS] BUG #5561: Tsearch across schemas

2010-07-13 Thread Satish Kumar
The following bug has been logged online: Bug reference: 5561 Logged by: Satish Kumar Email address: satish.ku...@icasework.com PostgreSQL version: 8.2 Operating system: Ubuntu 9.04 Description:Tsearch across schemas Details: Hi, We decided to use gist text search

[BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-13 Thread Christopher Head
The following bug has been logged online: Bug reference: 5559 Logged by: Christopher Head Email address: chris2...@hotmail.com PostgreSQL version: 8.4.4 Operating system: Gentoo Linux i386, kernel 2.6.34 Description:Full SSL verification fails when hostaddr provided D

[BUGS] BUG #5560: pg_dump generates invalid DDL

2010-07-13 Thread Shigeru Hanada
The following bug has been logged online: Bug reference: 5560 Logged by: Shigeru Hanada Email address: han...@metrosystems.co.jp PostgreSQL version: 9.1devel Operating system: Red Hat Enterprise Linux Server release 5.1 (Tikanga) Description:pg_dump generates invalid

Re: [BUGS] BUG #5558: Problema com Bytea (BRASIL)

2010-07-13 Thread Peter Eisentraut
On tis, 2010-07-13 at 02:11 +, Rafael Almeida wrote: > The following bug has been logged online: > > Bug reference: 5558 > Logged by: Rafael Almeida > Email address: raf...@rafaeldeveloper.com > PostgreSQL version: 9.0 > Operating system: Windows XP > Description:P

Re: [BUGS] BUG #5556: "cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash

2010-07-13 Thread Heikki Linnakangas
On 13/07/10 02:22, Tom Lane wrote: "Robert Walker" writes: Description:"cannot drop active portal" and "ERRORDATA_STACK_SIZE exceeded" lead to server crash We're really going to need to see a self-contained example to do much with this. I see what's going on, I neglected to change s