Skip site navigation (1) Skip section navigation (2)

CREATE SYNONYM ...

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: pgsql-patches(at)postgresql(dot)org, eg(at)cybertec(dot)at
Subject: CREATE SYNONYM ...
Date: 2006-03-07 08:29:34
Message-ID: 440D446E.7040509@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-patches
this patch implements CREATE SYNONYM

syntax:

   CREATE SYNONYM [TABLE | INDEX | SEQUENCE | VIEW] synname ON orgname;

   CREATE SYNONYM FUNCTION synname ON funcname(arg, arg, ...);

   DROP SYNONYM [TABLE | INDEX | SEQUENCE | VIEW] synname;

   DROP SYNONYM FUNCTION synname(arg, arg, ...);


for details about synonyms see pg_synonym table.
The synonym is just like a unix hardlink.
Every user who has CREATE rights can create a synonym.

This feature is especially important to people who want to port from 
Oracle to PostgreSQL (almost every customer who ports larger Oracle 
applications will asked for it).

Documentation will be submitted this week.
The patch applies without error against 8.1.3.

	Many thanks and best regards,

		Hans

-- 
Cybertec Geschwinde & Schönig GmbH
Schöngrabern 134; A-2020 Hollabrunn
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at

Attachment: postgresql-8.1.3-synonym-03032006.patch.gz
Description: application/x-gzip (10.5 KB)

Responses

pgsql-patches by date

Next:From: Michael GlaesemannDate: 2006-03-07 09:07:56
Subject: Re: CREATE SYNONYM ...
Previous:From: Andrew DunstanDate: 2006-03-07 03:18:56
Subject: Re: [PATCHES] implement prepared queries in plperl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group