Hi guys!

I have the following table in the opencyto_quality_control schema:

CREATE TABLE opencyto_quality_control.stats
(
    Container ENTITYID NOT NULL,
    sId INT NOT NULL,
    fileId INT NOT NULL,
    gsId INT NOT NULL,
    population TEXT NOT NULL,
    stats TEXT NOT NULL,
    node TEXT NOT NULL,
    channel TEXT NOT NULL,
    value NUMERIC NOT NULL,

      CONSTRAINT PK_stats PRIMARY KEY (sId, Container)
    , CONSTRAINT FK_stats_gsTbl FOREIGN KEY (gsId, Container)
        REFERENCES opencyto_preprocessing.gsTbl (gsId, Container)
        ON DELETE CASCADE
-- ,
-- CONSTRAINT FK_stats_meta FOREIGN KEY (fcsId)
-- REFERENCES opencyto_quality_control.meta (fcsId)
-- ON DELETE RESTRICT
);

<ns:table tableName="stats" tableDbType="TABLE">
        <ns:columns>
            <ns:column columnName="sid">
                <ns:columnTitle>sid</ns:columnTitle>
            </ns:column>
            <ns:column columnName="container"/>
            <ns:column columnName="fileid">
                <ns:columnTitle>fileid</ns:columnTitle>
                <ns:fk>
                    <ns:fkDbSchema>flow</ns:fkDbSchema>
                    <ns:fkTable>FCSFiles</ns:fkTable>
                    <ns:fkColumnName>RowId</ns:fkColumnName>
                </ns:fk>
            </ns:column>
            <ns:column columnName="gsid">
                <ns:columnTitle>gsid</ns:columnTitle>
                <ns:fk>
                    <ns:fkDbSchema>opencyto_preprocessing</ns:fkDbSchema>
                    <ns:fkTable>gstbl</ns:fkTable>
                    <ns:fkColumnName>gsid</ns:fkColumnName>
                </ns:fk>
            </ns:column>
            <ns:column columnName="population">
                <ns:columnTitle>population</ns:columnTitle>
            </ns:column>
            <ns:column columnName="stats">
                <ns:columnTitle>stats</ns:columnTitle>
            </ns:column>
            <ns:column columnName="node">
                <ns:columnTitle>node</ns:columnTitle>
            </ns:column>
            <ns:column columnName="channel">
                <ns:columnTitle>channel</ns:columnTitle>
            </ns:column>
            <ns:column columnName="value">
                <ns:columnTitle>value</ns:columnTitle>
            </ns:column>
        </ns:columns>
    </ns:table>

As can be seen, it references a table gsTbl from schema opencyto_preprocessing.

If a proper entry exists in the latter table, then the stats table can be correctly populated and in the 'view' of the table one is even able to see the link with the value of the 'Name' column of the referenced row from gsTbl.

As soon as gsTbl is cleared, any tables refering to gsTbl from the opencyto_preprocessing schema in a similar fashion (via ON DELETE CASCADE), get cleared as well as expected, whereas the stats table from the opencyto_quality_control schema does not. Instead the link with the value of the 'Name' column of the referenced row from gsTbl turns into plain text with the gsId value surrounded with '<' and '>' !?

Why does this happen and how can I make it respect the ON DELETE CASCADE statement!

Thanks.
-Leo