PgSql

Snapshot Materialized Views - GSoC
2010/5/20 Pavel <baros.p(a)seznam.cz>: d) what to do when someone use INSERT, UPDATE or DELETE against MV?   1 - raise error? - I prefer this option +1, FWIW   2 - let commands change MV? (no chance to let changes propagate to source tables, not for this summer :)   if pg lets user to DML agains... 26 May 2010 06:58

ExecutorCheckPerms() hook
Robert Haas <robertmhaas(a)gmail.com> writes: In yesterday's development meeting, we talked about the possibility of a basic SE-PostgreSQL implementation that checks permissions only for DML. Greg Smith offered the opinion that this could provide much of the benefit of SE-PostgreSQL for many users, while bei... 21 Jul 2010 22:24

[HACKERS] ExecutorCheckPerms() hook
In yesterday's development meeting, we talked about the possibility of a basic SE-PostgreSQL implementation that checks permissions only for DML. Greg Smith offered the opinion that this could provide much of the benefit of SE-PostgreSQL for many users, while being much simpler. In fact, SE-PostgreSQL would need ... 20 May 2010 12:47

Renaming '2010-Next' to '2010-6' in the commitfestapp
On 05/20/2010 07:21 AM, Robert Haas wrote: On Thu, May 20, 2010 at 12:51 AM, Selena Deckelmann <selenamarie(a)gmail.com> wrote: Can we get that commitfest renamed? And if I should know how to do that, can you inform me how? I thought we agreed on 2009-07? Anyhow, you just hit "Edit CommitFest". ... 20 May 2010 09:27

Renaming '2010-Next' to '2010-6' in the commitfest app
On Thu, May 20, 2010 at 12:51 AM, Selena Deckelmann <selenamarie(a)gmail.com> wrote: Can we get that commitfest renamed? And if I should know how to do that, can you inform me how? I thought we agreed on 2009-07? Anyhow, you just hit "Edit CommitFest". It requires admin privileges, which I have now given yo... 20 May 2010 12:47

pg_upgrade docs
Excerpts from Stefan Kaltenbrunner's message of mié may 19 15:53:18 -0400 2010: While looking at the docs for pg_upgrade I noticed some stuff that the following patch attempts to at least partly address. Surely this para can be removed? <para> If you are using tablespaces and migrating to 8.4 or... 25 May 2010 11:19

[HACKERS] tsvector pg_stats seems quite a bit off.
Hi. I am working on getting full-text-search to work and have come across something I think look a bit strange. The document base is arount 350.000 documents and I have set the statistics target on the tsvector column to 1000 since the 100 seems way of. # ANALYZE verbose reference (document_tsvector); INFO... 19 May 2010 17:09

C function argument types
Bogdan Vlad <bogdancvlad(a)gmail.com> writes: How can I determine the pg_class oid of the argument type in a polymorphic C function when it's called with a table row? You're confusing pg_class oid with pg_type oid. The type oid of the function argument is necessarily going to be a *type* oid. You can look a... 19 May 2010 14:54

[HACKERS] Building the 64-bit Postgres
We adding support for Solaris x86 and this pushes us to upgrade the from the old-old version of Postgres we've been using for years. (The requirement is to have the 64-bit exec and libs) I looked at the release notes but could not figure out at which point Postgres gave the option of building the 64-bit binarie... 19 May 2010 14:54

[HACKERS] Adding XML Schema validation (XMLVALIDATE)
Hi, I'm going to start work on another XML todo item: "Add XML Schema validation and xmlvalidate function (SQL:2008)" The standard identifies XMLVALIDATE as: <XML validate> ::= XMLVALIDATE <left paren> <document or content or sequence> <XML value expression> [ <XML valid accordi... 19 May 2010 09:20