Re: Deleting From View?

From: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deleting From View?
Date: 2007-01-05 15:42:09
Message-ID: FBEGJLLJBCOMCDBJHIMECEHBCCAA.jgeier@apt-cafm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-01-05 15:47:21 Re: Deleting From View?
Previous Message Scott Ribe 2007-01-05 15:31:28 Re: Any form of connection-level "session variable" ?