[BUGS] BUG #7866: even after T's child-tables are deleted it cannot have select-rule

2013-02-10 Thread tim . romano
The following bug has been logged on the website: Bug reference: 7866 Logged by: Tim Romano Email address: tim.rom...@yahoo.com PostgreSQL version: 9.2.2 Operating system: Windows 7 x64 Description: After a table has been inherited, a select-rule cannot be created on

Re: [BUGS] BUG #7866: even after T's child-tables are deleted it cannot have select-rule

2013-02-10 Thread Tom Lane
tim.rom...@yahoo.com writes: After a table has been inherited, a select-rule cannot be created on it *even if its child tables are deleted and a vacuum is performed afterwards*. This isn't a bug, it's an intentional implementation restriction. I quote from the source code: * Are we

Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-10 Thread Jeff Janes
On Tue, Feb 5, 2013 at 2:00 PM, Kevin Grittner kgri...@ymail.com wrote: jim...@seagate.com jim...@seagate.com wrote: INFO: analyzing public.stream_file INFO: stream_file: scanned 3 of 2123642 pages, containing 184517 live rows and 2115512 dead rows; 3 rows in sample, 158702435

[BUGS] BUG #7865: Unexpected error code on insert of duplicate to composite primary key

2013-02-10 Thread matti . aarnio
The following bug has been logged on the website: Bug reference: 7865 Logged by: Matti Aarnio Email address: matti.aar...@methics.fi PostgreSQL version: 9.2.2 Operating system: Fedora Linux 17/18 Description: A table: CREATE TABLE example ( a TIMESTAMPNOT

[BUGS]

2013-02-10 Thread viswam mamilla
Hi, This is viswam. Iam using PostgreSQL 9.1 in my local system.when iam using this database with vb.net my application gets very slow while retriving data from database.if i used the same with access or SQL database its is very fast. Can i know what is the problem.Iam using ODBC Connection for

Re: [BUGS] BUG #7865: Unexpected error code on insert of duplicate to composite primary key

2013-02-10 Thread Tom Lane
matti.aar...@methics.fi writes: CREATE TABLE example ( a TIMESTAMPNOT NULL, b VARCHAR(256) NOT NULL, c VARCHAR(256) NOT NULL, PRIMARY KEY(a,b,c) ); Inserting a duplicate record on this is returning an SQL Error, but the status code is 0 instead of expected 23505.

Re: [BUGS]

2013-02-10 Thread John R Pierce
On 2/9/2013 3:25 AM, viswam mamilla wrote: Iam using PostgreSQL 9.1 in my local system.when iam using this database with vb.net http://vb.net my application gets very slow while retriving data from database.if i used the same with access or SQL database its is very fast. Can i know what is