Jim Nasby wrote: > Is there a safe way to deal with tables being passed into a function, > specifically in terms of what schema they're in? I can just blindly > accept a text string and hope that it's always evaluated in the > correct search_path context, but that doesn't seem so good. OTOH, if > I accept an OID, there's no great way to pass that to most of the > rest of the system... I can cast the OID to regclass, but that > doesn't get me a fully-qualified name.
Pass the optionally qualified name and cast it to regclass. It will work correctly when the name is not qualified, applying search_path, and it will also work when the name is qualified. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(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
