Re: View and primary key - Mailing list pgsql-general

From Stephan Szabo
Subject Re: View and primary key
Date
Msg-id 20021122073731.W11910-100000@megazone23.bigpanda.com
Whole thread Raw
In response to View and primary key  (Adrian Klaver <aklaver@attbi.com>)
List pgsql-general
On Fri, 22 Nov 2002, Adrian Klaver wrote:

> 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?

I don't think so at this time.  Even if you got past that, I think the
index creation would fail saying that the view wasn't a table.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Question about DEADLOCK
Next
From: Doug McNaught
Date:
Subject: Re: Lack of use of indexes