PgSql

Open Item: invalid declspec for PG_MODULE_MAGIC
Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> writes: * Should we backport the fix to previous releases? Certainly not. It hasn't gotten through beta, and the risk of breaking third-party modules is nonnegligible. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresq... 25 May 2010 23:27

Open Item: pg_controldata - machine readable?
Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> writes: There is an open item "pg_controldata - machine readable?" in the list: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items The proposal by Joe Conway is adding a new contib module. http://archives.postgresql.org/message-id/4B959D7A.6010907@j... 1 Jun 2010 02:12

[HACKERS] libpq should not be using SSL_CTX_set_client_cert_cb
I've been experimenting with SSL setups involving chains of CA certificates, ie, where the server or client cert itself is signed by an intermediate CA rather than a trusted root CA. This appears to work well enough on the server side if you configure the server correctly (see discussion of bug #5468). However, l... 25 May 2010 23:27

[HACKERS] Open Item: invalid declspec for PG_MODULE_MAGIC
This open item is for replacing PGDLLIMPORT markers for PG_MODULE_MAGIC and PG_FUNCTION_INFO_V1 to __declspec(dllexport) because they are always expored by user modules rather than by the core codes. http://archives.postgresql.org/message-id/20100329184705.A60E.52131E4D(a)oss.ntt.co.jp The fix is simple, so I think... 25 May 2010 23:27

[HACKERS] Fwd: PDXPUG Day at OSCON 2010
It was recommended to me to forward this to -hackers. Regards, Mark ---------- Forwarded message ---------- From: Mark Wong <markwkm(a)gmail.com> Date: Tue, May 18, 2010 at 6:57 AM Subject: PDXPUG Day at OSCON 2010 To: pgsql-announce(a)postgresql.org Thanks to the generosity of O'Reilly, we will be having a... 25 May 2010 22:21

[HACKERS] Open Item: pg_controldata - machine readable?
There is an open item "pg_controldata - machine readable?" in the list: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items The proposal by Joe Conway is adding a new contib module. http://archives.postgresql.org/message-id/4B959D7A.6010907(a)joeconway.com http://github.com/jconway/pg_controldata Should we... 25 May 2010 22:21

Fwd: Hiding data in postgresql
On Tue, May 25, 2010 at 3:39 PM, Hector Beyers <hqbeyers(a)gmail.com> wrote: Hi guys, (I tried the question in another forum first) Does someone have any ideas how I can hide data without the meta data noticing? To explain further, I would like to save some collection of data where the meta-data does no... 25 May 2010 22:21

[HACKERS] mergejoin null handling (was Re: [PERFORM] merge join killing performance)
Scott Marlowe <scott.marlowe(a)gmail.com> writes: So, Tom, so you think it's possible that the planner isn't noticing all those nulls and thinks it'll just take a row or two to get to the value it needs to join on? I dug through this and have concluded that it's really an oversight in the patch I wrote some ... 25 May 2010 16:52

tsvector pg_stats seems quite a bit off.
Excerpts from Jesper Krogh's message of mié may 19 15:01:18 -0400 2010: But the distribution is very "flat" at the end, the last 128 values are excactly 1.00189e-05 which means that any term sitting outside the array would get an estimate of 1.00189e-05 * 350174 / 2 = 1.75 ~ 2 rows I don't know if ... 1 Jun 2010 02:12

[PATCH] Add XMLEXISTS function from the SQL/XML standard
Robert Haas wrote: On Tue, May 25, 2010 at 12:04 PM, Mike Fowler <mike(a)mlfowler.com> wrote: Erik Rijkers wrote: libxml2.x86_64 2.6.26-2.1.2.8 installed libxml2-devel.x86_64 2.6.26-2.1.2.8 installed Thanks for testing my patch Erik. It turns out I've got... 25 May 2010 14:39