Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id TAA00251 for ; Sat, 24 Jul 1999 19:38:34 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA11301; Sat, 24 Jul 1999 19:38:02 -0400 (EDT) To: "Zot O'Connor" cc: postgres sql Subject: Re: [SQL] Views Readonly Still? In-reply-to: Your message of Sat, 24 Jul 1999 11:53:19 -0700 <379A0B9F.17418ED7@ZotConsulting.com> Date: Sat, 24 Jul 1999 19:38:02 -0400 Message-ID: <11299.932859482@sss.pgh.pa.us> From: Tom Lane "Zot O'Connor" writes: > Are views readonly in 6.51 still? A view as such is just a SELECT rule; if you want to make it writable then you need to add some ON INSERT and ON UPDATE and ON DELETE rules to cause the right things to happen wherever the data is coming from. There's no way that the system can intuit what you might think is the correct behavior... regards, tom lane