Re: inherited table and rules

On Tue, 22 Mar 2005, Scott Frankel wrote:

> Syntax troubles.
>
> What is the proper syntax for using FROM ONLY table_name in an UPDATE
> statement? According to the docs, In a FROM clause, I should be able to
> use the ONLY keyword preceding the table name.  This throws an error:
>
>     UPDATE FROM ONLY people SET color = 'cyan' WHERE usr_pkey = 1;

It's actually UPDATE ONLY people (I was using the select version in my
message as a shorthand, sorry).

> What is the proper syntax for specifying FROM ONLY in the inheritance
> statement?

You don't need to do it in the inheritance clause, and I'm not sure what
it would do if it were allowed.

> This also throws an error:
>
>     CREATE TABLE people_history (
>     hist_pkey    SERIAL    NOT NULL PRIMARY KEY,
>     hist_tstamp  timestamp DEFAULT CURRENT_TIMESTAMP
>     ) INHERITS ONLY (people);
>
> What does GUC stand for? ;)

I think it's like grand unified configuration.  It's the configuration
variables in the conf file and SETs and so on.