July 19th, 2012, 05:02 PM
Set schema for duration of connection
I am using haxe nPostgres which uses the c drivers to execute queries. Executing:
set search_path to mysearchpath
at the beginning of the connection does not appear to set the search path for all queries after it. Is there a way to do this? What is the scope of setting the search_path just the next query?
Last edited by imagenesis; July 19th, 2012 at 05:04 PM.
July 19th, 2012, 05:51 PM
It appears that the issue was that the first create query failed because the table already existed and subsequent queries failed because the search_path was reset after that failure. Please confirm that this is the behavior, that the search path is reset after a failed (create?) query