On 9/14/07, Panagiotis Pediaditis <pped@ics.forth.gr> 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