#3280 PostgreSQL: still fails to import to schema-qualified table


Using webmin-1.441 (not in the group pull-down list)

The patch in bug # 1994113 "PostgreSQL schema quoting fixes" against 1.420 was not completely applied. In postgresql/import.cgi there is still improper quoting of schema-qualified table names. Only 1 of the 3 places where I patched &quotestr($in{'table'}) to use &quote_table($in{'table'}) has been applied to the script, resulting in import failure.

Reproduce: Create a PostgreSQL schema called webmin, create a table test.webmin, and attempt to use Import (from the Execute SQL page) to read in a file, selecting webmin.test from the list of tables.

The operation fails:
SQL insert into "webmin.test" values (?,?) failed :
ERROR: relation "webmin.test" does not exist
Webmin is improperly quoting the schema-qualified name. It should use use quote_table to get "webmin"."test", not quotestr.


  • lbayuk

    lbayuk - 2009-01-24

    Remainder of patch from bug 1994113

  • Jamie Cameron

    Jamie Cameron - 2009-01-25

    Thanks - this fix will go into the 1.450 Webmin release.

  • Jamie Cameron

    Jamie Cameron - 2009-01-25
    • status: open --> closed-fixed

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

Sign up for the SourceForge newsletter:

No, thanks