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

    Join Date
    Jan 2008
    Posts
    209
    Rep Power
    9

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

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