Re: [HACKERS] Patch for automating partitions in PostgreSQL 8.4 Beta 2

2009-07-07 Thread Kedar Potdar
Yes. I am working to integrate some of the comments received for the patch. I would be able to post latest patch in the next week. Regards, -- Kedar. On Tue, Jul 7, 2009 at 10:18 AM, Jaime Casanova jcasa...@systemguards.com.ec wrote: On Mon, Jun 8, 2009 at 9:02 AM, Kedar

Re: [HACKERS] Patch for automating partitions in PostgreSQL 8.4 Beta 2

2009-06-15 Thread Kedar Potdar
Hi Nikhil, I am sorry for the late reply. :( Please find inline my comments. On Tue, Jun 9, 2009 at 2:54 PM, Nikhil Sontakke nikhil.sonta...@enterprisedb.com wrote: Hi, The patch automates table partitioning to support Range and Hash partitions. Please refer to attached readme file for

Re: [HACKERS] Patch for automating partitions in PostgreSQL 8.4 Beta 2

2009-06-09 Thread Kedar Potdar
PFA. This file is to be kept in 'pgsql_init' base directory. On Tue, Jun 9, 2009 at 12:54 PM, Grzegorz Jaskiewicz g...@pointblue.com.plwrote: gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -bundle

Re: [HACKERS] Patch for automating partitions in PostgreSQL 8.4 Beta 2

2009-06-09 Thread Kedar Potdar
I did a fresh checkout and applied patch and added files and it works at my end. Is there any problem with formatting of the file? May be some characters('\') missing in conversion? On Tue, Jun 9, 2009 at 4:14 PM, gj g...@pointblue.com.pl wrote: still doesn't work: make[1]: Leaving directory

Re: [HACKERS] Patch for automating partitions in PostgreSQL 8.4 Beta 2

2009-06-08 Thread Kedar Potdar
PFA the required header file. Regards, -- Kedar. On Tue, Jun 9, 2009 at 12:26 AM, Jaime Casanova jcasa...@systemguards.com.ec wrote: On Mon, Jun 8, 2009 at 1:38 PM, Grzegorz Jaskiewicz g...@pointblue.com.pl wrote: make[3]: *** No rule to make target

[HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread Kedar Potdar
Hi , We are working on a patchhttp://archives.postgresql.org/pgsql-hackers/2009-03/msg00897.phpto automate partitioning in PostgreSQL. For Range partitions, we have proposed the syntax which is as follows – *CREATE TABLE emp (* *emp_id int not null primary key,* *

Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread Kedar Potdar
...@enterprisedb.com wrote: On Tue, Apr 21, 2009 at 12:50 PM, Kedar Potdar kedar.pot...@gmail.com wrote: I want to seek general opinion from the community on preferences between user-friendly ‘Oracle’ syntax, and a more generic syntax that allows ‘gaps’ in partition ranges? What happens

Re: [HACKERS] Automating Partitions in PostgreSQL - Query on syntax

2009-04-21 Thread Kedar Potdar
2009/4/21 Dickson S. Guedes lis...@guedesoft.net Em Ter, 2009-04-21 às 17:20 +0530, Kedar Potdar escreveu: Hi , We are working on a patch to automate partitioning in PostgreSQL. Nice. :) For Range partitions, we have proposed the syntax which is as follows (...) PARTITION

Re: [HACKERS] Partitioning feature ...

2009-03-30 Thread Kedar Potdar
Hi Emmanuel, Thanks for your time. This is a WIP patch and we will integrate your suggestions/comments as appropriate. Regards, -- Kedar. On Fri, Mar 27, 2009 at 3:38 AM, Emmanuel Cecchet m...@asterdata.comwrote: Hi Kedar, First of all, congratulations for the excellent work. I have some

Re: [HACKERS] Partitioning feature ...

2009-03-24 Thread Kedar Potdar
Hi Nikhil, Update operation is performed as a combination of 'delete' and 'insert'. In Update trigger, the row is deleted from relation according to it's 'ctid'. A look-up on system catalog for partitions is performed to identify the target table by evaluating values of partition-key attributes,

[HACKERS] Writing values to relation using bytearray ...

2009-03-06 Thread Kedar Potdar
Hi, I am trying to write values of different types to relation using following code. if(typbyval) { min_ba = (bytea *) palloc(len+1+VARHDRSZ); memcpy(VARDATA(min_ba), min_datum, len); SET_VARSIZE(min_ba, len+VARHDRSZ);

Re: [HACKERS] Writing values to relation using bytearray ...

2009-03-06 Thread Kedar Potdar
Thanks Greg, for showing interest. The problem here is I need to store values of different types into bytearray column of relation. On Fri, Mar 6, 2009 at 4:33 PM, Greg Stark st...@enterprisedb.com wrote: On Fri, Mar 6, 2009 at 10:03 AM, Kedar Potdar kedar.pot...@gmail.com wrote

Re: [HACKERS] Writing values to relation using bytearray ...

2009-03-06 Thread Kedar Potdar
() to its native type datum represation as required. This is a bit of overhead and I'd like to find more efficient solution and will look pg_statistics data store. Regards, - Kedar - sent from a mobile device. On 3/6/09, Tom Lane t...@sss.pgh.pa.us wrote: Kedar Potdar kedar.pot...@gmail.com writes