On Dec 3, 2010, at 2:17 AM, Alvaro Herrera wrote:
Excerpts from Robert Haas's message of jue dic 02 21:10:48 -0300 2010:
On Thu, Dec 2, 2010 at 3:43 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
Yeah, the Oracle
On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
Well, porting applications from other database systems that support
synonyms
(i.e. Oracle, DB2, SQL Server).
SQL Server supports
Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
Well, porting applications from other database systems that
On Thu, Dec 2, 2010 at 3:43 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Josh Berkus's message of mié dic 01 17:13:35
Excerpts from Robert Haas's message of jue dic 02 21:10:48 -0300 2010:
On Thu, Dec 2, 2010 at 3:43 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Robert Haas's message of jue dic 02 17:27:01 -0300 2010:
Yeah, the Oracle system is a lot more complex than SQL Server's, but
On Nov 30, 2010, at 10:05 PM, Josh Berkus wrote:
Alexey,
Here is the proposal to add synonyms to PostgreSQL. Initial goal is to add
synonyms
for relations (tables, views, sequences) and an infrastructure to allow
synonyms
for other database objects in the future.
Can you explain,
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.
(IMHO, the main reason why Oracle has synonyms is that their
implementation
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
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.
Have you had an employment change I didn't know about, JD? ;-)
--
On Wed, Dec 1, 2010 at 8:46 PM, Josh Berkus j...@agliodbs.com wrote:
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.
Have you had an
On Wed, 2010-12-01 at 12:46 -0800, Josh Berkus wrote:
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.
Have you had an employment
Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
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.
Hi all,
On Tue, 2010-11-30 at 12:05 -0800, Josh Berkus wrote:
Can you explain, for our benefit, the use case for this? Specifically,
what can be done with synonyms which can't be done with search_path and
VIEWs?
I had a few cases where synonyms for user/data base names would have
helped me
Alexey Klyukin al...@commandprompt.com writes:
To support addition of new database objects types that can be referenced by
synonyms a new system catalog, pg_synonym, is to be added, with an oid to
support comments on synonym, and the following schema:
This is not going to work, at least not
On Nov 30, 2010, at 6:28 PM, Tom Lane wrote:
Alexey Klyukin al...@commandprompt.com writes:
To support addition of new database objects types that can be referenced by
synonyms a new system catalog, pg_synonym, is to be added, with an oid to
support comments on synonym, and the following
Alexey Klyukin al...@commandprompt.com writes:
On Nov 30, 2010, at 6:28 PM, Tom Lane wrote:
This is not going to work, at least not without making every type of
lookup consult pg_synonym too, which I think can be considered DOA
because of its performance impact on people who aren't even using
Alexey,
Here is the proposal to add synonyms to PostgreSQL. Initial goal is to add
synonyms
for relations (tables, views, sequences) and an infrastructure to allow
synonyms
for other database objects in the future.
Can you explain, for our benefit, the use case for this? Specifically,
17 matches
Mail list logo