| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Jeanna Geier <jgeier(at)apt-cafm(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Deleting From View? |
| Date: | 2007-01-05 16:15:44 |
| Message-ID: | 20070105161544.GC27598@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 05, 2007 at 09:59:34AM -0600, Jeanna Geier wrote:
> Thanks for the quick reply; that's one of the many reasons why this list is
> so awesome...
>
> I'm taking this project over from somebody else and am new to the DB side of
> things, so I'm still learning - you're responses and thoughts are greatly
> appreciated!
You didn't post the INSERT rule.
However, what's truly interesting is that you do have a delete rule,
yet you're getting an exception. Which indicates the exception is being
generated from within java, and not by postgresql at all. Obviously,
whatever trick that was applied to convince java to insert into a view
needs to be used to make the delete work.
Wouldn't fixing the insert rule be better?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeanna Geier | 2007-01-05 16:22:38 | Re: Deleting From View? |
| Previous Message | Jeanna Geier | 2007-01-05 15:59:34 | Re: Deleting From View? |