PgSql

[HACKERS] walreceiver is uninterruptible on win32
Hi, http://archives.postgresql.org/pgsql-hackers/2010-01/msg01672.php On win32, the blocking libpq functions like PQconnectdb() and PQexec() are uninterruptible since they use the vanilla select() instead of our signal emulation layer compatible select(). Nevertheless, currently walreceiver uses them to establis... 10 Mar 2010 04:10

Warning about invalid .pgpass passwords
On Wed, Mar 10, 2010 at 11:52 AM, Bruce Momjian <bruce(a)momjian.us> wrote: The attached patch reports the fact that .pgpass was used if the libpq connection fails: + /* + * If the connection failed, we should mention that + * we got the password from .pgpass in case that + * password is wrong. + */ + i... 13 Mar 2010 10:51

Access violation from palloc, Visual Studio 2005, C-language function
"Kevin Flanagan" <kevin-f(a)linkprior.com> writes: Environment: Windows Vista, PostgreSQL 8.4 (1-click installer), Visual Studio 2005 sp1. I have a bare-bones DLL built as per the above, compiling the 'add_one' and 'copytext' samples found at http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (v... 10 Mar 2010 18:41

[HACKERS] Access violation from palloc, Visual Studio 2005, C-language function
Environment: Windows Vista, PostgreSQL 8.4 (1-click installer), Visual Studio 2005 sp1. I have a bare-bones DLL built as per the above, compiling the 'add_one' and 'copytext' samples found at http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (version 1 calling convention), compiled as 'C'. I can use 'a... 9 Mar 2010 19:14

Dyamic updates of NEW with pl/pgsql
2010/3/9 strk <strk(a)keybit.net>: How can a pl/pgsql trigger change the values of dynamic fields in NEW record ? By "dynamic" I mean that the field name is a variable in the trigger context. I've been told it's easy to do with pl/perl but I'd like to delive a pl/pgsql solution to have less dep... 17 Mar 2010 10:13

patch (for 9.1) string functions
On Mar 9, 2010, at 6:30 AM, Pavel Stehule wrote: this patch contains a string formatting function "format" postgres=# select format('some message: % (current user: %)', current_date, current_user); format ------------------------------------------------ some message: 2010-03-... 10 Mar 2010 03:04

[HACKERS] patch (for 9.1) string functions
Hello this patch contains a string formatting function "format" postgres=# select format('some message: % (current user: %)', current_date, current_user); format ------------------------------------------------ some message: 2010-03-09 (current user: pavel) (1 row) this patch add new... 9 Mar 2010 10:02

lock mode for ControlFileLock which pg_start_backupuses
Takahiro Itagaki wrote: Fujii Masao <masao.fujii(a)gmail.com> wrote: The attached patch changes the lock mode which pg_start_backup() uses. Is it worth applying this patch? I think the patch is reasonable to represent what we are doing, even if there is no performance benefits from it. Agreed. ... 9 Mar 2010 05:38

Visual Studio 2005, C-language function - avoiding hacks?
Magnus Hagander <magnus(a)hagander.net> wrote: The existing mechanism works (as demonstrated by the fact that the contrib modules work on Windows). Did we use non-standard tools except msvc in the build framework for core code? And what should I do for an external project? Yes,... 9 Mar 2010 03:28

[HACKERS] lock mode for ControlFileLock which pg_start_backup uses
Hi, Currently pg_start_backup() accesses the shared ControlFile by using ControlFileLock with LW_EXCLUSIVE lock mode. But since that access is read-only operation, LW_SHARED should be chosen instead of LW_EXCLUSIVE. The attached patch changes the lock mode which pg_start_backup() uses. Is it worth applying th... 8 Mar 2010 20:56