[BUGS] BUG #6081: trigger CRUD log entries, or documentation not clear that triggers do not log

2011-06-29 Thread Tom Hodder
The following bug has been logged online: Bug reference: 6081 Logged by: Tom Hodder Email address: t...@limepepper.co.uk PostgreSQL version: 8.4 Operating system: Fedora 14 x86_64 Description:trigger CRUD log entries, or documentation not clear that triggers do not

[BUGS] Bug with plpgsql, temp tables and TOAST?

2011-06-29 Thread Matthijs Bomhoff
Hi, When I run the SQL below, I get an error on the third call to foo() : ERROR: could not open relation with OID 884693. I'm quite sure this OID belongs to the TOAST table corresponding to the temporary table created by foo() during the third call. The fourth call works fine again. I

Re: [BUGS] Bug with plpgsql, temp tables and TOAST?

2011-06-29 Thread Alvaro Herrera
Excerpts from Matthijs Bomhoff's message of mié jun 29 07:40:07 -0400 2011: CREATE OR REPLACE FUNCTION foo(size_ INTEGER) RETURNS TEXT AS $EOF$ DECLARE acc_ TEXT := ''; cur_rec_ RECORD; BEGIN EXECUTE 'CREATE TEMPORARY TABLE foo_tab(blob TEXT NOT NULL)'; -- Construct a string with

[BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

2011-06-29 Thread Steve Haslam
The following bug has been logged online: Bug reference: 6082 Logged by: Steve Haslam Email address: araq...@googlemail.com PostgreSQL version: 9.0.4 Operating system: Debian GNU/Linux (amd64) Description:server segfault - pg_stat_reset_shared(null) Details: =

[BUGS] BUG #6083: psql script line numbers incorrectly count \copy data

2011-06-29 Thread Steve Haslam
The following bug has been logged online: Bug reference: 6083 Logged by: Steve Haslam Email address: araq...@googlemail.com PostgreSQL version: 9.0.4 Operating system: Debian GNU/Linux (amd64) Description:psql script line numbers incorrectly count \copy data Details:

[BUGS] BUG #6084: When Updating Tables with Select Into

2011-06-29 Thread Stewart Fritts
The following bug has been logged online: Bug reference: 6084 Logged by: Stewart Fritts Email address: stewart.fri...@gmail.com PostgreSQL version: 8.4 Operating system: Windows Server 2003 Description:When Updating Tables with Select Into Details: First, I love

[BUGS] BUG #6085: pg_upgrade fails when unix_socket_directory != /tmp

2011-06-29 Thread Olivier LEVESQUE
The following bug has been logged online: Bug reference: 6085 Logged by: Olivier LEVESQUE Email address: olevesq...@gmail.com PostgreSQL version: 9.0.3 Operating system: RHEL 5.4 Linux 2.6.18 x86_64 Description:pg_upgrade fails when unix_socket_directory != /tmp

Re: [BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

2011-06-29 Thread Magnus Hagander
On Wed, Jun 29, 2011 at 15:31, Steve Haslam araq...@googlemail.com wrote: The following bug has been logged online: Bug reference:      6082 Logged by:          Steve Haslam Email address:      araq...@googlemail.com PostgreSQL version: 9.0.4 Operating system:   Debian GNU/Linux (amd64)

Re: [BUGS] BUG #6063: compatability issues

2011-06-29 Thread Robert Haas
On Fri, Jun 17, 2011 at 1:34 AM, Praveen spkumarvay...@gmail.com wrote: The following bug has been logged online: Bug reference:      6063 Logged by:          Praveen Email address:      spkumarvay...@gmail.com PostgreSQL version: 8.4 Operating system:   windows 7 Description:        

Re: [BUGS] BUG #5741: syslog line length

2011-06-29 Thread Robert Haas
On Tue, Nov 2, 2010 at 12:17 PM, heasley h...@shrubbery.net wrote: The following bug has been logged online: Bug reference:      5741 Logged by:          heasley Email address:      h...@shrubbery.net PostgreSQL version: 8.4 Operating system:   solaris Description:        syslog line

Re: [BUGS] Bug with plpgsql, temp tables and TOAST?

2011-06-29 Thread Matthijs Bomhoff
On Jun 29, 2011, at 6:03 PM, Alvaro Herrera wrote: Excerpts from Matthijs Bomhoff's message of mié jun 29 07:40:07 -0400 2011: CREATE OR REPLACE FUNCTION foo(size_ INTEGER) RETURNS TEXT AS $EOF$ DECLARE acc_ TEXT := ''; cur_rec_ RECORD; BEGIN EXECUTE 'CREATE TEMPORARY TABLE

Re: [BUGS] Bug with plpgsql, temp tables and TOAST?

2011-06-29 Thread Alvaro Herrera
Excerpts from Matthijs Bomhoff's message of mié jun 29 15:20:49 -0400 2011: Possibly related: In some earlier attempts at reproducing this, I actually tried to use length() instead of md5(). It seemed that I could not get it to trigger with that. Just selecting * triggers it of course, but

Re: [BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

2011-06-29 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Wed, Jun 29, 2011 at 15:31, Steve Haslam araq...@googlemail.com wrote: = select pg_stat_reset_shared(null) *server segfault* Thanks for the report - fixed, and will be in next releases. Seems like the more appropriate fix in HEAD is to mark the

Re: [BUGS] BUG #6079: Wrong select result

2011-06-29 Thread Tom Lane
Dean Rasheed dean.a.rash...@gmail.com writes: 2011/6/28 Renat renat.nasy...@itv.ru: select * from foo where date_to is null and date_to '2011-01-01' Expected: 0 rows But: it return 1 row with id=2 The problem seems to be in _bt_preprocess_keys(), which discards the a 1 predicate in

Re: [BUGS] BUG #6084: When Updating Tables with Select Into

2011-06-29 Thread Craig Ringer
On 29/06/2011 10:19 PM, Stewart Fritts wrote: I recently migrated some data from one set of tables to another within a single schema. I did this by using a select...into query. Everything moved perfectly. However; I noticed that the sequence for the receiving table did not increment with the

Re: [BUGS] BUG #6063: compatability issues

2011-06-29 Thread Craig Ringer
problem: now we upgrading our operating system as windows 7 with 64 bit. i am install above software listed above . problem is that execption is occured when connection open statement is executed. There's no evidence this is a bug. Please post a question on the pgsql-general

[BUGS] view + explain + index scan - bogus varno: 65001 (with some variations)

2011-06-29 Thread Jon Nelson
The problem was observed on CentOS 5.6 using postgresql 8.4.7 and Scientific Linux 6.0 also using postgresql 8.4.7. The problem could not be replicated on openSUSE 11.4 which has postgresql 9.0.3. With 8.4.7, I ran into an issue trying to explain a VIEW query. After much effort, I distilled the