PgSql

[HACKERS] Visual Studio 2005, C-language function - avoiding hacks?
I have PostgreSQL 8.4 installed on Windows XP, and am using Visual Studio 2005 to write a C-Language function. I have the most basic hello-world type example (just the 'add_one' function from http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html) in a DLL, set to compile to C code rather than C++, and I can d... 4 Mar 2010 20:17

Explicit psqlrc
On Mar 4, 2010, at 4:00 PM, Magnus Hagander wrote: I've now for the second time found myself wanting to specify an explicit psqlrc file instead of just parsing ~/.psqlrc, so attached is a patch that accepts the PSQLRC environment variable to control which psqlrc file is used. Any objections to thi... 8 Mar 2010 16:25

[HACKERS] Explicit psqlrc
I've now for the second time found myself wanting to specify an explicit psqlrc file instead of just parsing ~/.psqlrc, so attached is a patch that accepts the PSQLRC environment variable to control which psqlrc file is used. Any objections to this (obviously including documentation - this is just the trivial co... 4 Mar 2010 18:04

machine-readable pg_controldata?
2010/3/4 Josh Berkus <josh(a)agliodbs.com>: All, Currently, the only way for admin scripts to get individual data items out of pg_controldata (such as the next XID or the catalog version) is via grep and regex. Given that people are going to be relying on some of this data for replication admin in the f... 9 Mar 2010 11:11

one-off error in to_char formatting
"Erik Rijkers" <er(a)xs4all.nl> writes: There seems to be an erroneously prefixed space: No, that's where the sign goes. You can suppress it with FM, if you don't want fixed-width output. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your su... 4 Mar 2010 11:12

Repetition of warning message while REVOKE
Piyush Newe <piyush.newe(a)enterprisedb.com> writes: create table tbl(col int); create user usr; grant select on tbl to usr; \c postgres usr; REVOKE SELECT on tbl from usr; WARNING: no privileges could be revoked for "tbl" WARNING: no privileges could be revoked for "tbl" WARNING: no privileges... 6 Mar 2010 18:29

problem about inet
fanng yuan wrote: I just do some research on ip address storage and comparing. I found pgsql already fixed that issue. I want to get some point from your guys about how this work. I'm not sure what you're looking for, exactly. Does this page help?: http://www.postgresql.org/docs/8.4/interactive/da... 4 Mar 2010 07:50

Incrementally Updated Backups and restartpoints
Hi, I thought of this issue again since the related question arrived. http://archives.postgresql.org/pgsql-admin/2010-03/msg00036.php On Thu, Jan 14, 2010 at 7:13 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Wed, Jan 13, 2010 at 9:34 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: ... 4 Mar 2010 07:50

[HACKERS] Streaming replication and privilege
Hi, Currently superuser privilege is required when the standby connects to the primary. But there is the complaint that we should add new privilege for replication and use it instead of superuser because current approach is not good for security (*1). This has been listed as one of TODO items of SR. This TODO... 4 Mar 2010 06:42

[HACKERS] problem about inet
Hi Guys: I just do some research on ip address storage and comparing. I found pgsql already fixed that issue. I want to get some point from your guys about how this work. Could you give me some data about that . Also I'm interesting in pgsql . Could you give me some suggestion about how to hack pgsql. Thank. ... 4 Mar 2010 05:36