[PATCHES] Bitmap index AM

2005-07-02 Thread Victor Yegorov
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 (send unregister YourEmailAddressHere

[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

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 );

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 Cc:

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 will

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, attached. Per

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 patches list

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 prior to

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 adjust it

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 added to the

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 connection to a

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] [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] 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 almost

[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 openssl/evp.h to include everything they need:

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] 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: Are you working on a

[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.|

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

2005-07-02 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us 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