Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Re: Cleaning Up Apache::Session data

by hardburn (Abbot)
on Mar 31, 2003 at 15:19 UTC ( [id://246947]=note: print w/replies, xml ) Need Help??


in reply to Re: Cleaning Up Apache::Session data
in thread Cleaning Up Apache::Session data

The orginal poster is using PostgreSQL. I don't use PostgreSQL much, but I did a quick scan over thier docs. PostgreSQL doesn't appear to have the same autmatic TIMESTAMP updates that MySQL has. Someone more familer with PostgreSQL will have to verify this for me, though.

----
I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
-- Schemer

Note: All code is untested, unless otherwise stated

  • Comment on Re: Re: Cleaning Up Apache::Session data

Replies are listed 'Best First'.
Re: Re: Re: Cleaning Up Apache::Session data
by pfaut (Priest) on Mar 31, 2003 at 16:11 UTC

    PostgreSQL has triggers. You can implement the same functionality with a simple BEFORE UPDATE/INSERT trigger.

    90% of every Perl application is already written.
    dragonchild
Re: Re: Re: Cleaning Up Apache::Session data
by dga (Hermit) on Mar 31, 2003 at 17:06 UTC

    PostgreSQL allows setting of a default value for a column, triggers are not needed for this task. See my reply to another node in this thread at Re: Re: Cleaning Up Apache::Session data.

    Update: Triggers are what's desired here since he wants to update the rows ald set the time also.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://246947]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2024-04-25 15:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found