Re: Deleting From View? - Mailing list pgsql-general

Hello List!

I'm having an issue with my program; it's inserting into one record into a
view (named 'measurement') twice ,which it's not supposed to be - so, I'm
attempting to put a delete statement in the code to remove one of these
records, but am getting an error.  (Will track down the real insert issue
when I have more time, right now I just need to get this compiling....)

Code:

  if (tableName.equalsIgnoreCase("measurement")){
                deleteRow(1);
  }



And when I run my program I get an exception: cannot delete from a view.

Is there anyway I can do this in my code?


I'm running Postgres 8.0 & Java JDK1.5.

Thanks in advance for your time and help.
-Jeanna