473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Identify dropped columns in PLTCL

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
2 1195
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
=?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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: DraguVaso | last post by:
Hi, I want my application do different actions depending on the exception it gets. For exemple: I have an SQL-table with a unique index. In case I try to Insert a record that's alreaddy in it I...
0
by: Ross | last post by:
Hello everybody, When I try to configure my data adapter for ODBC I get the error "Could not determine which columns uniquely identify the rows for "Shipments"." This is for my update and delete...
7
by: Russ Brown | last post by:
Hi, I'm trying to debug a pltcl procedure (being used as a trigger), and I'm having trouble generating useful debug output. I'm using elog, and I want the output to contain the value of an...
1
by: Együd Csaba | last post by:
Hi All, I run into an error message. I have the following function where t_stockchanges is one of my tables. -------------------------------------------- create or replace function...
6
by: Woody Splawn | last post by:
I know that I can do the following to identify the parent name of an active control Dim sParentName As String = ActiveControl.Parent.Name But how do I identify the name of the active control?...
0
by: Ian Harding | last post by:
I am trying to build pltcl.so and have a small problem. It builds fine butwhen I try to createlang, I get the dreaded "...server closed the connection unexpectedly..." error and the log just says...
0
by: bazzer | last post by:
im trying to access a microsoft access database from an asp.net webform. but when i use the OdbcDataAdapter config wizard i get the following errors: *Generated UPDATE statement -could not...
3
by: angelnjj | last post by:
I'm going to do my best to describe purpose and what I need...here goes. I'm writing a data entry "quality" report and working. I'm trying to identify anytime a user adds a new contact to the db...
5
by: Rahul Babbar | last post by:
Hi, I am facing an issue here. I had to drop a number of columns (around 20) from a table, which I tried to do all at the same time using the following command. Alter table table_name drop...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.