Re: [BUGS] BUG #2077: Hiding databases which I am not owner

2005-11-30 Thread Euler Taveira de Oliveira
--- Martin Pelikan <[EMAIL PROTECTED]> escreveu: > I think it's a bug because of security - nosey people are > everywhere... No. It's a feature. > And I want not to other people see how many users and databases are > here - > server is half-public :) > See is one thing, access is another thing. W

Re: [BUGS] pg_dump: schema with OID 559701082 does not exist

2005-11-30 Thread Dirk Lutzebäck
Yes, I finally found the reference in pg_type. Thanks for your help! Regards, Dirk Tom Lane wrote: =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes: I have now deleted every temp table I know from pg_temp_nnn using your approach but still can't dump the schema: pg_dump: schema

Re: [BUGS] BUG #2079: strage PREPARE/EXECUTE behavior

2005-11-30 Thread Tom Lane
"Yuriy Vostrikoff" <[EMAIL PROTECTED]> writes: > EXECUTE return wrong result after ALTER TABLE ALTER COLUMN TYPE. Is this > expected behavior? The prepared plan really should be invalidated by the ALTER, but we don't currently have any infrastructure that would allow that to happen. I think Neil C

Re: [BUGS] BUG #2078: lock freeing problem in transaction (?)

2005-11-30 Thread Tom Lane
"Pierre Beyssac" <[EMAIL PROTECTED]> writes: > Description:lock freeing problem in transaction (?) This seems to be already fixed by this patch: http://archives.postgresql.org/pgsql-committers/2005-11/msg00235.php regards, tom lane ---(end

[BUGS] BUG #2078: lock freeing problem in transaction (?)

2005-11-30 Thread Pierre Beyssac
The following bug has been logged online: Bug reference: 2078 Logged by: Pierre Beyssac Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: FreeBSD 4.11 Description:lock freeing problem in transaction (?) Details: The following code causes t

[BUGS] BUG #2077: Hiding databases which I am not owner

2005-11-30 Thread Martin Pelikan
The following bug has been logged online: Bug reference: 2077 Logged by: Martin Pelikan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Gentoo Linux 2.6.14-gentoo-r2 Description:Hiding databases which I am not owner Details: We have had

Re: [BUGS] BUG #2075: Strange choice of bitmap-index-scan

2005-11-30 Thread Arjen van der Meijden
Hi Tom, The "zichtbaar" as false is indeed a very rare case and appearantly isn't occuring right now. There are indeed 46631 rows in total, and all 46631 have the "zichtbaar" as true. Which reminds me to adjust the index anyway ;-) It appears to be happening if the fraction of zichtbaar's is

[BUGS] BUG #2079: strage PREPARE/EXECUTE behavior

2005-11-30 Thread Yuriy Vostrikoff
The following bug has been logged online: Bug reference: 2079 Logged by: Yuriy Vostrikoff Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Debian sarge Description:strage PREPARE/EXECUTE behavior Details: EXECUTE return wrong result after

Re: [BUGS] BUG #2075: Strange choice of bitmap-index-scan

2005-11-30 Thread Tom Lane
"Arjen" <[EMAIL PROTECTED]> writes: > So, it uses the correct index, but somehow decides to also use the other > cat2_... index, which it doesn't need of course. I've tweaked the heuristics in choose_bitmap_and to (hopefully) work a bit better in scenarios like this. Thanks for the example.

Re: [BUGS] BUG #2080: Partitioning does not work with PREPARE

2005-11-30 Thread Tom Lane
"Janko Richter" <[EMAIL PROTECTED]> writes: > Partitioning does not work with PREPARE. Well, no. How would you expect the prepared plan to know which partition to look in, for a key value it doesn't have yet? regards, tom lane ---(end of broadcast

[BUGS] BUG #2080: Partitioning does not work with PREPARE

2005-11-30 Thread Janko Richter
The following bug has been logged online: Bug reference: 2080 Logged by: Janko Richter Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux Description:Partitioning does not work with PREPARE Details: Partitioning does not work with PREPA

Re: [BUGS] pg_dump: schema with OID 559701082 does not exist

2005-11-30 Thread Tom Lane
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes: > I have now deleted every temp table I know from pg_temp_nnn using your > approach but still can't dump the schema: > pg_dump: schema with OID 559701082 does not exist > I could'nt find any reference to 559701082 in pg_class, pg_names

[BUGS] LibPQ Error.

2005-11-30 Thread Muhamamd Irfan Azam
-- Forwarded message --From: Muhamamd Irfan Azam <[EMAIL PROTECTED]>Date: Nov 30, 2005 2:48 PM Subject: LibPQ Error.To: pgsql-hackers@postgresql.org Hi,   I have built the libpq from $Postgres/src/interfaces/libpq on the windows plateform for 8.1.0. To build i had to comment a funct

Re: [BUGS] pg_dump: schema with OID 559701082 does not exist

2005-11-30 Thread Dirk Lutzebäck
Hi Tom, I have now deleted every temp table I know from pg_temp_nnn using your approach but still can't dump the schema: pg_dump: schema with OID 559701082 does not exist I could'nt find any reference to  559701082 in pg_class, pg_namespace or pg_proc. Regards, Dirk Tom Lane wrote: =?I