[BUGS] BUG #1112: round(float-type does not work)

2004-03-24 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1112 Logged by: Ulf Mehlig Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian Linux/i386 "testing" Description:round(float-type does not work) Details: After upgrading to 7.

[BUGS] BUG #1113: Default template databases grant CREATE to PUBLIC

2004-03-24 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1113 Logged by: Oliver Elphick Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian Linux Description:Default template databases grant CREATE to PUBLIC Details: The default da

[BUGS] BUG #1114: REVOKE done by non-privileged user claims success

2004-03-24 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1114 Logged by: Oliver Elphick Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian Linux Description:REVOKE done by non-privileged user claims success Details: When REVOKE is

Re: [BUGS] BUG #1113: Default template databases grant CREATE to PUBLIC

2004-03-24 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The default should be for CREATE permissions on the public schema to be > revoked from PUBLICc. Not a chance. regards, tom lane ---(end of broadcast)--- TIP 8: explain a

Re: [BUGS] BUG #1114: REVOKE done by non-privileged user claims success

2004-03-24 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > When REVOKE is used on an object for which the current user does not have > GRANT privilege, the operation fails but "REVOKE" is returned as if it had > succeeded: Looking at the code, this seems to be intentional, because the privilege check

Re: [BUGS] BUG #1113: Default template databases grant CREATE to PUBLIC

2004-03-24 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> writes: > On Wed, 2004-03-24 at 15:55, Tom Lane wrote: >> "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The default should be for CREATE permissions on the public schema to be > revoked from PUBLICc. >> >> Not a chance. > But why? I didn't think this a