Two copies of phplinkdirectory in one database

[drift82]

I'm looking to install phplinkdirectory for two domains on my server. I like to keep all databases in one database, just under different schemas. (using different users and their default schemas which i create). However, when I try to install the 2nd phpLD, it's erroring out. I'm guessing some of the checks aren't schema safe.

Any ideas?

[David]

well, all the tables use the same prefix right now, so I would think it would be a problem to try to have the two sets of tables in one db. Is that what you are trying to do?

[drift82]

David,

Thanks for the quick response! I was going to do one database, but different schemas. Think of them as schemaA and schemaB. The two tables effectively become

schemaA.pld_link
and
schemaB.pld_link

The two table names are still unique because they're in different schemas. However, if some of the checks you guys use in the install script directly access the pg tables, they may not be schema-friendly. Hence they may already see a pld_link and error out.

[David]

Ah, so do I see you are using Postgres?
This would be the first example I've heard about. Cool. 8)