PgSql

Privileges
Simon Riggs <simon(a)2ndQuadrant.com> writes: There is a command to set privileges GRANT SELECT ON ALL TABLES IN SCHEMA foo TO PUBLIC; and a command to set default privileges ALTER DEFAULT PRIVILEGES IN SCHEMA foo GRANT SELECT ON TABLES TO PUBLIC; In the first command the ALL is required, ... 20 Apr 2010 18:31

[HACKERS] Privileges
There is a command to set privileges GRANT SELECT ON ALL TABLES IN SCHEMA foo TO PUBLIC; and a command to set default privileges ALTER DEFAULT PRIVILEGES IN SCHEMA foo GRANT SELECT ON TABLES TO PUBLIC; In the first command the ALL is required, whereas in the second command the ALL must be absent. ... 20 Apr 2010 18:31

idle in txn query cancellation
Hi Simon, On Sunday 14 March 2010 20:12:00 Simon Riggs wrote: On Sun, 2010-03-14 at 19:50 +0100, Andres Freund wrote: On Sunday 14 February 2010 06:29:45 Simon Riggs wrote: On Sat, 2010-02-13 at 22:37 +0100, Andres Freund wrote: I know it is late in the cycle No problem here. T... 20 Apr 2010 18:31

Standalone backends run StartupXLOG in an incorrectenvironment
On Mon, 2010-04-19 at 11:19 -0400, Tom Lane wrote: If you think we're at the point where this item is the main thing standing between us and beta, I'll go do something about it. I've been waiting for the HS code to settle before trying to design a solution... I'm not hugely interested in supporting HS... 20 Apr 2010 18:31

BUG #4887: inclusion operator (@>) on tsqeries behaves not conforming to documentation
On Wed, Feb 24, 2010 at 2:11 PM, Bruce Momjian <bruce(a)momjian.us> wrote: Oleg, Teodor, would you look at this?  I see the same behavior in 9.0. As there has been no movement on this I think we should punt this from: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items to http://wiki.postgresql.org/w... 20 Apr 2010 18:32

[HACKERS] perltidy
The MSVC scripts currently have a "perltidy coding style" so we run perltidy with a specific set of arguments to format the code. (This is in the README). Kind of like pgindent. Should we be doing this on all the perlscripts we use? And if we do, we should obviously use the same one everywhere - probably just ... 20 Apr 2010 18:31

Thread safety and libxml2
On Thu, Feb 18, 2010 at 8:41 PM, Bruce Momjian <bruce(a)momjian.us> wrote: Peter Eisentraut wrote: On ons, 2009-12-30 at 12:55 -0500, Greg Smith wrote: Basically, configure failed on their OpenBSD system because thread safety is on but the libxml2 wasn't compiled with threaded support: http://xml... 24 Apr 2010 00:26

pgsql: Tune GetSnapshotData() duringHot Standby by avoiding loop
Simon Riggs wrote: On Mon, 2010-04-19 at 10:24 -0400, Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: On Mon, Apr 19, 2010 at 5:05 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: It doesn't seem to be something we should place highly on the list of events we need protection from, does... 20 Apr 2010 18:31

pgsql: Tune GetSnapshotData() during Hot Standby by avoiding loop
On Mon, Apr 19, 2010 at 5:05 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: It doesn't seem to be something we should place highly on the list of events we need protection from, does it? Since when do we not protect against race-conditions just because they're low likelihood? ....Robert -- Sent via pg... 20 Apr 2010 18:31

[HACKERS] Move tablespace
I just noticed that ALTER TABLE foo SET TABLESPACE new_tablespace; doesn't optimise writing WAL, so when streaming enabled it will copy the whole table to WAL and across the wire. My understanding was that ALTER TABLE had been optimised, though not as much as could be in this case. Following patch writes a... 20 Apr 2010 16:15