Re: [GENERAL] pgsql constraints and temporal tables

2007-12-14 Thread Enrico Sirola
Hi Tom! Tom Lane ha scritto: > Enrico Sirola <[EMAIL PROTECTED]> writes: >> However, I'm facing a problem I'm not able to solve with postgresql: >> usually updating or deleting time-varying data means to temporary >> violate a constraint in a transaction but ensuring that at the end of >> the tran

Re: [GENERAL] pgsql constraints and temporal tables

2007-12-14 Thread Tom Lane
Enrico Sirola <[EMAIL PROTECTED]> writes: > However, I'm facing a problem I'm not able to solve with postgresql: > usually updating or deleting time-varying data means to temporary > violate a constraint in a transaction but ensuring that at the end of > the transaction the table(s) is(are) in a co

[GENERAL] pgsql constraints and temporal tables

2007-12-14 Thread Enrico Sirola
Hello, I'm reading "Developing Time-Oriented Database Applications in SQL" by Richard Snodgrass, and trying to reimplement some of the examples using postgresql. The book is about temporal tables and applications involving time-varying data; the one of the main difficulties with such problems is th