Ray,
I don't think you can - here's what the docs[1] for INSERT say:
<quote from docs>
The target column names can be listed in any order. If no list of column
names is given at all, the default is all the columns of the table in
their declared order; or the first N column names, if there are only N
columns supplied by the VALUES clause or query. The values supplied by
the VALUES clause or query are associated with the explicit or implicit
column list left-to-right.
</quote from docs>
So it seems that the association between columns is based on order, not
on name.
Solution seems to force id column to be last column in table.
In this case drop column id drops last columns and insert should work.
Any idea how to force id to be last column in table ?
Is it possible to create updatable view where id is last column ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
