[BUGS] Segfault with before triggers and after triggers with a WHEN clause.

2011-08-21 Thread Yoran Heling
Hello, After upgrading to PostgreSQL 9.0.4 (don't remember exactly where I came from, but I believe it was an earlier 9.0.x), postgresql began to segault on certain queries. I have managed to isolate the problem and can reproduce the crash on a newly created and empty database with the following

[BUGS] BUG #6172: DROP EXTENSION error without CASCADE

2011-08-21 Thread Hitoshi Harada
The following bug has been logged online: Bug reference: 6172 Logged by: Hitoshi Harada Email address: umi.tan...@gmail.com PostgreSQL version: 9.1RC1 Operating system: Windows7 Description:DROP EXTENSION error without CASCADE Details: On pure-installed RC1

Re: [BUGS] Segfault with before triggers and after triggers with a WHEN clause.

2011-08-21 Thread Tom Lane
Yoran Heling i...@yorhel.nl writes: After upgrading to PostgreSQL 9.0.4 (don't remember exactly where I came from, but I believe it was an earlier 9.0.x), postgresql began to segault on certain queries. I have managed to isolate the problem and can reproduce the crash on a newly created and

Re: [BUGS] BUG #6172: DROP EXTENSION error without CASCADE

2011-08-21 Thread Dimitri Fontaine
Hitoshi Harada umi.tan...@gmail.com writes: On pure-installed RC1 database, you can CREATE EXTENSION, but cannot DROP it. CREATE EXTENSION cube; DROP EXTENSION cube; ERROR: cannot drop extension cube because other objects depend on it I confirm I have the same bug in current HEAD.

Re: [BUGS] BUG #6172: DROP EXTENSION error without CASCADE

2011-08-21 Thread Dimitri Fontaine
Dimitri Fontaine dimi...@2ndquadrant.fr writes: Also, \dx+ cube will not show all the operators and functions. Some dependency information is indeed missing in pg_depend. Will look at why tomorrow, day's over here. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise,

Re: [BUGS] BUG #6172: DROP EXTENSION error without CASCADE

2011-08-21 Thread Tom Lane
Dimitri Fontaine dimi...@2ndquadrant.fr writes: Dimitri Fontaine dimi...@2ndquadrant.fr writes: Also, \dx+ cube will not show all the operators and functions. Some dependency information is indeed missing in pg_depend. Will look at why tomorrow, day's over here. I'm betting it's got

Re: [BUGS] BUG #6166: configure from source fails with 'This platform is not thread-safe.' but was actually /tmp perms

2011-08-21 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: (The error message seems to be suffering from a bad case of copy-and- paste-itis, too.) Actually, it is accurate. The code is: #ifdef WIN32 h1 = CreateFile(TEMP_FILENAME_1, GENERIC_WRITE, 0, NULL,