initskript after db start; locks on transactions
Hi!
I have have two questions:
1.
What is the best approach to trigger a service script wich will clean
up something in the db after every db (re-)start? Has PG its own
mechanism for such things or have i to use my /etc/init.d/postgresql
script?
2.
Sometime i read something about locks on transactions. Is this only an
internal thing or can i set them by my own and if yes, for what? With
the LOCK command i can only lock tables, or?
Thanks for any help,
Thomas!
On Aug 3, 2005, at 4:33 PM, Thomas Chille wrote:
Hi!
I have have two questions:
1.
What is the best approach to trigger a service script wich will clean
up something in the db after every db (re-)start? Has PG its own
mechanism for such things or have i to use my /etc/init.d/postgresql
script?
I don't think there's anything built in that will trigger a "service
script". I'm pretty sure you'll want to add to or supplement the
existing init script.
2.
Sometime i read something about locks on transactions. Is this only an
internal thing or can i set them by my own and if yes, for what? With
the LOCK command i can only lock tables, or?
You can use any lock mode specified:
http://www.postgresql.org/docs/8.0/static/sql-lock.html
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)