Re: [BUGS] Column Name parameter problem

2005-09-29 Thread Tomas Zerolo
On Wed, Sep 28, 2005 at 12:25:54PM -0700, vishal saberwal wrote: hi, I am trying to create a stored procedure that takes a column name as parameter and then uses it to sort the table for result set. create or replace function ptest_Sort_Select(varchar) returns setof ptest1 as $$ DECLARE

[BUGS] BUG #1921: NULLNULL ?!?!?!?!?!?!?

2005-09-29 Thread BogDan Vatra
The following bug has been logged online: Bug reference: 1921 Logged by: BogDan Vatra Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: win xp pro Description:NULLNULL ?!?!?!?!?!?!? Details: Please execute this query: create table test

Re: [BUGS] Postgresql problem in AIX 5.3

2005-09-29 Thread Chris Browne
[EMAIL PROTECTED] (Kelvin Lau) writes: I have a question regarding Postgresql on AIX 5.3's compatibility, since there are reported problems for this combination in newsgroup. I have also tried to install it also. The installation was successful and there was a message indicating that.

[BUGS] BUG #1920: Installer no WIN1252 UTF8 selection

2005-09-29 Thread Andrew
The following bug has been logged online: Bug reference: 1920 Logged by: Andrew Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1-B2 (win32) Operating system: XP Professional Description:Installer no WIN1252 UTF8 selection Details: I can't select those 2

Re: [BUGS] BUG #1920: Installer no WIN1252 UTF8 selection

2005-09-29 Thread Magnus Hagander
The following bug has been logged online: Bug reference: 1920 Logged by: Andrew Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1-B2 (win32) Operating system: XP Professional Description:Installer no WIN1252 UTF8 selection Details: I can't select

Re: [BUGS] BUG #1921: NULLNULL ?!?!?!?!?!?!?

2005-09-29 Thread Gaetano Mendola
BogDan Vatra wrote: The following bug has been logged online: Bug reference: 1921 Logged by: BogDan Vatra Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: win xp pro Description:NULLNULL ?!?!?!?!?!?!? Details: Please execute

Re: [BUGS] BUG #1921: NULLNULL ?!?!?!?!?!?!?

2005-09-29 Thread j6m
Hi, The SQL standard requires that null values do not equate any value, including themselves. Corrected syntax of your queries is shown below. If I recall it correctly, this nehaviour was enforced in the 7.2-7.3 or 7.1-7.2 evolution. If for instance a char(1) field called 'myfield' admits

Re: [BUGS] BUG #1920: Installer no WIN1252 UTF8 selection

2005-09-29 Thread Magnus Hagander
I can't select those 2 options for database encoding when initializing cluster from the Win32 installer. This is in the list of new features for 8.1. Most likely just a minor oversight on the installer and not the database itself. Please correct me if I'm not raising this

Re: [BUGS] BUG #1921: NULLNULL ?!?!?!?!?!?!?

2005-09-29 Thread David Fetter
On Thu, Sep 29, 2005 at 09:38:54AM +0100, BogDan Vatra wrote: The following bug has been logged online: Bug reference: 1921 Logged by: BogDan Vatra Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: win xp pro Description:NULLNULL

[BUGS] horology regression test failure

2005-09-29 Thread Martin Pitt
Hi! On almost all Debian platforms the horology test for 8.0.3 fails. Sometimes it works on a platform, sometimes not, I did not yet find a pattern, but most often it fails with something like *** ./expected/horology.out Sun Jul 11 04:57:20 2004 --- ./results/horology.out Thu Sep 29

Re: [BUGS] horology regression test failure

2005-09-29 Thread Alvaro Herrera
On Thu, Sep 29, 2005 at 11:08:22PM +0200, Martin Pitt wrote: On almost all Debian platforms the horology test for 8.0.3 fails. Sometimes it works on a platform, sometimes not, I did not yet find a pattern, but most often it fails with something like I think this test is supposed to fail when

Re: [BUGS] horology regression test failure

2005-09-29 Thread Tom Lane
Martin Pitt [EMAIL PROTECTED] writes: On almost all Debian platforms the horology test for 8.0.3 fails. Before PG 8.0, I'd have said you were running with a timezone library that didn't understand about DST before 1970. It shouldn't be happening in 8.0 though. regards,

Re: [BUGS] horology regression test failure

2005-09-29 Thread Martin Pitt
Hi Tom! Tom Lane [2005-09-29 17:50 -0400]: Martin Pitt [EMAIL PROTECTED] writes: On almost all Debian platforms the horology test for 8.0.3 fails. Before PG 8.0, I'd have said you were running with a timezone library that didn't understand about DST before 1970. It shouldn't be happening

[BUGS] [patch] krb5 authentication on multihomed server hosts

2005-09-29 Thread Martin Pitt
Hi! I recently got a Debian bug report [1] that says: It is not always possible to use krb5 authentication to a server that is listening on multiple interfaces other than to the 'primary' interface. More specifically: src/backend/libpq/auth.c pg_krb5_init() fills in the pg_krb5_server

Re: [BUGS] Column Name parameter problem

2005-09-29 Thread vishal saberwal
hi tomas, The solution you sent worked, but i have another rissue related to this. I am trying to create a stored procedure that can accept TableName, ColumnName as parameter and return teh records pertaining to them. This way, i will not need to make the procedures for every table. But the

Re: [BUGS] [patch] krb5 authentication on multihomed server hosts

2005-09-29 Thread Bruce Momjian
I think this is fixed in CVS and will be in 8.1. We now have in postgresql.conf: # Kerberos #krb_server_keyfile = '' #krb_srvname = 'postgres' #krb_server_hostname = '(any)' # if not set, matches any keytab entry #krb_caseins_users = off