The following bug has been logged online:
Bug reference: 4758
Logged by: sergey
Email address: op...@ydk.com.ua
PostgreSQL version: 8.4beta1
Operating system: Linux 2.6.25-gentoo-r8
Description:deadlock.c:944
Details:
i have table with 15 records
Table "public
Congratulations PostgreSQL-Team for your work!
with the current 8.4 B1 Version of PostgreSQL the bad execution time
of my example-Query containing a NOT EXISTS
changed from "aborted after hours" to just 5 seconds - double as quick
as my result with MS-SQL.
That's wonderful!
> insert into t1
> se
The following bug has been logged online:
Bug reference: 4759
Logged by: Frank Heikens
Email address: fr...@jakaree.com
PostgreSQL version: 8.4beta1
Operating system: Windows XP
Description:RETURNS TABLE not supported in pgAdmin
Details:
pgAdmin 1.10.0 Beta 1 (and o
Alexander Steffens writes:
> I assume there is now a hashed ANTI-SEMI-JOIN operator implemented?
What does EXPLAIN say about it?
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql
"sergey" writes:
> ERROR: 40P01: deadlock detected
> DETAIL: Process 10237 waits for ShareLock on transaction 165664; blocked by
> process 10242.
> Process 10242 waits for ShareLock on transaction 165691; blocked by
> process 10237.
> Process 10237: UPDATE test SET y=1;
>
"Frank Heikens" writes:
> pgAdmin 1.10.0 Beta 1 (and older) doesn't support the new returning TABLE
> and translates the returning columns to IN-parameters.
I think you'd be better advised to report this on the pgAdmin lists.
The pgAdmin authors might happen to read it here but it's not the
best
The following bug has been logged online:
Bug reference: 4760
Logged by:
Email address: cueber...@web.de
PostgreSQL version: 8.4-beta1
Operating system: Windows XP
Description:unexpected syntax error with CREATE DATABASE
Details:
CREATE DATABASE "XYZ"
WITH ENCODI
cueber...@web.de wrote:
...
PostgreSQL version: 8.4-beta1
...
CREATE DATABASE "XYZ"
WITH ENCODING='UTF8'
OWNER=postgres
COLLATE='German_Germany'
CTYPE='German_Germany'
CONNECTION LIMIT=-1;
The COLLATE and CTYPE options were renamed to LC_COLLATE and LC_CTYPE a
f
