The following bug has been logged online:
Bug reference: 6164
Logged by: Kyle Fox
Email address: kyle@gmail.com
PostgreSQL version: 9.0
Operating system: Mac OSX 10.6.8
Description:Flashing dialog
Details:
I used the installer to install Postgres 9.0 on my Mac
On Mon, Mar 09, 2009 at 10:03:34AM -0500, Kevin Grittner wrote:
> >>> Kyle Butt wrote:
>
> > select (bug_function()).*;
>
> > psql:sql/bug_example.sql:32: NOTICE: in bug_function
> > psql:sql/bug_example.sql:32: NOTICE: in bug_function
> >
h | i | j
---+---+---+---+---+---+---+---+---+---
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
(1 row)
ROLLBACK
---
Kyle Butt
pgp2Yva9sDFPb.pgp
Description: PGP signature
When specifying criteria in a where claue such as
user_id = 'value' if a non-numeric is entered the
query returns back all rows.
user_id = user_id brings back every user_id instead of
error because user_id is a numeric field and it
shouldnt be able to accept ch
- Postgresql 7.1RC2
- installed from the RPM on Red Hat 7.0 on x86
- fresh databases built (initdb)
- error happens connecting with psql on UNIX domain sockets,
but there's no evidence it's exclusive to that interface
I am not sure whether this is a bug or a tightening-up of a previous
loose SQL
