PgSql

dblink for 8.4 should work withoutuser-mappings
What happened to this patch? --------------------------------------------------------------------------- Itagaki Takahiro wrote: contrib/dblink in 8.4 supports a server name by CREATE SERVER for connection string, but it always requires an user-mapping (by CREATE USER MAPPING). However, I think it shou... 24 Feb 2010 15:25

query cancel issues in contrib/dblink
What happened to this patch? --------------------------------------------------------------------------- Itagaki Takahiro wrote: Merlin Moncure <mmoncure(a)gmail.com> wrote: Takahiro<itagaki.takahiro(a)oss.ntt.co.jp> wrote: contrib/dblink seems to have no treatments for query cancels. ... 24 Feb 2010 19:59

Fwd: [HACKERS] A thought on Index Organized Tables
Missed the group.... So basically you want to have index-only scans, but you want them to be really slow? No Robert, i just asked him to make it optional, so that the crash safe visibility map is used only when its need is realized by the DB designer. When there is a table with no indexes/ a table w... 24 Feb 2010 14:17

BUG #4887: inclusion operator (@>) on tsqeriesbehaves not conforming to documentation
Oleg, Teodor, would you look at this? I see the same behavior in 9.0. --------------------------------------------------------------------------- Alexey Bashtanov wrote: The following bug has been logged online: Bug reference: 4887 Logged by: Alexey Bashtanov Email address: ... 24 Feb 2010 14:17

Small change of the HS document
On Tue, Dec 22, 2009 at 11:25 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: I found there is no "primary" tag for the HS parameters in config.sgml. Attached patch adds that tag. I found another small problem in HS doc; though the type of trace_recovery_messages is actually enum, it's described as string in ... 27 Feb 2010 09:54

[COMMITTERS] pgsql: Un-break pg_dump for the case ofzero-column tables.
Tom Lane wrote: Magnus Hagander <magnus(a)hagander.net> writes: 2010/2/24 Tom Lane <tgl(a)postgresql.org>: Log Message: ----------- Un-break pg_dump for the case of zero-column tables. This was evidently broken by the CREATE TABLE OF TYPE patch. It would have been no... 24 Feb 2010 10:51

[COMMITTERS] pgsql: Un-break pg_dump for thecase of zero-column tables.
Tom Lane wrote: Magnus Hagander <magnus(a)hagander.net> writes: 2010/2/24 Tom Lane <tgl(a)postgresql.org>: Log Message: ----------- Un-break pg_dump for the case of zero-column tables. This was evidently broken by the CREATE TABLE OF TYPE patch. �It would have been noticed if an... 24 Feb 2010 10:51

[COMMITTERS] pgsql: Un-break pg_dump for the case of zero-column tables.
Magnus Hagander <magnus(a)hagander.net> writes: 2010/2/24 Tom Lane <tgl(a)postgresql.org>: Log Message: ----------- Un-break pg_dump for the case of zero-column tables. This was evidently broken by the CREATE TABLE OF TYPE patch. �It would have been noticed if anyone had bothered to try dumping ... 24 Feb 2010 11:59

FW: Unable to install PostgreSQL on Windows Server 2003 SP2
On Wed, Feb 24, 2010 at 12:57 PM, William <whairs01(a)hotmail.com> wrote: Hello Pqsql-hacker, This isn't a question for -hackers. Please use the general list in future. I have tried everything and ask many but cannot get my Installation of your PostgreSQL 8.4.1.1 to install. I following all the steps exactl... 24 Feb 2010 17:43

[HACKERS] Typo in online docs
On this page: http://www.postgresql.org/docs/8.4/interactive/explicit-locking.html This chapter: 13.3.4. Advisory Locks This example: SELECT pg_advisory_lock(id) FROM foo WHERE id = 12345; -- ok SELECT pg_advisory_lock(id) FROM foo WHERE id > 12345 LIMIT 100; -- danger! SELECT pg_advisory_lock(q.id) FRO... 24 Feb 2010 08:36