Thread

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

   Tom Lane <tgl@sss.pgh.pa.us> — 1999-05-25T18:53:28Z

   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.
   
   >     It  might be a good idea to abort if there's a SELECT rule on
   >     the result relation but not  one  for  the  actual  operation
   >     performed.  I'll  put  that  onto  my personal TODO for after
   >     v6.5.
   
   I agree, that would be a good safety feature.
   
   			regards, tom lane
   
   

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

   Jan Wieck <jwieck@debis.com> — 1999-05-25T19:22:51Z

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