app table names

From: Jamie Kahgee <jamie(dot)kahgee(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: app table names
Date: 2010-03-16 19:03:43
Message-ID: da6bca21003161203s164e906biaeb867d954063e85@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My company has a handful of apps that we deploy in the websites we build.
Recently a very old app needed to be included along side a newer app and
there was a conflict w/ a duplicate table name needed to be used by both
apps.

We are now in the process of updating an old app and there will be some DB
updates. I'm curious what people consider best practice (or how do you do
it) to help ensure these name collisions don't happen.

I've looked at schema's but not sure if thats the right path we want to
take. As the documentation
prescribes<http://www.postgresql.org/docs/8.2/interactive/ddl-schemas.html#DDL-SCHEMAS-PATH>,
I don't want to "wire" a particular schema name into an application and if I
add schema's to the user search path how would it know which table I was
referring to if two schema's have the same table name. although, maybe I'm
reading to much into this.

Any insights or words of wisdom would be greatly appreciated!

Thanks,
Jamie K.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-03-16 19:37:01 Best ISP for Postgres
Previous Message Peter Schmidtke 2010-03-16 17:06:55 Re: reuse data in existing data directory