Search Postgresql Archives

Re: Only first statement of two in update-rule is executing?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 29 Jan 2008, David Owen wrote:

On Tue, 29 Jan 2008, David Owen wrote:

I discovered that if I change the rule to only do the insert, I still have troubles. The first update to simple2 will insert an row, but a second update will give a duplicate primary key error.

Sorry, that's a bad path (it's late). After the first update, there are now two rows in simple1. The second update applys to both, so attempts to create two new rows having the same timestamp. Ah well.

-David

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux