PgSql

[HACKERS] mapping object names to role IDs
Suppose you have an object name as a CString and you want to convert it to an OID. The method of doing this varies widely depending on the object type: oid = get_database_oid(name); oid = get_tablespace_oid(name); oid = GetForeignDataWrapperOidByName(name, true); oid = GetForeignServerOidByName(name, true); o... 23 May 2010 01:45

"unexpected" query behaviour after i change parser code
On Sat, May 22, 2010 at 9:21 AM, Mohammad Heykal Abdillah <heykal.abdillah(a)gmail.com> wrote: All, Lately i have play with "parser"-part. I was try to make valid query command without using "FROM clause", so far it's work. I know this modification will make all query that using "FROM clause" failed... 22 May 2010 23:37

[HACKERS] "unexpected" query behaviour after i change parser code
All, Lately i have play with "parser"-part. I was try to make valid query command without using "FROM clause", so far it's work. I know this modification will make all query that using "FROM clause" failed, for example "/df" command. But normal or simple "select statement" so far is work. Now before my ques... 22 May 2010 09:25

[HACKERS] beta testing - pg_upgrade bug fix - double free
Hello it fixes bug pg_upgrade(13359) malloc: *** error for object 0x801600: non-page-aligned, non-allocated pointer being freed *** set a breakpoint in malloc_error_break to debug arget 03:31 /usr/local/src/postgresql/contrib/pg_upgrade git diff . diff --git a/contrib/pg_upgrade/check.c b/contrib/pg_upgra... 21 May 2010 22:43

Idea for getting rid of VACUUM FREEZE on cold pages
On May 21, 2010, at 23:57 , Josh Berkus wrote: From a discussion at dinner at pgcon, I wanted to send this to the list for people to poke holes in it: Problem: currently, if your database has a large amount of "cold" data, such as 350GB of 3-year-old sales transactions, in 8.4 vacuum no longer needs to touch ... 12 Jun 2010 13:45

[HACKERS] beta testing - planner bug - ERROR: XX000: failed to build any 2-way joins
Hello there are maybe planner bug. test case: CREATE TABLE person ( id SERIAL PRIMARY KEY, name VARCHAR(64) ) WITHOUT OIDS; CREATE TABLE person_data ( id SERIAL PRIMARY KEY ) WITHOUT OIDS; ------------------------------------ SELECT name FROM person WHERE name IN ( ... 21 May 2010 21:38

[HACKERS] Idea for getting rid of VACUUM FREEZE on cold pages
From a discussion at dinner at pgcon, I wanted to send this to the list for people to poke holes in it: Problem: currently, if your database has a large amount of "cold" data, such as 350GB of 3-year-old sales transactions, in 8.4 vacuum no longer needs to touch it thanks to the visibility map. However, ever... 21 May 2010 18:22

[HACKERS] (9.1) btree_gist support for searching on "not equals"
This patch adds support to btree_gist for searching on <> ("not equals"). This allows an interesting use of exclusion constraints: Say you have a table: create table zoo ( cage int, animal text, exclude using gist (cage with =, animal with <>) ); That will permit you to add as many... 21 May 2010 18:22

small exclusion constraints patch
Jeff Davis <pgsql(a)j-davis.com> writes: Currently, the check for exclusion constraints performs a sanity check that's slightly too strict -- it assumes that a tuple will conflict with itself. That is not always the case: the operator might be "<>", in which case it's perfectly valid for the search for confli... 30 May 2010 14:21

unnailing shared relations (was Re: global temporary tables)
2010/5/21 Robert Haas <robertmhaas(a)gmail.com>: On Sat, Apr 24, 2010 at 6:53 PM, Robert Haas <robertmhaas(a)gmail.com> wrote (in reply to Tom Lane):  If we create, e.g. pg_shared_class and pg_shared_attribute, then we can un-nail the catalogs you just nailed to make the authentication process able to wor... 25 May 2010 00:31