Re: [BUGS] BUG #3928: INFORMATION_SCHEMA does not give results if a user is allowed only access via ROLE

2008-02-05 Thread Tom Lane
"Bart Heupers" <[EMAIL PROTECTED]> writes: > If a user wants to get data from the INFORMATION_SCHEMA about a table and > he has access to the table via a ROLE > then the INFORMATION_SCHEMA will not return results. There seems to be a mistake in your example. You show granting privilege to tabl

Re: [BUGS] BUG #3933: Update problem for 3 Foreign Keys referencing 1 field in another table (I'm not newbie in using SQL)

2008-02-05 Thread Heikki Linnakangas
irfin wrote: The following bug has been logged online: Bug reference: 3933 Logged by: irfin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP Professional Service Pack 2 (i586) Description:Update problem for 3 Foreign Keys refere

[BUGS] BUG #3933: Update problem for 3 Foreign Keys referencing 1 field in another table (I'm not newbie in using SQL)

2008-02-05 Thread irfin
The following bug has been logged online: Bug reference: 3933 Logged by: irfin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP Professional Service Pack 2 (i586) Description:Update problem for 3 Foreign Keys referencing 1 field

Re: [BUGS] BUG #3929: RULE causes unintended update of SEQUENCE

2008-02-05 Thread Tom Lane
"Arjan Tuinhout" <[EMAIL PROTECTED]> writes: > -- However the intended code does not work: appearantly the SEQUENCE is > update by calling the RULE; proofed by the workaround. This is the expected behavior with a rule --- it's a macro, so multiple references to the same input value risk multiple e

Re: [BUGS] BUG #3932: utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded

2008-02-05 Thread Florian Wunderlich
Alvaro Herrera wrote: Florian Wunderlich wrote: - input file in encoding iso-8859-1: set client_encoding='iso-8859-1'; select upper('ä'), lower('Ä'); (note: the argument to upper is a lower case a umlaut, while the argument to lower is an upper case a umlaut) - database "iso" with encoding i

Re: [BUGS] BUG #3932: utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded

2008-02-05 Thread Alvaro Herrera
Florian Wunderlich wrote: > - input file in encoding iso-8859-1: > > set client_encoding='iso-8859-1'; > select upper('ä'), lower('Ä'); > > (note: the argument to upper is a lower case a umlaut, while the argument to > lower is an upper case a umlaut) > > - database "iso" with encoding iso-8859

[BUGS] BUG #3931: problems in the install process

2008-02-05 Thread Rafael Aguilar
The following bug has been logged online: Bug reference: 3931 Logged by: Rafael Aguilar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0. Operating system: Windows Vista 32 bits Description:problems in the install process Details: Dear Sir. I have problems i

[BUGS] BUG #3932: utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded

2008-02-05 Thread Florian Wunderlich
The following bug has been logged online: Bug reference: 3932 Logged by: Florian Wunderlich Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Debian unstable Description:utf-8 and upper()/lower(): PANIC: ERRORDATA_STACK_SIZE exceeded Details

Re: [BUGS] BUG #3930: initdb failed - "postgres" not found

2008-02-05 Thread Dave Page
On Feb 5, 2008 10:44 AM, Markus Eisenmann <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 3930 > Logged by: Markus Eisenmann > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.0 > Operating system: Windows XP SP2 - german >

[BUGS] BUG #3930: initdb failed - "postgres" not found

2008-02-05 Thread Markus Eisenmann
The following bug has been logged online: Bug reference: 3930 Logged by: Markus Eisenmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Windows XP SP2 - german Description:initdb failed - "postgres" not found Details: After a successfu

[BUGS] BUG #3929: RULE causes unintended update of SEQUENCE

2008-02-05 Thread Arjan Tuinhout
The following bug has been logged online: Bug reference: 3929 Logged by: Arjan Tuinhout Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Kubuntu 6.06 Dapper Description:RULE causes unintended update of SEQUENCE Details: -- The SQL code expl

[BUGS] BUG #3928: INFORMATION_SCHEMA does not give results if a user is allowed only access via ROLE

2008-02-05 Thread Bart Heupers
The following bug has been logged online: Bug reference: 3928 Logged by: Bart Heupers Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux & Windows Description:INFORMATION_SCHEMA does not give results if a user is allowed only access via