GNOME Bugzilla – Bug 558752
ServerOperation CREATE TABLE doesn't work
Last modified: 2008-11-01 02:15:35 UTC
Please describe the problem: When creating a ServerOperation CREATE TABLE with references to other table, I found that setting the key /FKEY_S/FKEY_FIELDS_A/@FK_FIELD/%d fails with the following error: ** ERROR:(gda-server-operation.c:403):node_find_or_create: assertion failed: (node) Using SVN revision 3248 and with the following command: gda-list-server-op-4.0 -o CREATE_DB -p PostgreSQL You Get: Using XML descriptions in /usr/share/libgda-4.0 For provider PostgreSQL I/O warning : failed to load external entity "/home/esodan/.libgda/config" Description for type: CREATE_DB Operation not supported With this command: gda-list-server-op-4.0 -l -p PostgreSQL You Get: Using XML descriptions in /usr/share/libgda-4.0 For provider PostgreSQL I/O warning : failed to load external entity "/home/esodan/.libgda/config" Existing operation types for provider 'PostgreSQL': CREATE_DB DROP_DB CREATE_TABLE DROP_TABLE RENAME_TABLE ADD_COLUMN DROP_COLUMN CREATE_INDEX DROP_INDEX CREATE_VIEW DROP_VIEW Steps to reproduce: 1. Use the attached code 2. Compiles and execute it. Actual results: Expected results: Does this happen every time? Other information:
Created attachment 121763 [details] Code to use for Reproduce Bug 558752 This patch shows the code used to test the new features to implement in gda_prepare_crate_table to add Foreing References flag, but fails to use a PostgreSQL provider (in a SQLite provider this functionality is ignored).
This bug will be resolved when applied the PATCH-GdaEasy-CreateTable-References.diff patch where implements and resolves the use of references in gda_prepare_create_table function. *** This bug has been marked as a duplicate of 529794 ***