Claudio Valderrama C. <cva...@usa.net> писал(а) в своём письме Wed, 07 May  
2014 13:00:43 +0400:

>> -----Original Message-----
>> From: Philippe Makowski [mailto:pmakow...@ibphoenix.fr]
>> Sent: Miércoles, 07 de Mayo de 2014 3:05
>>
>> Hi,
>>
>> just for information, seems that some last commit broke
>> something in gbak :
>>
>> sudo /opt/firebird/bin/gbak -c /home/vagrant/fbtest.fbk
>> localhost:/home/vagrant/fdb/test/fbtest30.fdb -user SYSDBA -password
>> masterkey
>> gbak: ERROR:DELETE operation is not allowed for system table
>> RDB$DEPENDENCIES
>> gbak:Exiting before completion due to errors
>
> Ok, I think I fixed it and committed. DFW caught me.
>
> C.
>


Unfortunately the problem with the system tables still have


Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:test' user 'sysdba' password 'masterkey';
Database:  'localhost:test', User: sysdba
SQL> show version;
ISQL Version: WI-T3.0.0.31126 Firebird 3.0 Alpha 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31126  
Firebird 3.0 Alpha 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31126  
Firebird 3.0 Alpha 2/tcp (Den-PC)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version  
"WI-T3.0.0.31126 Firebird 3.0 Alpha 2/tcp (Den-PC)/P13:C"
on disk structure version 12.0
SQL> create table t(id bigint);
SQL> create view v as select id from t;
SQL> create or alter view v as select id+1 as id from t;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-CREATE OR ALTER VIEW V failed
-DELETE operation is not allowed for system table RDB$VIEW_RELATIONS
SQL>


------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to