Re: Deleting From View?

Interestingly enough... he doesn't have an INSERT rule...

The INSERTs all appear to be done using the JDBC and prepared statements in
the code.

-----Original Message-----
From: Martijn van Oosterhout [mailto:kleptog(at)svana(dot)org]
Sent: Friday, January 05, 2007 10:16 AM
To: Jeanna Geier
Cc: pgsql-general
Subject: Re: [GENERAL] Deleting From View?

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.