| From: | "Mark Dexter" <MDEXTER(at)dexterchaney(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Creating Functions in Separate Schema |
| Date: | 2004-08-26 21:42:14 |
| Message-ID: | 5E8F9F5B63726C48836757FE673B584EF74CB5@dcimail.dexterchaney.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Our application currently runs in Microsoft 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. Are there any possible issues or problems with this
approach? Any help will be greatly appreciated. Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Smith | 2004-08-26 22:04:29 | Re: Constraints to Guarantee unique across tables with foreign key? |
| Previous Message | Gaetano Mendola | 2004-08-26 21:33:46 | Re: Possible to insert quoted null value into integer field? |