Re: [PATCHES] Disable WAL backup pages when fsync is off

2005-07-02 Thread Tom Lane
Bruce Momjian writes: > The following patch disables WAL backup pages when fsync is off. This is a good idea why? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister comma

[PATCHES] Roles - SET ROLE Updated

2005-07-02 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > Tom, if you're watching, are you working on this? I can probably spend > > some time today on it, if that'd be helpful. > > I am not; I was hoping you'd deal with SET ROLE. Is it really much > different from SE

Re: [PATCHES] enable/disable trigger (Re: Fwd: [HACKERS] Open items)

2005-07-02 Thread Bruce Momjian
Gavin Sherry wrote: > On Fri, 1 Jul 2005, Satoshi Nagayasu wrote: > > > Hi all, > > > > Here is a first patch to allow these commands. > > > > > ALTER TABLE ENABLE TRIGGER > > > ALTER TABLE DISABLE TRIGGER > > > > Hmmm.. just thinking about it for a second. I wonder if we should also > suppor

[PATCHES] Disable WAL backup pages when fsync is off

2005-07-02 Thread Bruce Momjian
The following patch disables WAL backup pages when fsync is off. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtow

Re: [PATCHES] Implementing SELECT FOR UPDATE [NOWAIT]

2005-07-02 Thread Bruce Momjian
Karel Zak wrote: > > This is new version of SELECT FOR UPDATE NOWAIT patch. > > Karel > > > > On Sat, 2005-06-25 at 08:40 +0200, Hans-Juergen Schoenig wrote: > > yes, i think we can do it in time. > > > > regards, > > > >hans > > > > > > > > Bruce Momjian wrote: > > >

Re: [HACKERS] [PATCHES] Dbsize backend integration

2005-07-02 Thread Michael Glaesemann
On Jul 3, 2005, at 8:35 AM, Bruce Momjian wrote: Andreas Pflug wrote: Dave Page wrote: Yup, attached. Per our earlier conversation, pg_dbfile_size() now returns the size of a table or index, and pg_relation_size() returns the total size of a relation and all associated indexes and toast

Re: [PATCHES] contrib/pgcrypto patch for OpenSSL 0.9.8

2005-07-02 Thread Bruce Momjian
Patch applied. Thanks. --- Michael Fuhr wrote: > This patch allows contrib/pgcrypto to build with OpenSSL 0.9.8 > (currently in beta) when cryptolib = openssl. According to the > following checkin message from several yea

[PATCHES] contrib/pgcrypto patch for OpenSSL 0.9.8

2005-07-02 Thread Michael Fuhr
This patch allows contrib/pgcrypto to build with OpenSSL 0.9.8 (currently in beta) when cryptolib = openssl. According to the following checkin message from several years ago, OpenSSL application developers should no longer rely on to include everything they need: http://cvs.openssl.org/chngview

Re: [PATCHES] per user/database connections limit again

2005-07-02 Thread Stephen Frost
* Petr Jelinek ([EMAIL PROTECTED]) wrote: > + if (!(superuser() > + || ((Form_pg_database) GETSTRUCT(tuple))->datdba == > GetUserId())) > + aclcheck_error(ACLCHECK_NOT_OWNER, ACL_KIND_DATABASE, > +stmt->dbname); This should almos

Re: [HACKERS] [PATCHES] Dbsize backend integration

2005-07-02 Thread Bruce Momjian
Andreas Pflug wrote: > Dave Page wrote: > > > > > > > >>-Original Message- > >>From: Bruce Momjian [mailto:[EMAIL PROTECTED] > >>Sent: 02 July 2005 21:30 > >>To: Bruce Momjian > >>Cc: Dave Page; PostgreSQL-patches; PostgreSQL-development > >>Subject: Re: [PATCHES] Dbsize backend integr

Re: [PATCHES] [HACKERS] Problem with dblink regression test - FIXED

2005-07-02 Thread Bruce Momjian
Patch applied. Thanks. --- Jim C. Nasby wrote: > On Tue, Jun 28, 2005 at 02:28:11PM -0400, Andrew Dunstan wrote: > > > > > > Jim C. Nasby wrote: > > > > >All the logs for the most recent run against HEAD are now at > >

Re: [PATCHES] Dbsize backend integration

2005-07-02 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 02 July 2005 21:30 To: Bruce Momjian Cc: Dave Page; PostgreSQL-patches; PostgreSQL-development Subject: Re: [PATCHES] Dbsize backend integration Is a new version of this patch coming? Yup,

Re: [PATCHES] BUG #1467: fe_connect doesn't handle EINTR right

2005-07-02 Thread Bruce Momjian
Tom Lane wrote: > AgentM <[EMAIL PROTECTED]> writes: > > Attached is a patch which corrects the behavior. I verified that the > > patch does not interfere with normal operation (using psql) but > > unfortunately the code path is virtually impossible to test without a > > really slow connectio

Re: [PATCHES] per user/database connections limit again

2005-07-02 Thread Bruce Momjian
Alvaro Herrera wrote: > On Sat, Jul 02, 2005 at 04:28:48PM -0400, Bruce Momjian wrote: > > > We will need these: > > > > > Patch includes only changes to backend, I will make pg_dump, ecpg and > > > documentation patches once this is completed and accepted by team. > > > > Your patch has been ad

Re: [PATCHES] Constraint Exclusion (Partitioning) - Initial Review requested

2005-07-02 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Sat, Jul 02, 2005 at 03:56:48PM -0400, Bruce Momjian wrote: >> I am surprised no one else has commented on it, which I think means your >> code is ready for the queue. Do you want to adjust it based on this >> feedback or should I apply and you can a

Re: [PATCHES] Constraint Exclusion (Partitioning) - Initial Review requested

2005-07-02 Thread Alvaro Herrera
On Sat, Jul 02, 2005 at 03:56:48PM -0400, Bruce Momjian wrote: > Simon Riggs wrote: > > > > I enclose a fully working implementation of Constraint Exclusion, a very > > basic form of Partitioning. Initial review is requested, to allow us all > > to assess what further work is required on this pri

Re: [PATCHES] per user/database connections limit again

2005-07-02 Thread Alvaro Herrera
On Sat, Jul 02, 2005 at 04:28:48PM -0400, Bruce Momjian wrote: > We will need these: > > > Patch includes only changes to backend, I will make pg_dump, ecpg and > > documentation patches once this is completed and accepted by team. > > Your patch has been added to the PostgreSQL unapplied patche

Re: [PATCHES] Dbsize backend integration

2005-07-02 Thread Dave Page
> -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: 02 July 2005 21:30 > To: Bruce Momjian > Cc: Dave Page; PostgreSQL-patches; PostgreSQL-development > Subject: Re: [PATCHES] Dbsize backend integration > > > Is a new version of this patch coming? Yup, attach

Re: [PATCHES] per user/database connections limit again

2005-07-02 Thread Bruce Momjian
We will need these: > Patch includes only changes to backend, I will make pg_dump, ecpg and > documentation patches once this is completed and accepted by team. Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It wil

Re: [PATCHES] Dbsize backend integration

2005-07-02 Thread Bruce Momjian
Is a new version of this patch coming? --- Bruce Momjian wrote: > Dave Page wrote: > > > > > > > > -Original Message- From: Bruce Momjian > > [mailto:[EMAIL PROTECTED] Sent: Wed 6/29/2005 2:16 AM To: Dave > > Page

Re: [PATCHES] Constraint Exclusion (Partitioning) - Initial Review requested

2005-07-02 Thread Bruce Momjian
Seems you have managed to combine inheritance, check constraints, and partial index into table paritioning. It is nice it requires no new syntax. Here is an example from your tests: DROP TABLE pm cascade; CREATE TABLE pm ( dkey INT NOT NULL );

[PATCHES] More E'' changes

2005-07-02 Thread Bruce Momjian
The following attached, applied patch adds E'' to internally created SQL strings that contain backslashes. I also added two macros to improve code clarity. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your l

[PATCHES] Bitmap index AM

2005-07-02 Thread Victor Yegorov
separate email; - nothing done around cost estimation. Waiting for feedback, thanks. -- Victor Y. Yegorov diff-20050702.gz Description: Binary data ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [PATCHES] pl/pgsql: END verbosity [patch]

2005-07-02 Thread Neil Conway
Pavel Stehule wrote: this patch allows optional using label with END and END LOOP. Ending label has only informational value, but can enhance readability large block and enhance likeness with Oracle. Reviewed and applied -- thanks for the patch. -Neil ---(end of broad