[Libreoffice-bugs] [Bug 108068] Can't change Primary Key's name with Firebird Embedded db.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108068

--- Comment #5 from Howard Johnson <BridgeportContractor at gmail.com> ---
I had no idea, sorry for jumping up and down about this; now I will go jump up
and down at the firebird team.  :-)



Till then, is it possible to put this up on the screen:


>>To rename this field in Firebird you must either delete this field, and then re-create it with the new name, or you might want to copy it, into a new field first with the new name, and then delete the original field once this is done.

>From the Firebird 2.5 documentation
(https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-tbl.html):

 * It will not be possible to change the name of a column
   that is included in any constraint: PRIMARY KEY , UNIQUE
   key, FOREIGN KEY , column constraint or the CHECK constraint
   of the table.

 * Renaming a column will also be disallowed if the column
   is used in any trigger, stored procedure or view.


Thanks guys!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170525/952a0f0f/attachment.html>