| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Adrian Klaver <aklaver(at)attbi(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: View and primary key |
| Date: | 2002-11-22 15:39:11 |
| Message-ID: | 20021122073731.W11910-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Lamb | 2002-11-22 15:39:16 | Re: View and primary key |
| Previous Message | Stephan Szabo | 2002-11-22 15:35:47 | Re: Question about DEADLOCK |