Hello all, I know I may be asking too much, but I have a very limited C/C++ (as well as PostgreSQL internal architecture) knowledge. I've tried compiling the C source code Manuel sent as a PostgreSQL loadable module on Visual Studio .NET 2003 (C++) without success (lots of missing identifiers, "int Datum" redefinition and other things I didn't really understood). The comments in the Postgres 8.0 manual didn't help much.
If anyone could put me on the right direction on how to write/build C/C++ PostgreSQL on the Windows platform (specifically Windows XP) I would be grateful as I really need this thing working as soon as possible. Thanks, Marcelo. On 4/25/07, Marcelo de Moraes Serpa <[EMAIL PROTECTED]> wrote:
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! > Duh! That is what happens when you start having high levels of caffeinne in your blood and haven't had a good night sleep... thanks for putting me on the track again. I will study Tim's approach more. This thing got more complicated than I thought it would be. At least I'm learning more about PostgreSQL internal architecture. Thank you for your help. Marcelo. On 4/25/07, Manuel Sugawara <[EMAIL PROTECTED]> wrote: > > "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. >
