Re: [HACKERS] INSERT INTO view means what exactly? - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] INSERT INTO view means what exactly?
Date
Msg-id m10mMmp-000EBPC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [HACKERS] INSERT INTO view means what exactly?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>
> jwieck@debis.com (Jan Wieck) writes:
> > Tom Lane wrote:
> >> regression=> INSERT INTO z VALUES ('bar');
> >> INSERT 411636 1
> >>
> >> OK, where'd tuple 411636 go?
>
> >     Tuple 411636 went into data/base/regression/x :-)
>
> .../z, you meant --- yup, I see you are right.  Weird.  I didn't
> realize that views had an underlying table.

    They  ARE  a  table  - only that a rule ON SELECT hides their
    (normal) emptyness :-)


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] strange behavior of UPDATE
Next
From: Ari Halberstadt
Date:
Subject: Re: AW: [HACKERS] pg_dump core dump, upgrading from 6.5b1 to 5/24 sna pshot