PgSql

Proposal: access control jails (and introduction asaspiring GSoC student)
Joseph Adams wrote: Hello, I'm Joey Adams, and I'm interested in applying for Google Summer of Code to work on PostgreSQL. I'm a former GSoC student (I worked on CCAN last year), and a strong C programmer, though I am still new to working with large, established communities. I apologize if this is the ... 22 Mar 2010 04:58

[HACKERS] how to link an external lib on Windows
Hi, I build PG on VS2005, which files should I change to use a external lib in my own contrib, for example, Berkeley DB 4.8.26? Until now, I have tried the following 2 ways, but both failed. 1. Add the target include and lib 1). src/tools/msvc/config.pl add... 22 Mar 2010 03:53

[HACKERS] Proposal: access control jails (and introduction as aspiring GSoC student)
Hello, I'm Joey Adams, and I'm interested in applying for Google Summer of Code to work on PostgreSQL. I'm a former GSoC student (I worked on CCAN last year), and a strong C programmer, though I am still new to working with large, established communities. I apologize if this is the wrong place to send GSoC studen... 22 Mar 2010 01:28

Proposal for Byte savings in VarBit structure
Gokulakannan Somasundaram <gokul007(a)gmail.com> writes: I was looking at the VarBit data structure and found out that instead of storing the number of bits in four bytes, we can save the number of bits that are valid in the last byte. Since we already store the number of bytes in Varlena Header, we can ca... 21 Mar 2010 17:21

[HACKERS] Proposal for Byte savings in VarBit structure
Hi, I was looking at the VarBit data structure and found out that instead of storing the number of bits in four bytes, we can save the number of bits that are valid in the last byte. Since we already store the number of bytes in Varlena Header, we can calculate the number of valid bits by doing the small math. ... 21 Mar 2010 16:13

xmlconcat (was [HACKERS] 9.0 release notes done)
Andrew Dunstan <andrew(a)dunslane.net> writes: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items I have just been looking at the xmlconcat bug on that list. I can't think of any better solution than parsing the resulting string to make sure it is well-formed before we return, That might be a r... 5 Apr 2010 00:45

[HACKERS] Windowing Qual Pushdown
In the function "subquery_is_pushdown_safe", there is an immediate "false" returned if the subquery has a windowing function. While that seems true in general, are there cases where we can push down a qual if it is on the partitioning key? Or do NULLs or some other detail get in the way? fdr -- Sent via p... 20 Mar 2010 13:12

[HACKERS] 9.0 release notes done
I have completed the 9.0 release notes: http://developer.postgresql.org/pgdocs/postgres/release-9-0.html I kept the 9.0-alpha release notes in the SGML because people might want to compare them with the release notes I did, and because the introductory text will be needed for the next alpha. Eventually we wil... 20 Mar 2010 00:34

[BUG] SECURITY DEFINER on call handler makes daemoncrash
On 3/19/10 5:18 AM, Tom Lane wrote: When we assign "SECURITY DEFINER" attribute on plpgsql_call_handler(), it makes server process crashed. So don't do that. Whatever possessed you to think that's a sensible idea anyway? PATIENT: Doctor, it hurts when I do this! DOCTOR: So stop doing that. ... 22 Mar 2010 21:49

[BUG] SECURITY DEFINER on call handler makes daemon crash
(2010/03/20 11:17), Robert Haas wrote: On Fri, Mar 19, 2010 at 8:11 PM, Tom Lane<tgl(a)sss.pgh.pa.us> wrote: Robert Haas<robertmhaas(a)gmail.com> writes: On Fri, Mar 19, 2010 at 8:18 AM, Tom Lane<tgl(a)sss.pgh.pa.us> wrote: KaiGai Kohei<kaigai(a)ak.jp.nec.com> writes: When we assign "SECURITY DEFIN... 19 Mar 2010 23:28