Re: [BUGS] BUG #2842: Installation procedure

2006-12-19 Thread Magnus Hagander
Kevin Macdonald wrote: > The following bug has been logged online: > > Bug reference: 2842 > Logged by: Kevin Macdonald > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2 > Operating system: Windows XP > Description:Installation procedure > Details: > > Hel

Re: [BUGS] No error when FROM is missing in subquery

2006-12-19 Thread Kevin Grittner
>>> On Tue, Dec 19, 2006 at 9:58 AM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: >> I'm having trouble seeing how it is a useful construct in the context >> of a scalar subquery. A non- standard extension should be useful in

Re: [BUGS] BUG #2840: \set HISTCONTROL ignoredups doesn't work in psql

2006-12-19 Thread Tom Lane
"Ned T. Crigler" <[EMAIL PROTECTED]> writes: > Description:\set HISTCONTROL ignoredups doesn't work in psql Ooops, seems it got broken somewhere between 8.1 and 8.2. Thanks for the report! regards, tom lane ---(end of broadcast)---

Re: [BUGS] BUG #2840: \set HISTCONTROL ignoredups doesn't work in psql

2006-12-19 Thread Gurjeet Singh
On 12/19/06, Ned T. Crigler <[EMAIL PROTECTED]> wrote: In psql, doing: \set HISTCONTROL ignoredups select 1; select 1; select 1; select 1; select 1; adds every select statement into the history, instead of ignoring the duplicate statements. Can you please let us know the environment? If it

Re: [BUGS] No error when FROM is missing in subquery

2006-12-19 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > I'm having trouble seeing how it is a useful construct in the context > of a scalar subquery. A non-standard extension should be useful in some > way. There is 0 chance that we'd disallow it at the top level after allowing it all these years. And pr

[BUGS] BUG #2839: after record with NULL field, query result is wrong

2006-12-19 Thread Vladimir
The following bug has been logged online: Bug reference: 2839 Logged by: Vladimir Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: FreeBSD Description:after record with NULL field, query result is wrong Details: create table tst (a int[])

[BUGS] BUG #2840: \set HISTCONTROL ignoredups doesn't work in psql

2006-12-19 Thread Ned T. Crigler
The following bug has been logged online: Bug reference: 2840 Logged by: Ned T. Crigler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Linux (Debian unstable) Description:\set HISTCONTROL ignoredups doesn't work in psql Details: In psql,

[BUGS] BUG #2842: Installation procedure

2006-12-19 Thread Kevin Macdonald
The following bug has been logged online: Bug reference: 2842 Logged by: Kevin Macdonald Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:Installation procedure Details: Hello, I downloaded postgresql-8.2.0-1.zip and

Re: [BUGS] No error when FROM is missing in subquery

2006-12-19 Thread Kevin Grittner
>>> On Tue, Dec 19, 2006 at 9:23 AM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: >> It's easy to see how it resolves the column references; but the syntax >> is still not compliant with the SQL standard. The FROM clause is >>

Re: [BUGS] No error when FROM is missing in subquery

2006-12-19 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > It's easy to see how it resolves the column references; but the syntax > is still not compliant with the SQL standard. The FROM clause is > required. We could call it a PostgreSQL extension, but I'm curious if > anyone actually finds it useful. You'

Re: [BUGS] No error when FROM is missing in subquery

2006-12-19 Thread Kevin Grittner
>>> On Mon, Dec 18, 2006 at 11:48 PM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > > The reason there's no error thrown is that the reference to mov_id in > the sub- SELECT is a perfectly legal outer reference to the mov_id column > available from the upper SELECT. If th