On Wed, 2010-12-01 at 12:13 -0800, Josh Berkus wrote: > > Well, porting applications from other database systems that support synonyms > > (i.e. Oracle, DB2, SQL Server). > > SQL Server supports synonyms? If it's not Oracle-only, it's a more > powerful argument to have the feature.
Oracle, DB2 and MSSQL support Synonyms. > I'd love to hear from someone at EDB: how are you dealing with synonym > name collisions right now? I think the way we deal with that is the way PostgreSQL deals with it. Unique names per search path. > > Is this the feature the community would benefit from? We can consider adding > > column synonyms if we won't hardwire synonyms to pg_class objects. Column synonyms don't exist as far as I can tell (at least in Oracle)[1] > > So, I don't support your idea of having a completely separate catalog. > Sorry. Yeah we have been talking about this internally and it seems (at least to me) that the 85% solution in pg_class that supports tables/views/sequences is best. I posted to the Oracle list asking how many of them use Synonyms and they are definitely a used feature. JD 1. http://www.freelists.org/post/oracle-l/Synonyms -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
