PgSql

[HACKERS] cross column correlation revisted
hello everybody, we are currently facing some serious issues with cross correlation issue. consider: 10% of all people have breast cancer. we have 2 genders (50:50). if i select all the men with breast cancer, i will get basically nobody - the planner will overestimate the output. this is the commonly known probl... 14 Jul 2010 06:36

Simple hack to get $500 to your home.
Simple hack to get $500 to your home at http://easywaytolife.tk Due to high security risks,i have hidden the cheque link in an image. in that website on top side above search box, click on image and enter your name and address where you want to receive your cheque.please don,t tell to anyone. ... 14 Jul 2010 04:26

[HACKERS] Fwd: sql/med review - problems with patching
Hello please, can you refresh patch, please? [pavel(a)nemesis pgsql]$ patch -p1 < backend.patch patching file src/backend/access/common/reloptions.c patching file src/backend/catalog/Makefile patching file src/backend/catalog/aclchk.c patching file src/backend/catalog/dependency.c patching file src/backend/cat... 14 Jul 2010 02:17

[HACKERS] security label support, part.2
The attached patch is a part of efforts to support security label on database objects. It adds statement support to manage security label of relations. Right now, object labeling except for relations/columns are not supported, because the DML permission hook is the only chance to apply access control decision of... 14 Jul 2010 02:17

[HACKERS] security label support, part.1
The attached patch is a part of efforts to support security label on database objects. It adds a new system catalog named pg_seclabel, that has similar structure with pg_description. #define SecLabelRelationId 3037 CATALOG(pg_seclabel,3037) BKI_WITHOUT_OIDS { Oid reloid; /* O... 14 Jul 2010 02:17

testing plpython3u on 9.0beta3
On tis, 2010-07-13 at 15:38 -0500, Chris wrote: I'm testing beta 3 and ran across a PL/Python3u bug again. This time it won't let me install it at all. Kubuntu 10.04 ./configure --with-pgport=5433 --with-python --with-ossp-uuid --with-libxml --with-libxslt --with-perl --prefix=/usr/local/pgsqlb3 ... 16 Jul 2010 07:43

[HACKERS] testing plpython3u on 9.0beta3
I'm testing beta 3 and ran across a PL/Python3u bug again. This time it won't let me install it at all. Kubuntu 10.04 ../configure --with-pgport=5433 --with-python --with-ossp-uuid --with-libxml --with-libxslt --with-perl --prefix=/usr/local/pgsqlb3 make make check sudo make install All work fine. However.... 13 Jul 2010 17:32

bg worker: overview
Markus Wanner <markus(a)bluegap.ch> wrote: (I don't dare to add these patches to the commit fest, as this refactoring doesn't have any immediate benefit for Postgres itself, at the moment.) You could submit them as Work In Progress patches.... -Kevin -- Sent via pgsql-hackers mailing list (pgsql... 26 Jul 2010 08:21

ERROR: argument to pg_get_expr() must come from system catalogs
On 13 July 2010 16:31, Dave Page <dpage(a)pgadmin.org> wrote: We had a report of the above error from a pgAdmin user testing 1.12.0b3 with PG 9.0b3. The (highly simplified) query below works fine as a superuser: SELECT pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) �FROM pg_proc pr �LEF... 30 Jul 2010 22:56

[HACKERS] ERROR: argument to pg_get_expr() must come from system catalogs
We had a report of the above error from a pgAdmin user testing 1.12.0b3 with PG 9.0b3. The (highly simplified) query below works fine as a superuser: SELECT pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) FROM pg_proc pr LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid Run as a regular... 13 Jul 2010 12:00