PgSql

libpq naming on Win64
On 5/01/2010 6:52 PM, Dave Page wrote: There is likely to be a long period where many Windows packages for PostgreSQL are 32 bit only. Due to the way Windows searches for DLLs, Windows installations of PostgreSQL tend to install libpq.dll into the bin/ directory of the installation. This will cause obvious ... 7 Jan 2010 07:57

global\pg_auth
On Tuesday 05 January 2010 09:37:57 black light wrote: Hi, Why PG uses a flat file (global\pg_auth) for md5 authentication!? Is it forced to do it instead of accessing relevant table is system catalog? It does not anymore: http://git.postgresql.org/gitweb?p=postgresql.git;a=commit;h=7b0a92a0b6f5ef41f1547381c... 6 Jan 2010 09:09

[HACKERS] execute sql commands in core
Hi, I want to add some hard-wired extra authentication codes in my PG. The only problem is how to access tables to get/change information from core (auth.c)? I have changed the SPI functions to use them but it was not effective (lots of different errors!) In fact, i want to add a table to system catalog and SELEC... 6 Jan 2010 09:09

ECPG DESCRIBE [OUTPUT] support
On Mon, Jan 4, 2010 at 1:51 PM, Boszormenyi Zoltan <zb(a)cybertec.at> wrote: new patch is attached. Modified according to the new DB2 / Sybase compatible SQLDA structure. ECPGdescribe() has an "int compat" parameter, because: - the (struct prepared_statement *)->stmt ->compat is not set, and - it's more se... 15 Jan 2010 09:21

What's the current theory about derived files inVPATH builds?
On mån, 2010-01-04 at 18:49 -0500, Tom Lane wrote: It seems like VPATH building is broken at the moment, at least if you are working from a maintainer-clean source tree. make -C bootstrap all make[3]: Entering directory `/home/postgres/build/src/backend/bootstrap' /usr/local/bin/bison -o bootparse.c... 6 Jan 2010 09:09

[HACKERS] What's the current theory about derived files in VPATH builds?
It seems like VPATH building is broken at the moment, at least if you are working from a maintainer-clean source tree. make -C bootstrap all make[3]: Entering directory `/home/postgres/build/src/backend/bootstrap' /usr/local/bin/bison -o bootparse.c /home/postgres/pgsql/src/backend/bootstrap/bootparse.y /usr/lo... 6 Jan 2010 09:09

Setting oom_adj on linux?
Magnus Hagander wrote: I realize this is a very platform-specific thing, but should we consider setting the value of /proc/<pid>/oom_adj when running on linux? See: http://archives.postgresql.org/message-id/20080201223336.GC24780%40alvh.no-ip.org -- Alvaro Herrera http://... 11 Jan 2010 14:15

[HACKERS] Setting oom_adj on linux?
I realize this is a very platform-specific thing, but should we consider setting the value of /proc/<pid>/oom_adj when running on linux? See: http://git.kernel.org/?p=linux/kernel/git/torvalds/linux-2.6.git;a=blob;f=Documentation/filesystems/proc.txt;h=220cc6376ef80e0c9bcfec162d45552e729cdf5a;hb=45d28b097280a78893... 6 Jan 2010 09:08

pg_migrator issues
Bruce Momjian wrote: pg_migrator has become more popular recently, so it seems time to look at some enhancements that would improve pg_migrator. None of these are required, but rather changes that would be nice to have: 1) Right now pg_migrator preserves relfilenodes for TOAST files because this is... 12 Jan 2010 08:08

ERROR: record type has not been registered
Peter Eisentraut <peter_e(a)gmx.net> writes: This was a random attempt to figure something out about min/max on row types: => select min(a) from (values (row(1,2,3)), (row(3,4,5))) as x(a); ERROR: 42809: record type has not been registered LOCATION: lookup_rowtype_tupdesc_internal, typcache.c:341 ... 3 Jan 2010 17:10