Re: [BUGS] BUG #2085: pg_dump incompletely dumps ACLs

2005-12-01 Thread Tom Lane
"David Begley" <[EMAIL PROTECTED]> writes: > This means when the dump is imported to another PostgreSQL instance, the > resultant ACLs do not match those of the original instance. Please provide a concrete test case, not handwaving. regards, tom lane -

Re: [BUGS] BUG #2088: logfiles only readable by instance owner

2005-12-01 Thread Tom Lane
"Dick Snippe" <[EMAIL PROTECTED]> writes: > setting umask 077 makes sense for the data files, but not per se for the > logfile. The logfile typically contains data just as sensitive as the data files, so I disagree. regards, tom lane ---(end of bro

Re: [BUGS] BUG #2087: Bogus error message on CREATE TRIGGER with a SQL function

2005-12-01 Thread Tom Lane
"Jozef Behran" <[EMAIL PROTECTED]> writes: > CREATE FUNCTION tpokus(pokus) RETURNS pokus as $$ > SELECT $1.id,$1.sval,translate($1.sval,'abc','ABC'); > $$ LANGUAGE SQL IMMUTABLE; > CREATE TRIGGER trigger_pokus > BEFORE INSERT OR UPDATE > ON pokus FOR EACH ROW > EXECUTE PROCEDURE tpokus() >

[BUGS] BUG #2089: Documentation bug: Triggers in plpythonu

2005-12-01 Thread Jozef Behran
The following bug has been logged online: Bug reference: 2089 Logged by: Jozef Behran Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Short answer: Mandrake 10.2. Long answer: Linux sarkan 2.6.11-6mdk #1 Tue Mar 22 16:04:32 CET 2005 i686 AMD Athlo

[BUGS] BUG #2088: logfiles only readable by instance owner

2005-12-01 Thread Dick Snippe
The following bug has been logged online: Bug reference: 2088 Logged by: Dick Snippe Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Fedora Core 2 Description:logfiles only readable by instance owner Details: when redirect_stderr = true

[BUGS] BUG #2086: Giving error as wrong host and port when connect jdbc

2005-12-01 Thread Manoj Kumar
The following bug has been logged online: Bug reference: 2086 Logged by: Manoj Kumar Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.10 Operating system: Linux Description:Giving error as wrong host and port when connect jdbc Details: When we connect our ja

[BUGS] BUG #2085: pg_dump incompletely dumps ACLs

2005-12-01 Thread David Begley
The following bug has been logged online: Bug reference: 2085 Logged by: David Begley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Windows XP Description:pg_dump incompletely dumps ACLs Details: Running the following command: pg_dump

[BUGS] BUG #2087: Bogus error message on CREATE TRIGGER with a SQL function

2005-12-01 Thread Jozef Behran
The following bug has been logged online: Bug reference: 2087 Logged by: Jozef Behran Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Short answer: Mandrake 10.2. Long answer: Linux sarkan 2.6.11-6mdk #1 Tue Mar 22 16:04:32 CET 2005 i686 AMD Athlo

Re: [BUGS] BUG #2056: to_char no long takes time as input?

2005-12-01 Thread Tom Lane
Bruce Momjian writes: > Oh, one more thing. With the new patch I just posted, '0 hours' and > 'HH' returns 12: > test=> select to_char('0 hours'::interval, 'HH'); >to_char > - >12 > (1 row) Yeah, it's done that in every release since 7.2. 8.1.0 is the

Re: [BUGS] BUG #2056: to_char no long takes time as input?

2005-12-01 Thread Bruce Momjian
Oh, one more thing. With the new patch I just posted, '0 hours' and 'HH' returns 12: test=> select to_char('0 hours'::interval, 'HH'); to_char - 12 (1 row) Of course HH24 works fine. -

Re: [BUGS] BUG #2083: initdb fails with: child process was terminated

2005-12-01 Thread Seneca Cunningham
Wilfried Weiss wrote: > Configure parms: > ./configure --enable-odbc --enable-syslog > --with-includes=/opt/freeware/include --with-libraries=/opt/freew > are/lib --with-tclconfig=/opt/freeware/lib > > C-Compiler IBM C for AIX Version 6.0 > > This worked well until PostgreSQL 8.0.3. If you pass

Re: [BUGS] BUG #2084: Add WIN1253 to CLIENT_ENCODING encodings

2005-12-01 Thread Bruce Momjian
We will need someone to add this encoding. Right now I don't know anyone working on it. --- [EMAIL PROTECTED] wrote: > > The following bug has been logged online: > > Bug reference: 2084 > Logged by: > Emai

Re: [BUGS] BUGs for function returning a SETOF values on linux postgres 8.0.4, the same function runs correctly on win postgres 8.1

2005-12-01 Thread Michael Fuhr
On Wed, Nov 30, 2005 at 02:53:44PM -0700, Susan Fu wrote: > I am trying to run a very simple test on the above version. This test > works fine on my window 8.1 version. > If I am taking out the function on the 8.0.4 version on linux as just > the select (SELECT DISTINCT value FROM colors) I can see

Re: [BUGS] BUGs for function returning a SETOF values on linux postgres 8.0.4, the same function runs correctly on win postgres 8.1

2005-12-01 Thread Tom Lane
"Susan Fu" <[EMAIL PROTECTED]> writes: > Failed to execute SQL : SQL select * from tt(); failed : ERROR: control = > reached end of function without RETURN CONTEXT: PL/pgSQL function "tt" This is not a bug. 8.0 requires a RETURN in all cases. 8.1 is laxer about it. rega

[BUGS] BUG #2081: ODBC numeric(12,6) SQL_C_CHAR clobbered data

2005-12-01 Thread Farid Z
The following bug has been logged online: Bug reference: 2081 Logged by: Farid Z Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows 2000 Description:ODBC numeric(12,6) SQL_C_CHAR clobbered data Details: Server 8.1, ODBC driver Postgre

[BUGS] BUG #2082: not a bug - just a request re user acceptability

2005-12-01 Thread tre
The following bug has been logged online: Bug reference: 2082 Logged by: tre Email address: [EMAIL PROTECTED] PostgreSQL version: 8.03 Operating system: linux Description:not a bug - just a request re user acceptability Details: pgAmin III query - if there is an err

[BUGS] BUGs for function returning a SETOF values on linux postgres 8.0.4, the same function runs correctly on win postgres 8.1

2005-12-01 Thread Susan Fu
Title: BUGs for function returning a SETOF values on linux postgres 8.0.4, the same function runs correctly on win postgres 8.1 TITLE: BUGs for function returning a SETOF values on linux postgres 8.0.4, the same function with the same table runs correctly on win postgres 8.1 Dear Sir/Madam,

[BUGS] BUG #2083: initdb fails with: child process was terminated by signal 11

2005-12-01 Thread Wilfried Weiss
The following bug has been logged online: Bug reference: 2083 Logged by: Wilfried Weiss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: AIX 5.1 Description:initdb fails with: child process was terminated by signal 11 Details: make of Pos

[BUGS] BUG #2084: Add WIN1253 to CLIENT_ENCODING encodings

2005-12-01 Thread
The following bug has been logged online: Bug reference: 2084 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Debian GNU/Linux 3.1 Description:Add WIN1253 to CLIENT_ENCODING encodings Details: This encoding (WIN1253) is essen