Hi NG,
working with postgres is very intresting...for a newby like me a big
big playground and so I found a nother toy which i like to handle :)
Rules or Triggers + Functions
In all of the maintable in my DB I have the following Fields:
created timestamptz
createdby vchar(15)
modified timestamptz
modifiedby vchar(15)
Now I like to setup a mechanismus which tke care of inserts and
updates. Everytime an insert is calld created shuld stamped whith the
current loggedin user and createdby whith Current_Timestamp....Same
for update whith modifed and modifedby.
I tried to set up a rule but it wont work because I find no way to
identify the newly inserted row :(
Thankyou for your support
Simon