#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Posts
    209
    Rep Power
    10

    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 06:04 PM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Posts
    209
    Rep Power
    10
    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

IMN logo majestic logo threadwatch logo seochat tools logo