On Wednesday 27 August 2008 04:24, Teemu Juntunen wrote: > Hi, > > I think this has been asked before, but I can't find the answer from arcive > nor google. How to disable/enable all the riggers in a database? I have > problem with disabled triggers after database restore. If there is no > simple way, could this be made in a function where you find the table names > and construct the needed commands in strings. If so, how to get all the > tablenames from database? > > Best regards and thanks! > Teemu Juntunen You can accomplish this by manipulating the run time parameter, session_replication_role. For example, from within your psql session: SET SESSION session_replication_role = replica; This will prevent all triggers from firing for the entire session except those defined as "replica". We use this all the time. HTH... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 terry@xxxxxxxxxxxxx www.turbocorp.com
