[GENERAL] fast shutdown

2009-06-24 Thread Mary Sipple
When a fast shutdown is done (pg_ctl stop -s -D$PGDATA -mf) active transactions are aborted. Are these transactions logged somewhere & re-run when postmaster comes back up? Thanks, Mary

Re: [GENERAL] Set search_path for session

2009-04-20 Thread Mary Sipple
Thanks everyone! A follow up question: Is there any way to set the search_path to all existing schemas? I'm looking for some kind of wild card method that will automatically pick up every schema. Thanks, Mary -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Set search_path for session

2009-04-17 Thread Mary Sipple
ic (1 row) Can anyone tell me how I can make this happen short of changing the search_path setting in postgresql.conf & restarting postgres? Thanks, Mary Sipple