View and primary key

From: Adrian Klaver <aklaver(at)attbi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: View and primary key
Date: 2002-11-22 13:51:16
Message-ID: 200211220551.16547.aklaver@attbi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have set up a view with rules for insert,update and delete. I would like to
be able to use this view from OpenOffice, however it will not allow editing
of a table without a primary key. I cannot create a primary key because
Postgresql says the column does not have a NOT NULL constraint. This column
in the underlying table is NOT NULL. Is there a way to create a primary key
on a view?

Thank you
Adrian Klaver

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felipe Schnack 2002-11-22 14:25:46 EXECUTE problems
Previous Message Hunter 2002-11-22 13:00:31 escape single quote in INSERT command