Re: [BUGS] BUG #1059: Second Call of a PGSQL-function fails

2004-01-21 Thread Richard Huxton
On Wednesday 21 January 2004 21:24, PostgreSQL Bugs List wrote: > Bug reference: 1059 > Logged by: Wilhelm > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4 > Operating system: Linux > Description:Second Call of a PGSQL-function fails Wilhelm - this is a k

[BUGS] BUG #1059: Second Call of a PGSQL-function fails

2004-01-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1059 Logged by: Wilhelm Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Description:Second Call of a PGSQL-function fails Details: -- The Source: -- Init Stuff DROP FUNC

Re: [BUGS] Readline lib configure error. Help

2004-01-21 Thread Tom Lane
Roman Avdeenko <[EMAIL PROTECTED]> writes: > Use RH Linux90. > Try configure postgresql-7.4.1 > Type ./configure > Error is > checking for readline... no It works for me on a stock RHL 9 machine (or I think it's stock, anyway, it's not my machine...). > Have installed readline-4.3-5, readline41-4

Re: [BUGS] 7.3.5 initdb failure on Irix 6.5.18

2004-01-21 Thread Craig Ruff
Here is what I discovered about this problem. The MIPSpro 7.4.1 C compiler apparently has a structure assignment code generation bug that is triggered at backend/access/transam/xlog.c:2683 LogwrtResult.Write = LogwrtResult.Flush = EndOfLog; EndOfLog and LogwrtResult.Write are correct, bu

Re: [BUGS] BUG #1058: unexpected output when using timezone() and to_char()

2004-01-21 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > however, > select to_char(timezone('PST',CURRENT_TIMESTAMP),' Day Mon DD > HH24:MI:SS TZ'); > returns: > Wednesday Jan 21 2004 07:07:44 > Notice the Time zone field (specified by 'TZ' in the to_char) is missing > from the output.

[BUGS] Readline lib configure error. Help

2004-01-21 Thread Roman Avdeenko
Hi! Use RH Linux90. Try configure postgresql-7.4.1 Type ./configure Error is checking for readline... no configure: error: readline library not found If you have readline already installed, see config.log for details on the failure. It is possible the compiler isn't looking in the proper director

[BUGS] BUG #1058: unexpected output when using timezone() and to_char()

2004-01-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1058 Logged by: Blake Crosby Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: FreeBSD 5.1-RELEASE-p11 Description:unexpected output when using timezone() and to_char() Details:

Re: [BUGS] BUG #1056: ecpg ignores WHENEVER NOT FOUND

2004-01-21 Thread Michael Meskes
On Tue, Jan 20, 2004 at 04:44:30PM -0400, PostgreSQL Bugs List wrote: > Description:ecpg ignores WHENEVER NOT FOUND > ... > This problem occurs with both 7.4 and 7.4.1. The problem does not occur at > ... > I have a statement in my program such as: > > EXEC SQL WHENEVER NOT FOUND GOTO