[Firebird-devel] [FB-Tracker] Created: (CORE-1030) Switch to restore "non valid" data and constraints

[Jorge A. B. (JIRA) <tr...@fi...>]

Switch to restore "non valid" data and constraints
--------------------------------------------------

                 Key: CORE-1030
                 URL: http://tracker.firebirdsql.org/browse/CORE-1030
             Project: Firebird Core
          Issue Type: Improvement
          Components: GBAK
    Affects Versions: 2.0.0
         Environment: General
            Reporter: Jorge Andres Brugger


If you backup a database that, for example, contains null in a field define=
d as not-null, you cannot restore it. You can use "-no_validity" switch, an=
d you=C2=B4ll loose _all_ your database checks.
I=C2=B4m proposing to implement a new switch, that enables to restore a dat=
abase with checks, even if there are "non-valid data" records.
If you can add a "not null" field to a table, even if is automatically set =
to null when there are records, you should be able to restore that DB from =
backup with same state. If not, force to define a default value when adding=
 fields.

--=20
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: htt=
p://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira