Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f23FYAx18021 for ; Sat, 3 Mar 2001 10:34:10 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id PAA07754; Sat, 3 Mar 2001 15:35:16 GMT Received: from archonet.com (ibook.archonet.com [192.168.1.32]) by mainbox.archonet.com (Postfix) with ESMTP id BFA922A474; Sat, 3 Mar 2001 15:13:33 +0000 (GMT) Message-ID: <3AA10A15.2AEA6C6B@archonet.com> Date: Sat, 03 Mar 2001 15:13:25 +0000 From: Richard Huxton X-Mailer: Mozilla 4.7C-CCK-MCD {C-UDP; EBM-APPLE} (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: Jacek Zagorski Cc: pgsql-sql@postgresql.org Subject: Re: Insert into VIEW ??? References: <3A9D89D1.B25DC67A@shastanetworks.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/36 X-Sequence-Number: 1681 Jacek Zagorski wrote: > > Is it possible to INSERT into xyz > where xyz is a view ? > What is the proper syntax ? > > Thanks Much > Jacek Zagorski You'll need to set up the rules for updating - PG can't figure out what you want automatically. There's a page on this in the programmer's guide. - Richard Huxton