From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | reloptions with a "namespace" |
Date: | 2009-01-13 23:26:42 |
Message-ID: | 20090113232642.GK4005@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Attached is a patch that adds a namespace capability to reloptions. It
works this way:
alter table foo set (namespace.option = value)
Currently the only namespace that does anything is "toast". What it
does is store the option in the toast table pg_class.reloptions.
It works fine, i.e. I can set a toast table fillfactor with a command
that references the main table. I am also able to do this:
CREATE TABLE foo (a int, b text) WITH (fillfactor = 80, toast.fillfactor = 75);
and it correctly sets the fillfactor for both tables.
This uses a new parse node. One possible disadvantage is that a command
like this works, but does nothing:
alvherre=# alter table foo set (test.foo = 1);
ALTER TABLE
This now needs pg_dump support to be complete.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Attachment | Content-Type | Size |
---|---|---|
reloptions-namespace.patch | text/x-diff | 38.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas 'ads' Scherbaum | 2009-01-13 23:28:21 | Re: Patch for str_numth() in PG 7.4 |
Previous Message | Andrew Dunstan | 2009-01-13 22:36:08 | Re: A single escape required for log_filename |