26.01.2014 00:56, Helen Borrie wrote:
>> However current situation should be reflected in Release Notes.
>
> From a design perspective, my simple-minded view is that homonymity of the
> kind that leads to conflicts within the scope of the current_schema should be
> avoided. You seem to be sayi
At 08:24 a.m. 26/01/2014, Simonov Denis wrote:
> However there will be a problem of homonymy of schemas and packets.
What is meant by "packets"? Same as packages? Something else?
>However current situation should be reflected in Release Notes.
From a design perspective, my simple-minded v
After having worked with a variety of databases (db2/oracle/mssql)
A user/connection/transaction has a default name space/schema.
If an absolute path ie schema.sqlobject is not specified, the current
default schema is used.
You can use synonyms to point to a sql object in a different schema as a
Adriano dos Santos Fernandes писал(а) в своём письме
Sat, 25 Jan 2014 18:41:40 +0400:
>
> I don't know. To answer this, I would need detailed spec of how schemas
> will work in Firebird.
>
> Will it be user-based or not, how multiple schemas will interact, how
> current no-schema objects will b
On 25-01-2014 12:30, Dmitry Yemanov wrote:
> 25.01.2014 18:22, Adriano dos Santos Fernandes wrote:
>>
>> Adding some keyword for now may cause future problems when schemas exist.
>
> What's the problem of treating ::PROC1 (syntax just for example) as a
> global procedure PROC1 in the current sche
25.01.2014 18:22, Adriano dos Santos Fernandes wrote:
>
> Adding some keyword for now may cause future problems when schemas exist.
What's the problem of treating ::PROC1 (syntax just for example) as a
global procedure PROC1 in the current schema? Or do you mean the
situation when multiple schem
On 25-01-2014 11:08, Simonov Denis wrote:
> How to make a call of the same name of the stored procedure within a
> package from the global namespace?
>
There is no way, currently.
I think when schemas exist, you will be able to use SCHEMA_NAME.PROC1.
Adding some keyword for now may cause futu
How to make a call of the same name of the stored procedure within a
package from the global namespace?
Example:
===
SET TERM ^;
CREATE OR ALTER PROCEDURE PROC1
returns (i int)
AS
begin
i = 5;
suspend;
end^
CREATE OR ALTER PACKAGE PKG2
AS
begin
