Re: [BUGS] BUG #5623: uuid-ossp contribs fail to compile

2010-08-18 Thread Jens Wilke
Am Mittwoch 18 August 2010 19:30:51 schrieb Robert Haas: > On Wed, Aug 18, 2010 at 9:55 AM, Jens Wilke wrote: > > uuid-ossp.c:29:2: error: #error OSSP uuid.h not found > > This seems like the one to look at. Perhaps you need to apt-get > install the package that contains that file. After a ./c

[BUGS] COPY FROM/TO losing a single byte of a multibyte UTF-8 sequence

2010-08-18 Thread Steven Schlansker
Hello fine PostgreSQL bug-busters, I'm having a rather annoying problem - a particular string is causing the Postgres COPY functionality to lose a byte, causing data corruption in backups and transferred data. First, the environment - PostgreSQL 8.4.4 on i386-apple-darwin10.3.0, compiled by G

[BUGS] BUG #5626: Parallel pg_restore fails with "tuple concurrently updated"

2010-08-18 Thread Albert Ullrich
The following bug has been logged online: Bug reference: 5626 Logged by: Albert Ullrich Email address: aullr...@blackducksoftware.com PostgreSQL version: 8.4.4 Operating system: Centos 5.5 64bit Description:Parallel pg_restore fails with "tuple concurrently updated" D

Re: [BUGS] BUG #5622: Query failed: server closed the connection unexpectedly

2010-08-18 Thread Tom Lane
Thue Janus Kristensen writes: > I finally succeeded in creating a test case, after much experimentation. > Running the attached sql crashes my postgresql server 100% of the time. Cool, replicated here on CVS HEAD: Program terminated with signal 10, Bus error. #0 afterTriggerCheckState (evtshare

Re: [BUGS] BUG #5622: Query failed: server closed the connection unexpectedly

2010-08-18 Thread Thue Janus Kristensen
I finally succeeded in creating a test case, after much experimentation. Running the attached sql crashes my postgresql server 100% of the time. Regards, Thue On Tue, Aug 17, 2010 at 11:32 PM, Robert Haas wrote: > On Tue, Aug 17, 2010 at 5:26 PM, Thue Janus Kristensen > wrote: > > > > The foll

Re: [BUGS] BUG #5624: Getting error while taking the backup of database from remote machine

2010-08-18 Thread Tom Lane
"Priya Kaliappan" writes: > Our source machine set up : Enterprisedb 8.3 version(64 bit) Remote machine > : RHEL 8.1 version (64 bit). > $pg_dump -U postgres -h (ip) -d db_name > Password: > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: column "nspparent" does not

[BUGS] BUG #5625: PostgreSQL fail to install files in data folder.

2010-08-18 Thread Stanisluv Platonov
The following bug has been logged online: Bug reference: 5625 Logged by: Stanisluv Platonov Email address: stanis...@mail.ru PostgreSQL version: 8.4.4,9.0 beta4 Operating system: Windows 7 Ultimate RUS Description:PostgreSQL fail to install files in data folder. Deta

[BUGS] BUG #5624: Getting error while taking the backup of database from remote machine

2010-08-18 Thread Priya Kaliappan
The following bug has been logged online: Bug reference: 5624 Logged by: Priya Kaliappan Email address: priya_kaliap...@infosys.com PostgreSQL version: 8.3.0.112 Operating system: Red Hat Enterprise Linux Server release 5.5 (Tikanga) Description:Getting error while ta

[BUGS] Fwd: Per-tuple memory leak in 9.0

2010-08-18 Thread Dean Rasheed
Sorry, I meant to cc this to -bugs as well as -hackers -- Forwarded message -- From: Dean Rasheed Date: 18 August 2010 18:29 Subject: Per-tuple memory leak in 9.0 To: pgsql-hack...@postgresql.org While testing triggers, I came across the following memory leak. Here's a simple t

Re: [BUGS] BUG #5623: xml2 and uuid-ossp contribs fail to compile

2010-08-18 Thread Robert Haas
On Wed, Aug 18, 2010 at 9:55 AM, Jens Wilke wrote: > uuid-ossp.c:29:2: error: #error OSSP uuid.h not found This seems like the one to look at. Perhaps you need to apt-get install the package that contains that file. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgr

Re: [BUGS] Unable to create serial column even with permissions

2010-08-18 Thread Tom Lane
I wrote: > It looks to me like the simplest way to make this happen would require > (a) adding a field to CreateSeqStmt to carry the userID we want the > sequence to be owned by; > (b) adding a parameter to DefineRelation to pass in said userID. > We could in theory back-patch this, since CreateSe

Re: [BUGS] BUG #5623: xml2 and uuid-ossp contribs fail to compile

2010-08-18 Thread Mike Fowler
On 18/08/10 14:55, Jens Wilke wrote: The following bug has been logged online: Bug reference: 5623 Logged by: Jens Wilke Email address: jens.wi...@affinitas.de PostgreSQL version: 9.0b4 Operating system: Debian GNU/Linux Lenny Description:xml2 and uuid-ossp contribs

Re: [BUGS] BUG #5622: Query failed: server closed the connection unexpectedly

2010-08-18 Thread Robert Haas
On Tue, Aug 17, 2010 at 10:55 PM, Craig Ringer wrote: > On 18/08/10 05:26, Thue Janus Kristensen wrote: >> /var/log/syslog: >> Aug 17 23:08:26 thue-laptop kernel: [46188.626357] postgres[11461]: segfault >> at 21723858 ip 00772286 sp bf8a4a80 error 4 in postgres[621000+446000] > > If you're game,

[BUGS] BUG #5623: xml2 and uuid-ossp contribs fail to compile

2010-08-18 Thread Jens Wilke
The following bug has been logged online: Bug reference: 5623 Logged by: Jens Wilke Email address: jens.wi...@affinitas.de PostgreSQL version: 9.0b4 Operating system: Debian GNU/Linux Lenny Description:xml2 and uuid-ossp contribs fail to compile Details: Hi, to com

[BUGS] Rules not executed on child tables

2010-08-18 Thread depstein
Hi, I noticed that when an action is executed on a parent table, rules for that action that are defined on its child tables are ignored. Example: create table A (ind integer); create table B () inherits (A); CREATE OR REPLACE RULE B_delete_rule AS ON DELETE TO B DO INSTEAD NOTHING; insert