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
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" ? |