On þri, 2007-08-07 at 15:23 +0200, Filip Rembiałkowski wrote:
> filip(at)filip=# create view v as select 1::int;
> CREATE VIEW
> filip(at)filip=# select * from v;
> int4
> ------
> 1
> (1 row)
> filip(at)filip=# create table t ( like v);
> ERROR: inherited relation "v" is not a table
>
>
>
> Why? Is there any logical reason for this? View is just a table with
> some rule ON SELECT...
i do not know about the reason this is not allowed, but you can:
create table t as select * from v limit 0;
gnari