"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes: > Hi Manuel, > >> each time the user sends a request I do more or less the following: > > Could a trigger be used to implement this ? Or are you doing this from the > application layer?
I'm doing it form the application layer and I don't think it can be done in the database layer, how the trigger will figure out which user is doing the query?, It's the same problem you are trying to solve! > My problem is that, like Til, I don't have full control over my > request cycle as I'm over a very high-level framework (Actually it > is an data-oriented application generator, called GeneXus). Maybe you can use Til approach with temporal tables. Regards, Manuel. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq