28.07.2014 22:48, Dalton Calford wrote: > > That is not exactly true. With Schema's, on DB2 and Oracle at least, > not sure about other platforms, you can specify a default schema, either > publicly or by user/connection.
Correct. Legacy apps will keep working as long as you don't reference non-default schemas explicitly. So per-schema apps are going to work, while cross-schema ones won't (without polluting everything with synonyms). > You also have a sql object called a synonym. And I have serious doubts we need them. PGSQL has schemas and doesn't have synonyms. I'd prefer us going the same route. > If a schema within a schema structure was used, you would make it easier > to migrate databases from other platforms onto firebird. Can you name some RDBMS that support nested schemas? I tend to say "over my dead body" to this. Dmitry ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
