Search Postgresql Archives

Re: inheritance. more.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Apr 28, 2008, at 8:01 PM, Gurjeet Singh wrote:

On Mon, Apr 28, 2008 at 8:01 PM, Erik Jones <erik@xxxxxxxxxx> wrote:

Postgres doesn't yet handle inheritance of constraints from parent to child tables via inheritance.

Was it done by design or was it a limitation we couldn't get over?
My understanding of the lack of a full featured partitioning solution  
(based on previous conversations with Tom Lane, Gregory Stark, and the  
like) is that the current implementation was pieced together from  
other portions of the system -- i.e. the moving parts on the backend  
weren't built from the ground up with partitioning in mind.  I'm  
currently working on a command line tool that will take a table name  
along with a date/timestamp or integer based column on that table and  
some optional parameters and write out range based partitions for that  
table.  If you'd like I'll save this email and once I've got it stable  
and well tested I'll put it up in a public repo somewhere.
Erik Jones

DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux