By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

Identify dropped columns in PLTCL

P: n/a
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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #2

P: n/a
=?ISO-8859-1?Q?Josu=E9_Maldonado?= <jo***@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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.