Identify dropped columns in PLTCL

Started by Josué Maldonadoover 22 years ago3 messagesgeneral
Jump to latest
#1Josué Maldonado
josue@lamundial.hn

Hello list,

I have a trigger that loop for each column in a table, is there a way to
identify a dropped column from within a PLTCL trigger?

Thanks in advance
--
Josu� Maldonado.

#2Robert Treat
xzilla@users.sourceforge.net
In reply to: Josué Maldonado (#1)
Re: Identify dropped columns in PLTCL

if your looking in a way that shows you dropped columns, the
attisdropped field in the pg_attribute table is your best bet.

Robert Treat

On Fri, 2003-09-19 at 15:34, Josué Maldonado wrote:

Hello list,

I have a trigger that loop for each column in a table, is there a way to
identify a dropped column from within a PLTCL trigger?

Thanks in advance
--
Josué Maldonado.

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Josué Maldonado (#1)
Re: Identify dropped columns in PLTCL

=?ISO-8859-1?Q?Josu=E9_Maldonado?= <josue@lamundial.hn> writes:

I have a trigger that loop for each column in a table, is there a way to
identify a dropped column from within a PLTCL trigger?

As of CVS tip, pltcl is fixed to ignore dropped columns, I believe.

regards, tom lane