[BUGS] BUG #4535: Foreign Key Constraints are not respected

The following bug has been logged online: Bug reference: 4535 Logged by: PRIME Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.5 Operating system: Windows XP Description:Foreign Key Constraints are not respected Details: Hello, I had last week a problem wi

[BUGS] BUG #4536: raise doesn't add end of line

The following bug has been logged online: Bug reference: 4536 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.5 Operating system: Windows XP Description:raise doesn't add end of line Details: Many RAISE statements in a function no more adds end

Re: [BUGS] BUG #4536: raise doesn't add end of line

[EMAIL PROTECTED] wrote: > And you get: > > NOTICE: Break the 1st > line...NOTICE: eol on 2nd line...NOTICE: 3rd line It works for me, both on 8.3 and current 8.4devel: alvherre=# select r(); NOTICE: Break the 1st line... NOTICE: eol on 2nd line... NOTICE: 3rd line NOTICE: 4th line r

[BUGS] BUG #4537: role

The following bug has been logged online: Bug reference: 4537 Logged by: Marco Peixoto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.11 Operating system: debian 4.1 Description:role Details: CREATE SCHEMA agd AUTHORIZATION postgres; GRANT ALL ON SCHEMA

Re: [BUGS] BUG #4537: role

"Marco Peixoto" <[EMAIL PROTECTED]> writes: > CREATE ROLE r227602 LOGIN > ENCRYPTED PASSWORD 'md5a4d27e81e0dc6b9828cf2dc84565fb59' > NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; > GRANT agd_select TO r227602; You've got the role set to NOINHERIT. This means that it can *become* agd_select