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 q
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 database
Yoran Heling 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 empty databas
"Hitoshi Harada" 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.
Reading the code,
Dimitri Fontaine 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, Formation et Support
Dimitri Fontaine writes:
> Dimitri Fontaine 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 something to do with
http://git.postgresql.org/
Tom Lane wrote:
> Bruce Momjian 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,
On 20.08.2011 03:39, Daniel Farina wrote:
The following bug has been logged online:
Bug reference: 6170
Logged by: Daniel Farina
Email address: dan...@heroku.com
PostgreSQL version: 9.0.4
Operating system: GNU/Linux Ubuntu 10.04 x86_64
Description:hot standby wedgin
