Re: [BUGS] ERROR: cache lookup failed for function 0

2008-10-25 Thread Tom Lane
"David E. Wheeler" <[EMAIL PROTECTED]> writes: > Great. Is it something that could be backported, or is it not worth it? Not worth it IMO. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.p

[BUGS] log : bad file dscriptor????

2008-10-25 Thread Ati Rosselet
I'm still getting a lot of these entries in my eventlog whenever I have a reasonably large amount of logging: Event Type:Error Event Source:PostgreSQL Event Category:None Event ID:0 Date:10/22/2008 Time:9:36:28 AM User:N/A Computer:-- Description

Re: [BUGS] BUG #4493: Memory leak in informix.c

2008-10-25 Thread Michael Meskes
On Fri, Oct 24, 2008 at 08:04:24PM +, [EMAIL PROTECTED] wrote: > In file src/interfaces/ecpg/compatlib/informix.c:763 > > It seems to me that variable "temp" leaks memory here if initValue() fails: > > temp = (char *) malloc(fmt_len + 1); > > /* put all info about the long i

Re: [BUGS] bug with psql 8.3.3 on ubuntu

2008-10-25 Thread toruvinn
On Thu, 23 Oct 2008 18:46:34 +0200, Viraj Kanwade <[EMAIL PROTECTED]> wrote: psql -d mydb -U usr -t -c " select val1 from ""MyTable"" where val2 = 'abc' " OR psql -d mydb -U usr -t -c ' select val1 from "MyTable" where val2 = ''abc'' ' Both work fine on my windows machine. This is complete

Re: [BUGS] ERROR: cache lookup failed for function 0

2008-10-25 Thread Tom Lane
"David E. Wheeler" <[EMAIL PROTECTED]> writes: > I ran into this error on 8.2 a while ago, and just figured out what > was causing it. Here's a quick example on 8.2: Seems to be fixed in HEAD: regression=# SELECT '{foo}'::name[] <> '{bar}'::name[]; ERROR: operator is only a shell: name[] <> na

[BUGS] ERROR: cache lookup failed for function 0

2008-10-25 Thread David E. Wheeler
Howdy, I ran into this error on 8.2 a while ago, and just figured out what was causing it. Here's a quick example on 8.2: BEGIN; -- Compare name[]s more or less like 8.3 does. CREATE OR REPLACE FUNCTION namearray_text(name[]) RETURNS TEXT AS 'SELECT textin(array_out($1));' LANGUAGE sql IMMUT

Re: [BUGS] ftp server symlink

2008-10-25 Thread Marc G. Fournier
ftp.postgresql.org sync's off of developer.postgersql.org every ... 6 hours, I believe it is ... On Thu, 23 Oct 2008, Bruce Momjian wrote: Bruce Momjian wrote: Thanks, fixed, sources -> source. Oops, sorry, I did not fix it. I fixed it on developer.postgresql.org, but that is not where f

[BUGS] BUG #4491: regression in gist indexes

2008-10-25 Thread Jeff Frost
Looks like this is a dup of #4479: http://archives.postgresql.org/pgsql-bugs/2008-10/msg00094.php -- Forwarded message -- Date: Wed, 22 Oct 2008 19:11:51 -0300 From: [EMAIL PROTECTED] To: Jeff Frost <[EMAIL PROTECTED]> Subject: Stalled post to pgsql-bugs Your message to pgsql-bu

[BUGS] bug with psql 8.3.3 on ubuntu

2008-10-25 Thread Viraj Kanwade
Hi, I have a table which has capital characters in it. I am running the command psql -d mydb -U usr -t -c " select val1 from ""MyTable"" where val2 = 'abc' " OR psql -d mydb -U usr -t -c ' select val1 from "MyTable" where val2 = ''abc'' ' Both work fine on my windows machine. But when I t

[BUGS] BUG #4491: regression in gist indexes

2008-10-25 Thread Jeff Frost
The following bug has been logged online: Bug reference: 4491 Logged by: Jeff Frost Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Fedora 9/Gentoo/Mac OS X Description:regression in gist indexes Details: It seems that 8.3.4 has a regres

Re: [BUGS] BUG #4497: array of user defined domains can't be passed to function

2008-10-25 Thread Tom Lane
"Aleksej Butylkin" <[EMAIL PROTECTED]> writes: > I have specified a domain and trying to pass array of it into a function but > without success. Per the fine manual: Arrays of domains are not yet supported. http://www.postgresql.org/docs/8.3/static/arrays.html rega

[BUGS] BUG #4497: array of user defined domains can't be passed to function

2008-10-25 Thread Aleksej Butylkin
The following bug has been logged online: Bug reference: 4497 Logged by: Aleksej Butylkin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP SP3 Description:array of user defined domains can't be passed to function Details: I hav