Re: [HACKERS] Specification for Trusted PLs?

2010-05-22 Thread Alexey Klyukin
On Fri, May 21, 2010 at 7:25 PM, Magnus Hagander mag...@hagander.net wrote: On Fri, May 21, 2010 at 12:22 PM, David Fetter da...@fetter.org 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 j...@agliodbs.com wrote: So, here's

[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 before my

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

2010-05-22 Thread Tom Lane
Josh Berkus j...@agliodbs.com 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

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

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 and...@dunslane.net 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

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 heykal.abdil...@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,

Re: [HACKERS] Specification for Trusted PLs?

2010-05-22 Thread Cédric Villemain
2010/5/21 Jan Wieck janwi...@yahoo.com: 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

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

2010-05-22 Thread Tom Lane
Josh Berkus j...@agliodbs.com 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

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 j...@agliodbs.com 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

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 - select

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 pavel.steh...@gmail.com 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

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 heykal.abdil...@gmail.com 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

Re: [HACKERS] Specification for Trusted PLs?

2010-05-22 Thread Robert Haas
On Sat, May 22, 2010 at 4:53 PM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: 2010/5/21 Jan Wieck janwi...@yahoo.com: 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

[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

[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 =

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