Hi, A strange thing started occuring on our production environment (CFMX7.01 and Postgresql8.0.3).
We have an application which talks to three postgresql databases. The datasouces correctly configured includes, for example, db1, db2, and db3. Each datasource points to the database with the same name. (The datasource db1 points to the database db1, and so on.) However, against the query like <cfquery name="q" datasource="db1"> ---- </cfquery> The error message " Backend start-up failed: FATAL: database "db1_2" does not exist." is always returned. (Probably this is the message retruend by posgresql.) The same thing happens to other two datasources. In addition, when I changed the name of the datasource from db1 to db1alt, the query above has got the error "the datasouce db1alt not found". We tried clearing cfclass files, rebooting CF and postgersql, but ended up with no luck. Anyone has an idea? I am completely at a loss. I've heard our DBA changed the database name from db1_2 to db1, db2_2 to db2, and db3_2 to db3 while this applicastion was running in the past, which seems to have had an impacct. Cheeers, Terry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
