[BUGS] 8.2.2 regression with indices on user functions, 8.2.1 works

Hi, Upgraded to 8.2.2 last night and had to revert to 8.2.1 first thing in the morning after hitting this problem: A trivial update like update mwdev set nick='Bezno-V-360'; fails with ERROR: attribute 1 has wrong type DETAIL: Table has type character varying, but query

[BUGS] Strange "Table has type character varying, but query expects character varying" errors

Today two of our production servers developed the following error(s): ERROR: attribute X(semi-random number here) has wrong type DETAIL: Table has type character varying, but query expects character varying. They were running PostgreSQL 8.1.4 on Ubuntu Dapper, dual-core Intel Machines. Server

[BUGS] BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed

The following bug has been logged online: Bug reference: 2970 Logged by: William ZHANG Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: i686-pc-linux-gnu Description:"FETCH ABSOLUTE -1" from a holdable cursor failed Details: DROP TABLE fo

[BUGS] BUG #2972: Upgrading 8.2.1 to 8.2.2 changes port on some commands

The following bug has been logged online: Bug reference: 2972 Logged by: Rul Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: WinXPProSp2 Description:Upgrading 8.2.1 to 8.2.2 changes port on some commands Details: I have upgraded to 8.2.2

Re: [BUGS] BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'

"Martin Pitt" <[EMAIL PROTECTED]> writes: > db> create table foo (bar VARCHAR(20) NOT NULL check (bar in > ('FOO','BAR'))); > CREATE TABLE > db> insert into foo (bar) values ('FOO'); > INSERT 0 1 > db> update foo set bar = 'BAR'; > ERROR: attribute 1 has wrong type > DETAIL: Table has type charac

Re: [BUGS] Strange "Table has type character varying, but query expects character varying" errors

"=?ISO-8859-1?Q?=DCmit_=D6ztosun?=" <[EMAIL PROTECTED]> writes: > Today two of our production servers developed the following error(s): > ERROR: attribute X(semi-random number here) has wrong type > DETAIL: Table has type character varying, but query expects character > varying. > They were run

Re: [BUGS] Strange "Table has type character varying, but query expects character varying" errors

No they're not ... at least not anything I would label 8.1.4. You should have a word with Ubuntu about their labeling practices. regards, tom lane select VERSION(); version

Re: [BUGS] Strange "Table has type character varying, but query expects character varying" errors

Hi Ümit, Ümit Öztosun [2007-02-06 17:57 +0200]: > Today two of our production servers developed the following error(s): > > ERROR: attribute X(semi-random number here) has wrong type > DETAIL: Table has type character varying, but query expects character > varying. > > They were running Postg

Re: [BUGS] BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'

Hi Tom, Tom Lane [2007-02-06 11:25 -0500]: > "Martin Pitt" <[EMAIL PROTECTED]> writes: > > db> create table foo (bar VARCHAR(20) NOT NULL check (bar in > > ('FOO','BAR'))); > > CREATE TABLE > > > db> insert into foo (bar) values ('FOO'); > > INSERT 0 1 > > > db> update foo set bar = 'BAR'; > > E

Re: [BUGS] 8.2.2 regression with indices on user functions, 8.2.1 works

Tomas Szepe <[EMAIL PROTECTED]> writes: > Upgraded to 8.2.2 last night and had to revert to 8.2.1 > first thing in the morning after hitting this problem: Can you try your production case (not just a minimal example) with this patch? http://archives.postgresql.org/pgsql-committers/2007-02/msg00128

Re: [BUGS] BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed

"William ZHANG" <[EMAIL PROTECTED]> writes: > Description:"FETCH ABSOLUTE -1" from a holdable cursor failed This bug seems to have been there since holdable cursors were first implemented. Fixed for next releases --- thanks for the report! regards, tom lane -

Re: [BUGS] BUG #2961: NULL values in subselects force NOT IN to false

On Tue, 6 Feb 2007, Aaron Logue wrote: > On Mon, 5 Feb 2007, Stephan Szabo wrote: > > On Fri, 2 Feb 2007, Aaron Logue wrote: > > > The following bug has been logged online: > > > > > > Bug reference: 2961 > > > Logged by: Aaron Logue > > > Email address: [EMAIL PROTECTED] > > >

Re: [BUGS] Strange "Table has type character varying, but query expects character varying" errors

Hi Ümit, Ümit Öztosun [2007-02-06 17:57 +0200]: > Today two of our production servers developed the following error(s): > > ERROR: attribute X(semi-random number here) has wrong type > DETAIL: Table has type character varying, but query expects character > varying. > > They were running Postg

[BUGS] BUG #2973: Compile Error with MIPSpro compiler

The following bug has been logged online: Bug reference: 2973 Logged by: Thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: IRIX 6.5 Description:Compile Error with MIPSpro compiler Details: During building the project with gmake I go

Re: [BUGS] BUG #2961: NULL values in subselects force NOT IN to false

On Mon, 5 Feb 2007, Stephan Szabo wrote: > On Fri, 2 Feb 2007, Aaron Logue wrote: > > The following bug has been logged online: > > > > Bug reference: 2961 > > Logged by: Aaron Logue > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.2.1 > > Operating system: Linux

Re: [BUGS] BUG #2962: 8.2.1 lo_creat Documentation incorrect?

Your report seems a bit confused. Want to test a little more and try again? Nonsense! My report is not confused at all. The reporter, on the other hand, is -- was! I apologize for the bogus report. I hope to someday redeem myself for my inattention to detail. -- Gary Chambers // Nothing f