MantisBT - TestLink
View Issue Details
0008892TestLinkDatabase Postgrespublic2020-03-30 14:242020-04-08 07:23
atisne 
 
highblockalways
newopen 
1.9.20 
 
Postgresql 10
0008892: Install fails when using Postgresql
The installation of the branch testlink_1_9_20_fixed fails using Postgresql database, during
Processing:sql/postgres/testlink_create_tables.sql
Install the branch testlink_1_9_20_fixed using Postgresql database.
2020-03-30 14:29:22.888 CEST [8799] testlink-upstream ERROR: syntax error at or near "unsigned" at character 357
2020-03-30 14:29:22.888 CEST [8799] testlink-upstream STATEMENT: CREATE TABLE tlbaseline_l1l2_details (
          "id" BIGSERIAL NOT NULL ,
          "context_id" BIGINT NOT NULL DEFAULT '0' REFERENCES tlbaseline_l1l2_context (id),
          "top_tsuite_id" BIGINT NOT NULL DEFAULT '0' REFERENCES tltestsuites (id),
          "child_tsuite_id" BIGINT NOT NULL DEFAULT '0' REFERENCES tltestsuites (id),
          "status" char(1) DEFAULT NULL,
          "qty" INT unsigned NOT NULL DEFAULT '0',
          "total_tc" INT unsigned NOT NULL DEFAULT '0',
          PRIMARY KEY ("id")
        )

The 'unsigned' keyword is not supported by Postgresql.
No tags attached.
Issue History
2020-03-30 14:24atisneNew Issue
2020-03-30 14:30atisneNote Added: 0029557
2020-03-31 17:35fmanNote Added: 0029558
2020-04-08 07:23atisneNote Added: 0029572

Notes
(0029557)
atisne   
2020-03-30 14:30   
Suggested fix https://github.com/TestLinkOpenSourceTRMS/testlink-code/pull/259 [^]
(0029558)
fman   
2020-03-31 17:35   
thanks, sorry for the mistakes
(0029572)
atisne   
2020-04-08 07:23   
When do you plan to add the fix on the branch?