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

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 Potda

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

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

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

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 wrote: > still doesn't work: > > make[1]: Leaving directory `/home/gjaskie/Pro

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

PFA. This file is to be kept in 'pgsql_init' base directory. On Tue, Jun 9, 2009 at 12:54 PM, Grzegorz Jaskiewicz wrote: > gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv > -bundle -multiply_defined s

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

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 > wrote: > > > > make[3]: *** No rule to make target > `../../../src/include/catalog/pg_partition.h', nee

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

2009/4/21 Dickson S. Guedes > 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 &

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

: > On Tue, Apr 21, 2009 at 12:50 PM, Kedar Potdar > 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 t

[HACKERS] Automating Partitions in PostgreSQL - Query on syntax

Hi , We are working on a patchto 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,* *desig

Re: [HACKERS] Partitioning feature ...

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 wrote: > Hi Kedar, > > First of all, congratulations for the excellent work. > I have some comments and que

Re: [HACKERS] Partitioning feature ...

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,

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

o_specific_type()" 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 wrote: > Kedar Potdar writes: >

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

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 wrote: > On Fri, Mar 6, 2009 at 10:03 AM, Kedar Potdar > wrote: > > > > The aforementioned code wo

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

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