PgSql
in [SQL]
|
[HACKERS] Reworks of DML permission checks The attached patch tries to rework DML permission checks. It was mainly checked at the ExecCheckRTEPerms(), but same logic was implemented in COPY TO/FROM statement and RI_Initial_Check(). This patch tries to consolidate these permission checks into a common function to make access control decision on DML permi... 14 Jun 2010 05:10
[HACKERS] [v9.1] add makeRangeTblEntry() into makefuncs.c The attached patch was a part of DML refactoring and security hook patches. It adds makeRangeTblEntry() into makefuncs.c to keep the code more clean. It shall be also used for the upcoming DML refactor patch. In this refactoring, a common DML permission checker function take a list of RangeTblEntry, so the caller... 14 Jun 2010 05:10
[HACKERS] Typo in plperl doc ? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hey, While translating the plperl page from the manual, I found the following sentence: The <varname>%_SHARED</varname> variable and other global state within the language is public data. Should it be : The <varname>%_SHARED</varname> variable and ot... 14 Jun 2010 04:05
GSoC - Materialized Views - is stale or fresh? On 12/06/10 17:18, Pavel Baros wrote: I am curious how could I solve the problem: During refreshing I would like to know, if MV is stale or fresh? And I had an idea: In fact, MV need to know if its last refresh (transaction id) is older than any INSERT, UPDATE, DELETE transaction launched against s... 14 Jun 2010 15:08
visibility map On 14/06/10 06:08, Robert Haas wrote: visibilitymap.c begins with a long and useful comment - but this part seems to have a bit of split personality disorder. * Currently, the visibility map is not 100% correct all the time. * During updates, the bit in the visibility map is cleared after releasing ... 14 Jun 2010 01:56
[HACKERS] visibility map visibilitymap.c begins with a long and useful comment - but this part seems to have a bit of split personality disorder. * Currently, the visibility map is not 100% correct all the time. * During updates, the bit in the visibility map is cleared after releasing * the lock on the heap page. During the window be... 13 Jun 2010 23:46
[HACKERS] pg_dump(all) --quote-all-identifiers In response to a complaint from Hartmut Goebel: http://archives.postgresql.org/pgsql-bugs/2010-06/msg00018.php And per a design proposed by Tom Lane: http://archives.postgresql.org/pgsql-bugs/2010-06/msg00211.php PFA a patch to implement $SUBJECT. One interesting aspect of this patch is that types like "i... 13 Jun 2010 21:35
Patch to show individual statement latencies in pgbenchoutput Florian Pflug wrote: To be able to asses the performance characteristics of the different wal-related options, I patched pgbench to show the average latency of each individual statement. The idea is to be able to compare the latency of the COMMIT with the ones of the other statements. That's an interesting ... 13 Jun 2010 20:30
9.0b1: "ERROR: btree index keys must be ordered by attribute" 2010/6/1 Bruce Momjian <bruce(a)momjian.us>: Tom Lane wrote: (...) The index-based-max code is throwing in the IS NOT NULL condition without thought for where it has to go in the index condition order. Will look into fixing this tomorrow. FYI, this no longer throws an error in current CVS so was fix... 13 Jun 2010 19:24
9.0beta2 - server crash when using HS + SR On Fri, Jun 11, 2010 at 9:29 PM, Rafael Martinez <r.m.guerrero(a)usit.uio.no> wrote: I am testing HS + SR in a system running 9.0beta2. What I am doing is just trying all kind of crazy combinations and see how the system handles them. Thanks! One of the test I knew was going to fail was to create a tabl... 1 Jul 2010 23:21 |