Re: [HACKERS] mapping object names to role IDs

2010-05-22 Thread Robert Haas
And of course I meant for the subject line to be "mapping object names to OIDs", not "role IDs". Sigh. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] mapping object names to role IDs

2010-05-22 Thread Robert Haas
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(n

[HACKERS] [PATCH] Move 'long long' check to c.h

2010-05-22 Thread Stephen Frost
Greetings, While reviewing bfba40e2c7b3909d3de13bd1b83b7e85fa8dfec2 (mmm, we like git diff -p), I noted that c.h is already included by both extern.h and ecpg.header through postgres_fe.h. Given this and that we're already doing alot of similar #define's there (unlike in those other fil

Re: [HACKERS] Specification for Trusted PLs?

2010-05-22 Thread Robert Haas
On Sat, May 22, 2010 at 4:53 PM, Cédric Villemain wrote: > 2010/5/21 Jan Wieck : >> The original idea was that a trusted language does not allow an unprivileged >> user to gain access to any object or data, he does not have access to >> without that language. >> >> This does not include data trans

Re: [HACKERS] "unexpected" query behaviour after i change parser code

2010-05-22 Thread Robert Haas
On Sat, May 22, 2010 at 9:33 PM, Mohammad Heykal Abdillah wrote: >> > My question : >> > 1) Can someone explain why my last test it's work? >> >> In standard PostgreSQL, "select item from item" is valid SQL.  It >> returns a single column whose value is a record containing all the >> columns from

Re: [HACKERS] beta testing - pg_upgrade bug fix - double free

2010-05-22 Thread Robert Haas
On Fri, May 21, 2010 at 10:11 PM, Pavel Stehule wrote: > 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_upgr

Re: [HACKERS] "unexpected" query behaviour after i change parser code

2010-05-22 Thread Mohammad Heykal Abdillah
On Sab, 2010-05-22 at 14:42 -0400, Robert Haas wrote: > > Ok this my test result to "customer" and "item" table : > > - select id_item,name from item; > > --> failed, because there is "from clause" (failed like i expected) > > > > - select item.id_item, item.name; > > --> work, like i expected > >

Re: [HACKERS] Idea for getting rid of VACUUM FREEZE on cold pages

2010-05-22 Thread Jan Wieck
On 5/22/2010 9:16 PM, Tom Lane wrote: Josh Berkus writes: Somebody (I think Joe or Heikki) poked a big hole in this last night at the Royal Oak. Although the scheme would get rid of the need to replace old XIDs with FrozenXid, it does not get rid of the need to set hint bits before you can tru

Re: [HACKERS] Idea for getting rid of VACUUM FREEZE on cold pages

2010-05-22 Thread Tom Lane
Josh Berkus writes: >> Somebody (I think Joe or Heikki) poked a big hole in this last night at >> the Royal Oak. Although the scheme would get rid of the need to replace >> old XIDs with FrozenXid, it does not get rid of the need to set hint >> bits before you can truncate CLOG. So in your examp

Re: [HACKERS] Specification for Trusted PLs?

2010-05-22 Thread Cédric Villemain
2010/5/21 Jan Wieck : > The original idea was that a trusted language does not allow an unprivileged > user to gain access to any object or data, he does not have access to > without that language. > > This does not include data transformation functionality, like string > processing or the like. As

Re: [HACKERS] "unexpected" query behaviour after i change parser code

2010-05-22 Thread Robert Haas
On Sat, May 22, 2010 at 9:21 AM, Mohammad Heykal Abdillah 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, for example

Re: [HACKERS] release notes

2010-05-22 Thread Tim Bunce
On Mon, May 17, 2010 at 11:34:37AM -0400, Tom Lane wrote: > Andrew Dunstan writes: > > Why do the release notes say this, under plperl: > > * PL/Perl subroutines are now given names (Tim Bunce) > > This is for the use of profiling and code coverage tools. DIDN'T > > THEY HAVE NAMES

Re: [HACKERS] Idea for getting rid of VACUUM FREEZE on cold pages

2010-05-22 Thread Josh Berkus
Somebody (I think Joe or Heikki) poked a big hole in this last night at the Royal Oak. Although the scheme would get rid of the need to replace old XIDs with FrozenXid, it does not get rid of the need to set hint bits before you can truncate CLOG. So in your example of an insert-only table tha

Re: [HACKERS] Idea for getting rid of VACUUM FREEZE on cold pages

2010-05-22 Thread Tom Lane
Josh Berkus writes: > From a discussion at dinner at pgcon, I wanted to send this to the list > for people to poke holes in it: Somebody (I think Joe or Heikki) poked a big hole in this last night at the Royal Oak. Although the scheme would get rid of the need to replace old XIDs with FrozenXi

[HACKERS] "unexpected" query behaviour after i change parser code

2010-05-22 Thread Mohammad Heykal Abdillah
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 be

Re: [HACKERS] Specification for Trusted PLs?

2010-05-22 Thread Alexey Klyukin
On Fri, May 21, 2010 at 7:25 PM, Magnus Hagander wrote: > On Fri, May 21, 2010 at 12:22 PM, David Fetter wrote: >> On Fri, May 21, 2010 at 11:57:33AM -0400, Magnus Hagander wrote: >>> On Fri, May 21, 2010 at 11:55 AM, Josh Berkus wrote: >>> > So, here's a working definition: >>> > >>> > 1) canno