Re: [BUGS] BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM

2008-07-02 Thread Tom Lane
Carl-Daniel Hailfinger <[EMAIL PROTECTED]> writes: > On 01.07.2008 16:32, Tom Lane wrote: >> This is not a bug, since we do not claim support for feature F641. > Thanks for the information. Is there any plan to support that feature in > 8.4? I don't know of anyone working on it at the moment.

Re: [BUGS] BUG #4275: Multicolumn subquery expression not allowed on both sides of IS DISTINCT FROM

2008-07-02 Thread Carl-Daniel Hailfinger
On 01.07.2008 16:32, Tom Lane wrote: > "Carl-Daniel Hailfinger" <[EMAIL PROTECTED]> writes: > >> This works: >> # SELECT ROW(true,true)=(SELECT true,true); >> > > >> This doesn't: >> # SELECT (SELECT true,true)=(SELECT true,true); >> Error: 42601: subquery must return only one column >>

Re: [BUGS] BUG #4274: uuid returns duplicate values

2008-07-02 Thread Hiroshi Saito
Hi. Sorry, late reactionNow, private time has only a few. Umm, It seems that the bug is probably contained in another part. I will investigate at a weekend again. Anyway, thank you for useful information.! Regards, Hiroshi Saito - Original Message - From: "Eric P. Melbardis" <[

Re: [BUGS] psql: FATAL: the database system is starting up

2008-07-02 Thread Valentin Bogdanov
It's 8.1.11 --- On Wed, 2/7/08, Tom Lane <[EMAIL PROTECTED]> wrote: > From: Tom Lane <[EMAIL PROTECTED]> > Subject: Re: [BUGS] psql: FATAL: the database system is starting up > To: [EMAIL PROTECTED] > Cc: pgsql-bugs@postgreSQL.org > Date: Wednesday, 2 July, 2008, 3:19 PM > Valentin Bogdanov <[EM

Re: [BUGS] psql: FATAL: the database system is starting up

2008-07-02 Thread Tom Lane
Valentin Bogdanov <[EMAIL PROTECTED]> writes: >> What PG version is this, exactly? What files did you >> delete (any of Postgres' files)? > It's 8.1 and no I didn't delete any postgres files, just some old proxy logs. 8.1.what? regards, tom lane -- Sent via pgsql-bugs

Re: [BUGS] BUG #4274: uuid returns duplicate values

2008-07-02 Thread Eric P. Melbardis
Hi I would suspect that the clock used may not be precise enough Not with standing, why not use the windows CreateUUID?? Slower system seems to fare better... (please see results below) Regards Eric --- My office system is xeon (duo core 5160) 3.00 ghz, 2 gig-ram psql:q.sql