[BUGS] BUG #5427: Using CASE in plpgsql causes 'ERROR: cache lookup failed'

2010-04-16 Thread Mario Splivalo
The following bug has been logged online: Bug reference: 5427 Logged by: Mario Splivalo Email address: mario.spliv...@megafon.hr PostgreSQL version: 8.4.2 Operating system: Ubuntu 9.04 Description:Using CASE in plpgsql causes 'ERROR: cache lookup failed' Details: I

Re: [BUGS] BUG #5427: Using CASE in plpgsql causes 'ERROR: cache lookup failed'

2010-04-16 Thread Mario Splivalo
Mario Splivalo wrote: > > Is this desired behavior so that first I need to check if service_id is > existent, or is this a bug? :) Huh! As I was explained od pg-sql list by Tom Lane, this should not happen, so it is a bug! :) I apologize for the inconvenience. Mike -- Sent via pgsql-

Re: [BUGS] BUG #5427: Using CASE in plpgsql causes 'ERROR: cache lookup failed'

2010-04-16 Thread Tom Lane
Mario Splivalo writes: > Huh! As I was explained od pg-sql list by Tom Lane, this should not > happen, so it is a bug! :) I apologize for the inconvenience. It's already fixed: http://archives.postgresql.org/pgsql-committers/2010-04/msg00126.php regards, tom lane -- Sen

Re: [BUGS] Reset ACL to default for pg 8.0

2010-04-16 Thread Juan C. Aragon
Tom: Is there a way to set it back to built-in-default permissions? Juan C. Aragon -Original Message- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Friday, April 16, 2010 12:33 AM To: Bruce Momjian Cc: Juan C. Aragon; pgsql-bug

Re: [BUGS] build error: strlcat/strlcpy used from heimdal libroken.so

2010-04-16 Thread Tom Lane
Martin von Gagern writes: > As I see it, Gentoo is one of the best ways to expose bugs in the build > system of any package, due to the high number of from-source builds > using various setups that Gentoo users perform. So I'd not say you'd be > adjusting pgsql to Gentoo, but you'd be fixing a bug

[BUGS] BUG #5428: Discrepency in remainder on mod function.

2010-04-16 Thread Khee Chin
The following bug has been logged online: Bug reference: 5428 Logged by: Khee Chin Email address: kheec...@gmail.com PostgreSQL version: HEAD Operating system: Debian Description:Discrepency in remainder on mod function. Details: I'm not certain if this is a bug or

Re: [BUGS] BUG #5428: Discrepency in remainder on mod function.

2010-04-16 Thread Tom Lane
"Khee Chin" writes: > I'm not certain if this is a bug or an intended behavior. > I noticed a discrepency in calculating the remainders across pgsql (PG), > wolframalpha (W) and using Knuth's description of floored division We follow whatever the C compiler's idea of modulo is. This is somewhat

Re: [BUGS] build error: strlcat/strlcpy used from heimdal libroken.so

2010-04-16 Thread Martin von Gagern
Dear Tom. On 16.04.2010 23:03, Tom Lane wrote: > It's not a bug in our build system; it's a bug in Gentoo's library set, > ie, the heimdal library is exposing a symbol that it can't actually > guarantee to provide. I still maintain that it's a bug in the build system: heimdal does expose and prov