Horton

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

Jan Wieck <jwieck@debis.com>

View thread
From: jwieck@debis.com (Jan Wieck)
To: tgl@sss.pgh.pa.us (Tom Lane)
Cc: jwieck@debis.com, pgsql-hackers@postgreSQL.org
Date: 1999-05-25T19:22:51Z
Lists: 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) #