reloptions with a "namespace"

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

Responses

Browse pgsql-hackers by date

  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