On Fri, Jan 05, 2007 at 10:22:38AM -0600, Jeanna Geier wrote: > 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. Well, I think that's going to make your job difficult then. Obviously whatever is happening, the insert code is doing more than expected. Remember, a view is the result of a query, it's not hard to create views where you can't do meaningful DELETE rules. In your example you're joining many tables. If any of those tables have a duplicate value, that would duplicate records in the result. You can't delete any particular duplicate because it is the result, not the cause. Hope this helps, > -----Original Message----- > From: Martijn van Oosterhout [mailto:kleptog@xxxxxxxxx] > 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@xxxxxxxxx> http://svana.org/kleptog/ > > From each according to his ability. To each according to his ability to > litigate. > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
