Am 16.03.2016 um 22:59 schrieb Patrick TJ McPhee:
I haven't had time to work up a unit test, and I haven't checked against trunk, yet, but it's no longer possible to db.insert() into a temp table in 4.2.1, and presumably beyond.
Thanks for reporting. As you already noticed, the problem is a filter for names starting with "pg_". Actually this filter was always in PyGres, but the filter was applied to the table name, and now it is applied to the schema name instead, which causes the problem. This was either a mistake or the idea was to filter the tables from pg_catalog and the pg_toast stuff out of get_relations(). The former filtering of table names starting with "pg_" was probably done because these names were reserved in Postgres until 7.3, but is not necessary any more.
Maybe we should add a parameter to get_relations() that allows getting unfiltered results, and get_attnames() could set that parameter when checking for the existence of the table. Alternatively, the check for the existence of the table with get_relations() could be simply left out in get_attnames() - we could check relkind in the following select instead. The filter should also be probably removed in pkey().
-- Christoph _______________________________________________ PyGreSQL mailing list [email protected] https://mail.vex.net/mailman/listinfo.cgi/pygresql
