From: | "Mark Dexter" <MDEXTER(at)dexterchaney(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Creating Functions in a Separate Schema |
Date: | 2004-08-24 17:46:58 |
Message-ID: | 5E8F9F5B63726C48836757FE673B584EF747B4@dcimail.dexterchaney.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Our application currently runs in SQL Server and we are porting it over
to Postgres. When we write enbedded SQL queries for SQL Server, we need
to reference user-defined functions with the prefix "dbo." (e.g.,
"dbo.Function_Name()"). In experimenting with Postgres, it appears that
we can create a schema called "dbo" and then reference functions with
the same syntax (e.g., "dbo.Function_Name()").
We're trying to understand whether there will be any disadvantages to
doing this. One issue we have discovered is that any public table or
view references in these functions need to explicitly use the "public."
prefix for the tables or views. Are there any other issues or problems
with this approach? Any help will be greatly appreciated. Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Kurzawa | 2004-08-24 17:47:54 | Trying to find a renegade lock |
Previous Message | Steve Crawford | 2004-08-24 17:31:41 | Re: MySQL vs PostgreSQL |