[PATCHES] CREATE SYNONYM ...

[Hans-Jürgen Schönig]

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.



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

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).

postgresql-8.1.3-synonym-03032006.patch.gz
Description: GNU Zip compressed data

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings