[BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords

2004-04-18 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1134 Logged by: Fabien COELHO Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: any Description:ALTER USER ... RENAME breaks md5 passwords Details: If you rename a user with a

Re: [BUGS] [7.4.2] Still "variable not found in subplan target lists"

2004-04-18 Thread Andreas Pflug
Tom Lane wrote: It doesn't fix views that contain references to the column. The new typmod would need to be propagated into the view's rule parsetree, and perhaps to the type of the view's result column if the view directly exposes the changed column (whereupon you need to recursively look at the

[BUGS] BUG #1135: integer::bit returns incorrect results

2004-04-18 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1135 Logged by: elein Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: SuSE Description:integer::bit returns incorrect results Details: * There exists a cast utils/adt.c/bitfrom

Re: [BUGS] BUG #1135: integer::bit returns incorrect results

2004-04-18 Thread elein
It may be that the cast is taking the high bit and not the low bit. I would have thought it went the other way. On Sun, Apr 18, 2004 at 04:04:08PM -0300, PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1135 > Logged by: elein > > Email

Re: [BUGS] BUG #1135: integer::bit returns incorrect results

2004-04-18 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > These all return 0. >select 1::bit; >select 2::bit; >select 111::bit; >select 101::bit; "bit" means "bit(1)" per SQL spec, so only the first of these could possibly act as you're expecting anyway. The reason none of them do is t