On 9/14/07, Panagiotis Pediaditis <[EMAIL PROTECTED]> wrote: > Hello, > > Is there some way of locking all database tables in a transaction > without knowing their names > or even better just locking the entire database? I know this is bad > tactics but there is a specific > case where i need it. Can it be done? >
AFAIK Locking the entire database may not be an option in postgresql. However you can virtually restrict access to everyone to a particular database via pg_hba.conf. More details here http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html regards, -- Sibte Abbas ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
