Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

pgadmin option enhancement request



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group