Re: [HACKERS] INSERT INTO view means what exactly?

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) #