using the same name for a related table, function, trigger

From: "Jules Alberts" <julesa(at)arbodienst-limburg(dot)nl>
To: pgsql-novice(at)postgresql(dot)org
Subject: using the same name for a related table, function, trigger
Date: 2002-01-21 13:32:57
Message-ID: 200201211337.g0LDbsLs006921@artemis.cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-novice

hello everyone,

in a database i have a table with one related function, and a trigger
that calls this function each time a row in the table is updated. at
first i wanted to use names like foo (the table), foo_fuction and
foo_trigger, but it seems much easier to create a table, function and
trigger all called "foo".

postgresql (7.1.3) lets me do this, but is it safe? will this give me
trouble in future releases, or perhaps even in the current one?

TIA

--
Jules Alberts.

Responses

  • pgaccess at 2002-01-25 23:31:56 from lee johnson

Browse pgsql-interfaces by date

  From Date Subject
Next Message Unnikrishnan Menon 2002-01-21 15:55:13 PGACCESS installation
Previous Message jtv 2002-01-21 12:18:13 Re: C++: PgDatabase or PgConnection and lifetime of the objects?

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Hesketh 2002-01-21 14:33:09 Declaring constants in PG/PLSQL
Previous Message Bo Lorentsen 2002-01-21 11:56:59 Re: one pl/pgsql question