PgSql

leaky views, yet again
(2010/07/08 22:08), Robert Haas wrote: I think we pretty much have conceptual agreement on the shape of the solution to this problem: when a view is created with CREATE SECURITY VIEW, restrict functions and operators that might disclose tuple data from being pushed down into view (unless, perhaps, the user ... 21 Jul 2010 08:03

inner join removal
Robert Haas <robertmhaas(a)gmail.com> writes: Consider: SELECT * FROM foo LEFT JOIN (bar JOIN baz ON bar.y = baz.y) ON foo.x = bar.x; If foo is itty bitty and bar and baz are enormous, it would be nice to start by joining foo to bar and then joining the result to baz, but that's not legal. However, if... 8 Jul 2010 18:06

[HACKERS] inner join removal
So I sat down to work on some code to do inner join removal, and quickly got stuck. As a first step, I wanted to write some code that would identify inner joins that could be treated as LEFT JOINs if we so chose. Consider: SELECT 1 FROM foo, bar WHERE foo.x = bar.x; If it so happens that there is a left join... 8 Jul 2010 14:44

Out of date comment in xlogutils.c
Joshua Tolley <eggyknap(a)gmail.com> writes: I noticed the following out-of-date bits in a comment in xlogutils.c: Removing the comment altogether doesn't seem appropriate. I changed it to * (Getting the buffer lock is not really necessary during single-process * crash recovery, but some subroutines such as... 8 Jul 2010 12:30

[HACKERS] leaky views, yet again
I think we pretty much have conceptual agreement on the shape of the solution to this problem: when a view is created with CREATE SECURITY VIEW, restrict functions and operators that might disclose tuple data from being pushed down into view (unless, perhaps, the user invoking the view has sufficient privileges to ... 8 Jul 2010 09:09

patch (for 9.1) string functions
Pavel Stehule <pavel.stehule(a)gmail.com> wrote: updated version, concat function doesn't use separator BTW, didn't you forget stringfunc.sql.in for contrib/stringfunc ? So, I have not check stringfunc module yet. I reviewed your patch, and format() in the core is almost ok. It's very cool! On the other ha... 24 Jul 2010 12:19

ALTER TABLE SET STATISTICS requiresAccessExclusiveLock
On Wed, 2010-07-07 at 22:26 -0400, Robert Haas wrote: Rereading the thread, I'm a bit confused by why we're proposing to use a SHARE lock; it seems to me that a self-conflicting lock type would simplify things. There's a bunch of discussion on the thread about how to handle pg_class updates atomically, b... 28 Jul 2010 11:52

patch: preload dictionary new version
Pavel Stehule <pavel.stehule(a)gmail.com> wrote: this version has enhanced AllocSet allocator - it can use a mmap API. I review your patch and will report some comments. However, I don't have test cases for the patch because there is no large dictionaries in the default postgres installation. I'd like to ask... 20 Jul 2010 08:04

ALTER TABLE SET STATISTICS requires AccessExclusiveLock
2010/3/3 Bruce Momjian <bruce(a)momjian.us>: Peter Eisentraut wrote: On m?n, 2010-02-22 at 10:32 -0500, Bruce Momjian wrote: Simon Riggs wrote: On Mon, 2009-10-19 at 12:56 -0300, Alvaro Herrera wrote: Simon Riggs wrote: On Fri, 2009-08-07 at 15:58 -0400, Alvaro Herre... 19 Jul 2010 13:34

pg_dump and join aliases (was Re: [BUGS] ERROR: cannot handle unplanned sub-select)
On Wed, Jul 7, 2010 at 6:55 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: After some investigation I was able to simplify it to the following example using the regression database: select �(select sq1) as qq1 from �(select exists(select 1 from int4_tbl where f1 = q2) as sq1, 42 as dummy � from int8_tb... 7 Jul 2010 23:23