Re: [BUGS] Array issue....

); ERROR: 23514: new row for relation "abs" violates check constraint "abs_no_check" LOCATION: ExecConstraints, execMain.c:2049 -- NTT OSS Center Tatsuhito Kasahara -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] memory leaks? using savepoint

.561) Should "CopySnapshot()" be performed in MessageContext ? Attached simple pathch to solve it... Best regards, -- NTT OSS Center Tatsuhito Kasahara kasahara.tatsuh...@oss.ntt.co.jp diff -rcN postgresql-8.3.12/src/backend/tcop/postgres.c postgresql-8.3.12_dev/src/backend/t

[BUGS] BUG #5691: Documentation typo ?

The following bug has been logged online: Bug reference: 5691 Logged by: Tatsuhito Kasahara Email address: kasahara.tatsuh...@oss.ntt.co.jp PostgreSQL version: 9.0 Operating system: Any Description:Documentation typo ? Details: The following is a part of doc/src

Re: [BUGS] make_greater_string() does not return a string in some cases

;::bytea)) Filter: (name ~~ '西%'::text) Total runtime: 0.053 ms (4 rows) === Is the idea reasonable ? Best regards, -- NTT OSS Center Tatsuhito Kasahara -- Sent via pgsql-bug

[BUGS] make_greater_string() does not return a string in some cases

ual time=22.598..22.599 rows=1 loops=1) Filter: (name ~~ '西%'::text) <-- Seq-scan is chosen ! Total runtime: 22.626 ms (3 rows) ======= Attached patch solve above problem. Best regards, -- NTT OSS Center Tatsuhit

[BUGS] dblink generates orphaned connections

= I think that the dblink should not ereport() before PQfinish(conn) in dblink_record_internal() when we use temporary connection. Attached the brief patch to avoid above problem. Best regards, -- Tatsuhito Kasahara kasahara.t

[BUGS] BUG #4244: ALTER TABLE ... NO INHERIT problem

The following bug has been logged online: Bug reference: 4244 Logged by: Tatsuhito Kasahara Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: RedHat Linux 5.2 Description:ALTER TABLE ... NO INHERIT problem Details: Hi. I performed &qu

Re: [BUGS] BUG #4170: Rows estimation which are cast from TEXT is inaccurate.

224.98 rows=63 width=8) (actual time=0.041..18.645 rows=60 loops=1) Filter: (id < ('2008-5-14 00:01:00'::text)::timestamp without time zone) Total runtime: 18.706 ms (3 rows) = Best regards. -- Tatsuhito Kasahara [EMAIL PROTECTED] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).

I reported this. Best regards. -- NTT OSS Center Tatsuhito Kasahara [EMAIL PROTECTED] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).

The following bug has been logged online: Bug reference: 4076 Logged by: Tatsuhito Kasahara Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.11 Operating system: Red Hat Enterprise Linux 5.1 Description:"IS NOT NULL (IS NULL)" return wrong answer