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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfacespgsql-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?


Jules Alberts.


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

pgsql-novice by date

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

pgsql-interfaces by date

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

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