Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-26 Thread Kevin Grittner
yua ** wrote: > PostgreSQL 8.3.3 on i386-portbld-freebsd7.0, compiled by GCC cc (GCC) > 4.2.1 20070719 [FreeBSD] >postgres[681]: [506-1] WARNING: worker took too long to start; cancelled > Nov 12 11:15:12 kddi-nwmgr01 postgres[681]: > [507-1] WARNING: worker took too long to start; canc

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-26 Thread yua ゅぁ
Hello, Kevin. Thank you good guidelines. guidelines questions. Q1 postgres Version A1 PostgreSQL 8.3.3 on i386-portbld-freebsd7.0, compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD] ports Install. Q2 A2 x Q3 Query A3 x Q4 Query A4 x Q5 Error Message A5 postgre

[BUGS] Foreign key constaint can be broken

2010-01-26 Thread Mark Kazemier
Dear, I found a way to break a foreign key constraint in PostgreSQL. I discussed this bug on a dutch discussion board and multiple people tried this on multiple versions. When I create the following tables: CREATE TABLE a ( id SERIAL NOT NULL, foo CHAR(100) NOT NULL, PRIMARY KEY(id) ); CREATE

Re: [BUGS] Foreign key constaint can be broken

2010-01-26 Thread Tom Lane
Mark Kazemier writes: > I found a way to break a foreign key constraint in PostgreSQL > [ ie, make a rule that defeats an ON DELETE CASCADE operation ] This isn't a bug, it's just the way things work. Rules (and triggers) apply to the commands that implement foreign key updates, so a poorly writ

[BUGS] BUG #5296: crash when two 'add column' diagrams are open

2010-01-26 Thread andrew neill
The following bug has been logged online: Bug reference: 5296 Logged by: andrew neill Email address: andrew.nei...@bbc.co.uk PostgreSQL version: 1.10 Operating system: windows xp Description:crash when two 'add column' diagrams are open Details: if you open two 'add

[BUGS] BUG #5297: Add XATMI C API

2010-01-26 Thread Juergen Weber
The following bug has been logged online: Bug reference: 5297 Logged by: Juergen Weber Email address: webe...@gmail.com PostgreSQL version: 8 Operating system: Linux Description:Add XATMI C API Details: An XATMI C API should be added to the PostgresQL C client, so o

Re: [BUGS] BUG #5296: crash when two 'add column' diagrams are open

2010-01-26 Thread Tom Lane
"andrew neill" writes: > if you open two 'add column' dialogs and will in the second and click ok > then try to fill in the second and click ok the program crashes. I'm not sure what program you're speaking of (perhaps pgAdmin?), but this doesn't sound like it is a database problem, which is what

Re: [BUGS] Failed to run initdb - not resolved bug 5130

2010-01-26 Thread Tomas Studva
Hi, I have some time now. I've tried to compile postgres from CVS but wihout success. I don't have visual studio 2005 installed so I've tried eclipse + MinGw. I checked out postgres from cvs branch "REL8_4_STABLE". But I wasn't able to compile it. I don't know how to configure builders to launch m

Re: [BUGS] BUG #5296: crash when two 'add column' diagrams are open

2010-01-26 Thread Craig Ringer
On 27/01/2010 12:52 AM, andrew neill wrote: The following bug has been logged online: Bug reference: 5296 Logged by: andrew neill Email address: andrew.nei...@bbc.co.uk PostgreSQL version: 1.10 Operating system: windows xp Description:crash when two 'add column' dia

Re: [BUGS] BUG #5297: Add XATMI C API

2010-01-26 Thread Craig Ringer
On 27/01/2010 2:11 AM, Juergen Weber wrote: The following bug has been logged online: Bug reference: 5297 Logged by: Juergen Weber Email address: webe...@gmail.com PostgreSQL version: 8 Operating system: Linux Description:Add XATMI C API Details: An XATMI C API sho

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-26 Thread Craig Ringer
On 26/01/2010 8:58 AM, yua ゅぁ wrote: > RAID Card : LSI MegaRAID > Battery Cache : YES > write-back Cache : NO > Software RAID : NO ( Hardware RAID) The LSI MegaRAID series are, AFAIK, software raid implementations. The hardware has some BIOS hooks to enable boot-loading, then the OS loads a drive

Re: [BUGS] Failed to run initdb - not resolved bug 5130

2010-01-26 Thread Euler Taveira de Oliveira
Tomas Studva escreveu: > I have some time now. I've tried to compile postgres from CVS but wihout > success. I don't have visual studio 2005 installed so I've tried eclipse + > MinGw. I checked out postgres from cvs branch "REL8_4_STABLE". But I wasn't > able to compile it. I don't know how to conf

Re: [BUGS] Foreign key constaint can be broken

2010-01-26 Thread Fabien COELHO
I found a way to break a foreign key constraint in PostgreSQL [ ie, make a rule that defeats an ON DELETE CASCADE operation ] This isn't a bug, it's just the way things work. Rules (and triggers) apply to the commands that implement foreign key updates, so a poorly written rule can make those