Re: Intentionally splitting data in a table across files. - Mailing list pgsql-admin

From Brian Baquiran
Subject Re: Intentionally splitting data in a table across files.
Date
Msg-id 9fmufh$djv$1@news.tht.net
Whole thread Raw
In response to Re: Intentionally splitting data in a table across files.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Intentionally splitting data in a table across files.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:27503.991845186@sss.pgh.pa.us...
> "Nick Fankhauser" <nickf@ontko.com> writes:
> > Does PostgreSQL support (or some day will support) "partitioned tables"?
>
> It's not on anyone's radar screen AFAIK.
>
> > Alternately, does anyone have an idea about how to address this need in
a
> > different way using existing tools?
>
> Make a view that's a UNION of the component tables, plus rules that
> cause inserts to go into the appropriate components.

Tried this in 7.1.2, but it returns ERROR:  "Views on unions not
implemented."

> regards, tom lane


pgsql-admin by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: changes sequences to unique
Next
From: 高豪良\(Danny\)
Date:
Subject: Rserv install problem