Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 37819
Status: resolved
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: onken [...] netcubed.de
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 0.09000
Fixed in: 0.09004



Subject: name collision with indexes
Hi, if you have a table with the same name as a index postgresql fails to insert into that table or select from that table. I looked at the code of Producer::PostgreSQL and found out that create_index only checks for %used_index_names but not for names of tables. BTW: there has been a case where next_unused_name has called with a scalar for $used_names which results in a critical error. I have no idea why but inserting this line fixes the problem: $used_names = {} unless(ref $used_names eq "HASH");
This code was substantially rewritten, and I believe should fix this issue as well.