Menu

#5588 PostgreSQL names not properly escaped

2.000
closed-fixed
nobody
5
2022-10-22
2022-10-21
No

In PostgreSQL, when a table data is viewed, I get the error "Data in this table cannot be edited because it has no primary key."

This is because the names are not properly escaped. To illustrate the problem, use the attached DB dump to create a database. Then edit each of the two tables in it and see the difference in behaviour even though both of the tables are the same apart from one table having names in all lowercase and the other in mixed case.

1 Attachments

Discussion

  • Jamie Cameron

    Jamie Cameron - 2022-10-22

    Thanks for reporting this - we'll fix this in the next release of Webmin.

     
  • Jamie Cameron

    Jamie Cameron - 2022-10-22
    • status: open --> closed-fixed
     
  • Richard Pillay

    Richard Pillay - 2022-10-22

    Boy, that was fast. Thanks, Cameron. Looking forward to the update. If this fix works, then 5366 can also be closed. I guess they should be marked duplicates at the same time.

     

Log in to post a comment.

MongoDB Logo MongoDB
Gen AI apps are built with MongoDB Atlas
Atlas offers built-in vector search and global availability across 125+ regions. Start building AI apps faster, all in one place.