Received: from mailserv.hub.org (mailserv.hub.org [216.126.84.253]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA2DGvq08855 for ; Fri, 2 Nov 2001 08:16:57 -0500 (EST) (envelope-from d.richter@dkfz-heidelberg.de) Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by mailserv.hub.org (8.11.4/8.11.4) with ESMTP id fA28jhf75288 for ; Fri, 2 Nov 2001 03:45:44 -0500 (EST) (envelope-from d.richter@dkfz-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id JAA02221; Fri, 2 Nov 2001 09:45:35 +0100 (MET) Received: from dkfz.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id JAA06322; Fri, 2 Nov 2001 09:45:35 +0100 (MET) Message-ID: <3BE25D2F.9BF837EB@dkfz.de> Date: Fri, 02 Nov 2001 09:45:35 +0100 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: Stephan Szabo , Tom Lane , pgsql-sql@postgresql.org Subject: Re: View consistency References: <20011101081416.X22509-100000@megazone23.bigpanda.com> Content-Type: multipart/mixed; boundary="------------262B9DF0B2DEED3DC187964E" X-Archive-Number: 200111/44 X-Sequence-Number: 5428 This is a multi-part message in MIME format. --------------262B9DF0B2DEED3DC187964E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, So every time when I 'll use the view, the constraint over the basic table will be revalidated. Select name from patient_view; is in reality: Select name from (select ...,...,... from basic where xxx=yyy); Is that right? DAvid --------------262B9DF0B2DEED3DC187964E 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 --------------262B9DF0B2DEED3DC187964E--