Hello,

I find myself needing the ability to edit a record from within an environment where a particular schema is at the head of " defined searchpath" ( e.g., set searchpath=xxx01 in psql, etc.) . The reason is that I have a trigger on the table in question that assumes a particular search path rather than specifying an explicit schema qualification in front of the table name. Without that search path, the ensuing SQL throws an error because the engine can't find the table in the default search path that is used by pgadmin.

Please consider the ability to define a search path for the pgadmin session as an additional option in your file:options:general section.

Thanks,
Dick Wieland

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to