#1716 cannot handle tables in schema

1.150
closed
5
2004-07-30
2004-07-30
No

The following was submitted to the Debian Bug Tracking System:

If the tables are created within a schema (seems to be something
like
a SQL namespace or such), the table names are shown without the
schema
prefix and webmin-postgresql seems to be not aware of the
existence of
a schema.

Example: I created a schema 'myschema' and within the schema I
created
the table myschema.mytable. webmin shows 'mytable' instead of
'myschema.mytable'. Worse:

Clicking on "View Data" leads to the following page:

Table Data
Table mytable in database mydatabase
SQL select count(*) from "mytable" failed : relation "mytable" does
not exist

Workaround: Use the correct SQL command with "Execute SQL", such
as

SELECT * FROM myschema.mytable;

Discussion

  • Jaldhar H. Vyas

    Jaldhar H. Vyas - 2004-07-30
    • milestone: 372225 --> 1.150
     
  • Jamie Cameron

    Jamie Cameron - 2004-07-30
    • status: open --> closed
     
  • Jamie Cameron

    Jamie Cameron - 2004-07-30

    Logged In: YES
    user_id=129364

    Thanks for the bug report - the next Webmin release will fix
    this problem by using full schema.tablename names ..

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks