Adding new syntax in postgre sql

Started by ankit bhardwajover 12 years ago2 messages
#1ankit bhardwaj
ankitbhrdwj27@gmail.com

I am new to postgre sql .And i want to add some new feature to postgresql
As a startup i have taken the project to add syntax for table partitioning

CREATE TABLE is modified to accept a PARTITION BY clause. This clause
contains one or more partition declarations. The syntax is as follows:

PARTITION BY {partition_type} (column_name[, column_name...])
[PARTITIONS number]
(
partition_declaration[, partition_declaration...]

)

The partition type can be one of HASH, RANGE or LIST.

so can anyone tell me from where to start .
I have read all the basics
but i dont know the control flow for adding new syntax.

so please tell me how to add new syntax
from parser to executor..

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Andreas Karlsson
andreas.karlsson@percona.com
In reply to: ankit bhardwaj (#1)
Re: Adding new syntax in postgre sql

On 10/16/2013 01:17 PM, ankit bhardwaj wrote:

I am new to postgre sql .And i want to add some new feature to postgresql
As a startup i have taken the project to add syntax for table partitioning

Welcome to the list!

There has been some previous work done on adding this syntax, but I have
not followed it so I do not know the details or if anyone is currently
working on it (have not seen any activity about it recently on the list
though).

There is a patch linked from the wiki page about adding a partitioning
syntax which is probably worth looking at.

https://wiki.postgresql.org/wiki/Table_partitioning#Active_Work_In_Progress

--
Andreas Karlsson

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers