Issue Details (XML | Word | Printable)

Key: CORE-738
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: carniz
Votes: 21
Watchers: 17
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Add support for SQL Schemas

Created: 19/Jul/04 12:00 AM   Updated: 25/Apr/14 05:32 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 

SF_ID: 993727


 Description  « Hide
SFID: 993727#
Submitted By: carniz

I'd like to see support for SQL Schemas (see http://sql-info.de/postgresql/schemas.html)

Oracle has it, PostgreSQL has it, Mimer has it, don't know about others.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Ivan added a comment - 22/Oct/09 02:46 PM
this must be priority.

why?

because if I must have for each year data in single database then my application is complicated and can't using the same time data for more more year.can but then must special database for all data.

with more scemas, for each year keep data in special scema and one for all.

all schema have the same structure.

then with application can be easy the use of data.

fabianobonin added a comment - 06/Dec/11 07:13 PM
I think schemas are a must-have for enterprise applications which deal with large number of tables.

You can use schemas to organize tables in groups, to improve security, to deal with different sets of data (years, for example) in different shemas and keep the same table names, to simplify objects naming, etc, etc, etc...

I really don´t understand why Firebird still don´t have it, as almost all serious competitors already have it, and specially with JDBC adding schemas to the standard specification (i presume schemas are also part of SQL standards), it makes Firebird less portable to replace other databases in applications developed from beginning to use schemas.

fabianobonin added a comment - 28/Jul/12 05:04 AM
No words about schemas/namespaces in Firebird 3.0?
I would like to see it at least as a reminder in 3.0 release notes.

Dmitry Yemanov added a comment - 28/Jul/12 05:25 AM
They are not planned for FB 3.0.