Artifact
85469c2b61d18d8c5076a0c49107df93be4789f3:
Ticket change
[85469c2b61]
- New ticket [2e14854f4f65874b|2e14854f4f] <i>[db columns table] doesn't recognize schema names</i>.
by
anonymous
2015-09-02 16:33:04.
D 2015-09-02T16:33:04.824
J foundin 1.0.0
J icomment A\sconsole\ssession\sto\sillustrate\sthe\sproblem\sfollows\sbelow.\sNote\sthat\sthe\sdocumentation\ssays:\s<p>\r\n"The\scolumns\sobject\scommand\sallows\sthe\sprogram\sto\squery\sthe\sconnection\sfor\sthe\snames\sof\scolumns\sthat\sexist\sin\sa\s<b>given</b>\stable."\s\r\n<p>In\sPostgres\syou\sidentify\stables\sby\sa\sfully\squalified\sname,\susing\sthe\sfollowing\sname\sconvention:\r\n<schema\sname>.<table\sname>\r\n<p><hr>\r\nMain\sconsole\sdisplay\sactive\s(Tcl8.6.4\s/\sTk8.6.4)<p>\r\n(System32)\s49\s%\spackage\srequire\stdbc::postgres<p>\r\n<i>1.0.0</i><p>\r\n(System32)\s50\s%\stdbc::postgres::connection\screate\sdb\s-user\spostgres\s-password\spostgres\s-db\smydb<p>\r\n<i>::db</i><p>\r\n(System32)\s51\s%\sdb\sallrows\s{create\sschema\smyschema}<p>\r\n(System32)\s52\s%\sdb\sallrows\s{create\stable\smyschema.mytable\s(id\sserial\sprimary\skey,\sfield1\stext)}<p>\r\n(System32)\s53\s%\sdb\scolumns\smyschema.mytable\sfield1<p>\r\n(System32)\s54\s%\sdb\scolumns\smytable\sfield1<p>\r\n<i>relation\s"mytable"\sdoes\snot\sexist</i><p>\r\n(System32)\s55\s%\sdb\sallrows\s{set\ssearch_path=myschema,public}<p>\r\n(System32)\s56\s%\sdb\scolumns\smytable\sfield1<p>\r\n<i>field1\s{name\sfield1\stype\stext\snullable\s1}<i><p>\r\n(System32)\s57\s%\s<p>
J login anonymous
J mimetype text/html
J private_contact d589dc7c7c01830a044ad802b0b879d59058bd84
J severity Severe
J status Open
J title [db\scolumns\stable]\sdoesn't\srecognize\sschema\snames
J type Code_Defect
K 2e14854f4f65874b001962b8b55232baf1fa6872
U anonymous
Z a08454653d6ae4705048a2adcb7aec38
