[BUGS] Error number -2147467259 with driver PgOleDb

2005-09-03 Thread al979663
Hi, We are developing a system with PostgreSQL in Windows through VB application. We are getting the following error while save records. Description: Unhandled status in query result Err Number: -2147467259 Source: PgOleDb (This error is occuring everytime after the 270 -300 record saved) Ca

Re: [BUGS] extra columns in intermediate nodes not being removed by top level of executor

2005-09-03 Thread Michael Fuhr
On Sat, Sep 03, 2005 at 04:29:25PM -0400, Allan Wang wrote: > I'm using 8.1 from CVS head of about two days ago. > > Extra columns seem to be on sum(plays.length), videos.path, videoid Here's a simplified, complete test case: CREATE TABLE foo ( x integer, y integer ); INSERT INTO foo

[BUGS] extra columns in intermediate nodes not being removed by top level of executor

2005-09-03 Thread Allan Wang
I'm using 8.1 from CVS head of about two days ago. Extra columns seem to be on sum(plays.length), videos.path, videoid create or replace view niceplays as SELECT count(*) AS plays, summary("substring"(v.path, '[^/]+$'::text), 50) AS filename, avg(p.length)::interval(0) AS avg, sum(p.length)::inte

Re: [BUGS] BUG #1860: Insert failed due to unique index

2005-09-03 Thread Peter Eisentraut
Viswanath Ramineni wrote: > I have a table with a primary key on id (integer) column and a unique > index on varchar(10) column. Insertion fails when the value of the > unique column is substring of an existing value. For example, if I > have a row with the unique column value 'TEST1', it will not

Re: [BUGS] BUG #1861: Possible Incompatibly with NOD32 AV.

2005-09-03 Thread Bruce Momjian
I would contact the people who created NOD32, give them the URL to pginstaller, and tell them it breaks PostgreSQL. --- Thomas Turn Jensen wrote: > > The following bug has been logged online: > > Bug reference: 1861 >

[BUGS] BUG #1861: Possible Incompatibly with NOD32 AV.

2005-09-03 Thread Thomas Turn Jensen
The following bug has been logged online: Bug reference: 1861 Logged by: Thomas Turn Jensen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP SP2 Description:Possible Incompatibly with NOD32 AV. Details: I'm aware this will not

Re: [BUGS] BUG #1858: setting search path in select doesn't (always) work

2005-09-03 Thread Dick Kniep
Hi list, I reported the bug because I was convinced it was something fishy, however, the bug I reported proved to be something completely else. I don't even know if it is a bug at all. If you do a set search_path; the path is set correctly according to the rules of autocommit and everything el

[BUGS] BUG #1860: Insert failed due to unique index

2005-09-03 Thread Viswanath Ramineni
The following bug has been logged online: Bug reference: 1860 Logged by: Viswanath Ramineni Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Beta Operating system: Windows 2000 Professional Description:Insert failed due to unique index Details: I have a tabl