Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA1Eb1P21018; Thu, 1 Nov 2001 09:37:01 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fA1EKhO05102; Thu, 1 Nov 2001 09:20:43 -0500 (EST) (envelope-from news) From: "David M. Richter" X-Newsgroups: comp.databases.postgresql.sql,comp.databases.postgresql.admin Subject: View consistency Date: Thu, 01 Nov 2001 15:20:31 +0100 Organization: German Cancer Research Center Lines: 49 Message-ID: <3BE15A2F.B0CDF610@dkfz.de> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="------------E1BC38E454D798686EC8678F" X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en To: pgsql-admin@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200111/5 X-Sequence-Number: 2530 This is a multi-part message in MIME format. --------------E1BC38E454D798686EC8678F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! Im using several views for the Usermanagment of a database. My question is: How does postgres keep the views consistent to the according tables( if the original table has been changed)? Is there a Rule? and how is the Rule invoked. With ON DELETE UPDATE INSERT of the original table? I didnt found any Rule in pg_rules. There should be a rule, because I cannot imagine another way wich tells the view that the table has been changed. The problem is: If updating the view takes too much time after every little manipulation, I couldnt use views for usermanagement because of performance problems. Any hints and facts? Thanks in advance David --------------E1BC38E454D798686EC8678F Content-Type: text/x-vcard; charset=us-ascii; name="d.richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="d.richter.vcf" begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum/German Cancer Research Center;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-17024 fn:David M. Richter end:vcard --------------E1BC38E454D798686EC8678F--