Table names with schemes

Question

Table names with schemes

mscolly opened this issue 12 years ago · 3 comments

The quoting of table names is too simplistic. Using quick_select for example, if the tablename is schema.table, then the whole string is quoted. The DB then tries to get a table called "schema.table" instead of "schema"."table" and replies that it doesn't exist.

Answer 1 · 2012-09-13T08:54:28.000Z

Ah, yes, that's a good point. I guess I'll need to split on /\./, quote each part separately, then concatenate the result.

I'll look into fixing that up ASAP - thanks for the report!

Answer 2 · 2012-09-13T09:35:11.000Z

This problem should be fixed by 761ab14; testing a little further, then will get a new release out :)

Answer 3 · 2012-09-13T10:50:42.000Z

Fix will be going out in a dev release for tester feedback shortly, then a new stable release in the next few days.

Sorry again for the wait!