agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedERROR: missing FROM-clause entry for table "new"
7+ messages / 5 participants
[nested] [flat]
* ERROR: missing FROM-clause entry for table "new"
@ 2012-09-14 00:40 James Sharrett <jsharrett@tidemark.net>
2012-09-14 01:06 ` Re: ERROR: missing FROM-clause entry for table "new" David Johnston <polobo@yahoo.com>
0 siblings, 1 reply; 7+ messages in thread
From: James Sharrett @ 2012-09-14 00:40 UTC (permalink / raw)
To: pgsql-sql
I'm trying to define a trigger function that looks for changes in table A
(table the trigger for the function is on) and write a delta record into
table B. So if a record has a value of 100 in table A, and it is updated to
50, the function should write 50 in table B. I can get the trigger to work
with static SQL statements but for the actual code, I need to use dynamic
SQL because I need to alter the insert statement to B depending on what
column in table A is altered. I can get the correct SQL generated but when
I execute the string inside the trigger function I get an error because it
doesn't seem to be able to see the NEW table when it's run with EXECUTE.
So, this works in the trigger function:
Insert into A (col1,col2,colN)
Select new.col1,new.co2new.colN)
This doesn't:
sql := 'Insert into A (col1,col2,colN) ';
sql := sql || 'Select new.col1,new.co2new.colN)';
Execute sql;
ERROR: missing FROM-clause entry for table "new"
There is nothing wrong with the resulting code from sql because if I output
the string and put it in as static SQL in my trigger it works.
How do I build the string within the trigger and execute it with a reference
to NEW?
Thanks in advance for the help,
James
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: missing FROM-clause entry for table "new"
2012-09-14 00:40 ERROR: missing FROM-clause entry for table "new" James Sharrett <jsharrett@tidemark.net>
@ 2012-09-14 01:06 ` David Johnston <polobo@yahoo.com>
2012-09-14 14:06 ` Re: ERROR: missing FROM-clause entry for table "new" James Sharrett <jsharrett@tidemark.net>
0 siblings, 1 reply; 7+ messages in thread
From: David Johnston @ 2012-09-14 01:06 UTC (permalink / raw)
To: James Sharrett <jsharrett@tidemark.net>; +Cc: pgsql-sql; pgsql-sql
On Sep 13, 2012, at 20:40, James Sharrett <jsharrett@tidemark.net> wrote:
> I'm trying to define a trigger function that looks for changes in table A (table the trigger for the function is on) and write a delta record into table B. So if a record has a value of 100 in table A, and it is updated to 50, the function should write –50 in table B. I can get the trigger to work with static SQL statements but for the actual code, I need to use dynamic SQL because I need to alter the insert statement to B depending on what column in table A is altered. I can get the correct SQL generated but when I execute the string inside the trigger function I get an error because it doesn't seem to be able to see the NEW table when it's run with EXECUTE.
>
> So, this works in the trigger function:
>
> Insert into A (col1,col2,…colN)
> Select new.col1,new.co2…new.colN)
>
> This doesn't:
>
> sql := 'Insert into A (col1,col2,…colN) ';
> sql := sql || 'Select new.col1,new.co2…new.colN)';
> Execute sql;
>
> ERROR: missing FROM-clause entry for table "new"
>
> There is nothing wrong with the resulting code from sql because if I output the string and put it in as static SQL in my trigger it works.
>
> How do I build the string within the trigger and execute it with a reference to NEW?
>
> Thanks in advance for the help,
> James
>
Please read all of:
http://www.postgresql.org/docs/9.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-...
But especially 39.5.4
You want to make use of format and/or USING to pass in the values to a parameterized dynamic statement.
Note I linked to 9.2 but any recent version should have the behavior, if different section numbers.
In short the whole "NEW.name" is a variable and you need to build the statement the same way you would with any user-defined variable.
David J.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: missing FROM-clause entry for table "new"
2012-09-14 00:40 ERROR: missing FROM-clause entry for table "new" James Sharrett <jsharrett@tidemark.net>
2012-09-14 01:06 ` Re: ERROR: missing FROM-clause entry for table "new" David Johnston <polobo@yahoo.com>
@ 2012-09-14 14:06 ` James Sharrett <jsharrett@tidemark.net>
0 siblings, 0 replies; 7+ messages in thread
From: James Sharrett @ 2012-09-14 14:06 UTC (permalink / raw)
To: David Johnston <polobo@yahoo.com>; +Cc: pgsql-sql; pgsql-sql
> I'm trying to define a trigger function that looks for changes in table A
> (table the trigger for the function is on) and write a delta record into table
> B. So if a record has a value of 100 in table A, and it is updated to 50, the
> function should write 50 in table B. I can get the trigger to work with
> static SQL statements but for the actual code, I need to use dynamic SQL
> because I need to alter the insert statement to B depending on what column in
> table A is altered. I can get the correct SQL generated but when I execute
> the string inside the trigger function I get an error because it doesn't seem
> to be able to see the NEW table when it's run with EXECUTE.
>
> So, this works in the trigger function:
>
> Insert into A (col1,col2,colN)
> Select new.col1,new.co2new.colN)
>
> This doesn't:
>
> sql := 'Insert into A (col1,col2,colN) ';
> sql := sql || 'Select new.col1,new.co2new.colN)';
> Execute sql;
>
> ERROR: missing FROM-clause entry for table "new"
>
>
>
> There is nothing wrong with the resulting code from sql because if I output
> the string and put it in as static SQL in my trigger it works.
>
>
>
> How do I build the string within the trigger and execute it with a reference
> to NEW?
>
>
> Thanks in advance for the help,
> James
>
Please read all of:
http://www.postgresql.org/docs/9.2/interactive/plpgsql-statements.html#PLPGS
QL-STATEMENTS-EXECUTING-DYN
But especially 39.5.4
You want to make use of format and/or USING to pass in the values to a
parameterized dynamic statement.
Note I linked to 9.2 but any recent version should have the behavior, if
different section numbers.
In short the whole "NEW.name" is a variable and you need to build the
statement the same way you would with any user-defined variable.
David J.
---------------------------------
Thanks for the reference David. I'm now able to get the sql statement to
run as dynamic sql with the following syntax
> sql := 'Insert into A (col1,col2,colN) ';
> sql := sql || 'values($1,$2,$N )';
> Execute sql USING new.col1,new.col2new.colN
But that still leaves me with the problem that new.col1 colN aren't known
till runtime. My list of columns could vary from 5 to 50 depending on the
specific update scenario. Inside the sql string I can dynamically build $1
- $N using a counter in my loop that gets the appropriate column list but
how do I dynamically build the USING list? I tried put in a text variable
that contained a delimited list of columns as such:
list = new.col1,new.col2new.colN
> sql := 'Insert into A (col1,col2,colN) ';
> sql := sql || 'values($1,$2,$N )';
> Execute sql USING list
>
> But that gives the error:
> ERROR: there is no parameter $2
LINE 1: ...endcategory_id,time_id,metric,amount) values ($1,$2,$3,$4,$...
^ permalink raw reply [nested|flat] 7+ messages in thread
* ERROR: missing FROM-clause entry for table "new"
@ 2019-04-30 13:41 Mike LAZLO <giantmetfan@comcast.net>
2019-04-30 13:47 ` Re: ERROR: missing FROM-clause entry for table "new" Tom Lane <tgl@sss.pgh.pa.us>
2019-04-30 13:53 ` RE: ERROR: missing FROM-clause entry for table "new" Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
0 siblings, 2 replies; 7+ messages in thread
From: Mike LAZLO @ 2019-04-30 13:41 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
What is wrong with this picture:
--trigger function:
CREATE OR REPLACE FUNCTION populateAircraft()
RETURNS TRIGGER AS $populateAircraft$
BEGIN
INSERT INTO AIRCRAFT
VALUES (NEW.ev_id
, NEW.NEW.aircraft_key::int
, NEW.NEW.regis_no
, NEW.NEW.ntsb_no
, NEW.acft_missing
, NEW.far_part
, NEW.flt_plan_filed
, NEW.flight_plan_activated
, NEW.damage
, NEW.acft_fire
, NEW.acft_expl
, NEW.acft_make
, NEW.acft_model
, NEW.acft_series
, NEW.acft_serial_no
, NEW.cert_max_gr_wt::int
, NEW.acft_category
, NEW.acft_reg_cls
, NEW.homebuilt
, NEW.fc_seats::int
, NEW.cc_seats::int
, NEW.pax_seats::int
, NEW.total_seats::smallint
, NEW.num_eng::smallint
, NEW.fixed_retractable
, NEW.type_last_insp
, TO_TIMESTAMP(NEW.date_last_insp,'MM/DD/YY HH24:MI:SS')
, NEW.afm_hrs_last_insp::real
, NEW.afm_hrs::real
, NEW.elt_install
, NEW.elt_oper
, NEW.elt_aided_loc_ev
, NEW.elt_type
, NEW.owner_acft
, NEW.owner_street
, NEW.owner_city
, NEW.owner_state
, NEW.owner_country
, NEW.owner_zip
, NEW.oper_individual_name
, NEW.oper_name
, NEW.oper_same
, NEW.oper_dba
, NEW.oper_addr_same
, NEW.oper_street
, NEW.oper_city
, NEW.oper_state
, NEW.oper_country
, NEW.oper_zip
, NEW.oper_code
, NEW.certs_held
, NEW.oprtng_cert
, NEW.oper_cert
, NEW.oper_cert_num
, NEW.oper_sched
, NEW.oper_dom_int
, NEW.oper_pax_cargo
, NEW.type_fly
, NEW.second_pilot
, NEW.dprt_pt_same_ev
, NEW.dprt_apt_id
, NEW.dprt_city
, NEW.dprt_state
, NEW.dprt_country
, NEW.dprt_time::smallint
, NEW.dprt_timezn
, NEW.dest_same_local
, NEW.dest_apt_id
, NEW.dest_city
, NEW.dest_state
, NEW.dest_country
, NEW.phase_flt_spec::int
, NEW.report_to_icao
, NEW.evacuation
, TO_TIMESTAMP(NEW.lchg_date,'MM/DD/YY HH24:MI:SS')
, NEW.lchg_userid
, NEW.afm_hrs_since
, NEW.rwy_num
, NEW.rwy_len::int
, NEW.rwy_width::int
, NEW.site_seeing
, NEW.air_medical
, NEW.med_type_flight
, NEW.acft_year::int
, NEW.fuel_on_board
, NEW.commercial_space_flight::bit
, NEW.unmanned::bit
, NEW.ifr_equipped_cert::bit
, NEW.elt_mounted_aircraft::bit
, NEW.elt_connected_antenna::bit
, NEW.elt_manufacturer
, NEW.elt_model
, NEW.elt_reason_other::text);
RETURN NULL; -- result is ignored since this is an AFTER trigger
END;
$populateAircraft$ LANGUAGE plpgsql;
-- Trigger:
CREATE TRIGGER UTR_AI_STAGE_AIRCRAFT
AFTER INSERT ON STAGE_AIRCRAFT
FOR EACH ROW
EXECUTE PROCEDURE populateAircraft();
--Insert:
INSERT INTO ntsbdata.ssa.stage_aircraft (ev_id, aircraft_key, regis_no, ntsb_no, acft_missing, far_part, flt_plan_filed, flight_plan_activated, damage, acft_fire, acft_expl, acft_make, acft_model, acft_series, acft_serial_no, cert_max_gr_wt, acft_category, acft_reg_cls, homebuilt, fc_seats, cc_seats, pax_seats, total_seats, num_eng, fixed_retractable, type_last_insp, date_last_insp, afm_hrs_last_insp, afm_hrs, elt_install, elt_oper, elt_aided_loc_ev, elt_type, owner_acft, owner_street, owner_city, owner_state, owner_country, owner_zip, oper_individual_name, oper_name, oper_same, oper_dba, oper_addr_same, oper_street, oper_city, oper_state, oper_country, oper_zip, oper_code, certs_held, oprtng_cert, oper_cert, oper_cert_num, oper_sched, oper_dom_int, oper_pax_cargo, type_fly, second_pilot, dprt_pt_same_ev, dprt_apt_id, dprt_city, dprt_state, dprt_country, dprt_time, dprt_timezn, dest_same_local, dest_apt_id, dest_city, dest_state, dest_country, phase_flt_spec, report_to_icao, evacuation, lchg_date, lchg_userid, afm_hrs_since, rwy_num, rwy_len, rwy_width, site_seeing, air_medical, med_type_flight, acft_year, fuel_on_board, commercial_space_flight, unmanned, ifr_equipped_cert, elt_mounted_aircraft, elt_connected_antenna, elt_manufacturer, elt_model, elt_reason_other) VALUES ('20001208X07734','1','N6172C','LAX97FA143 ','N','091 ','IFR ',NULL,'DEST','NONE','NONE','Cessna ','T210N ','T210N ','210-63820 ','3800','AIR ','USUS','N',NULL,NULL,NULL,'6','1','RETR','ANNL','11/16/96 00:00:00','3.40000000e+01','1.64300000e+03','Y','U','U',NULL,'JAMES E. ELDREDGE ','4039 KNOLL RIDGE AVE. ','LAS VEGAS ','NV',' ','89030 ',NULL,' ','Y','RANGER ENTERPRISES ','Y',' ',' ',' ',' ',' ',' ','N','N ','UNK',NULL,NULL,NULL,NULL,'PERS','N','N','LVS ','LAS VEGAS ','NM',' ','1750','MST','LOCL','VGT ',' ','NV',' ','540',NULL,NULL,'01/02/01 10:34:39','dbo',NULL,'0',NULL,NULL,'N','N',NULL,NULL,NULL,'0','0','0','0','0',NULL,NULL,NULL) was aborted: ERROR: missing FROM-clause entry for table "new"
Where: PL/pgSQL function populateaircraft() line 26 at SQL statement
?
The only thing I can find related to this error with NEW variables is dynamic pl/pgsql which this is not.
Thanks in advanced
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: missing FROM-clause entry for table "new"
2019-04-30 13:41 ERROR: missing FROM-clause entry for table "new" Mike LAZLO <giantmetfan@comcast.net>
@ 2019-04-30 13:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2019-04-30 15:27 ` Re: ERROR: missing FROM-clause entry for table "new" Mike LAZLO <giantmetfan@comcast.net>
1 sibling, 1 reply; 7+ messages in thread
From: Tom Lane @ 2019-04-30 13:47 UTC (permalink / raw)
To: Mike LAZLO <giantmetfan@comcast.net>; +Cc: pgsql-sql@lists.postgresql.org
Mike LAZLO <giantmetfan@comcast.net> writes:
> What is wrong with this picture:
Hm, the error message is pretty unhelpful, but I think the root problem
is too many "NEW"s in several places:
> , NEW.NEW.aircraft_key::int
^^^^^^^
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: ERROR: missing FROM-clause entry for table "new"
2019-04-30 13:41 ERROR: missing FROM-clause entry for table "new" Mike LAZLO <giantmetfan@comcast.net>
2019-04-30 13:47 ` Re: ERROR: missing FROM-clause entry for table "new" Tom Lane <tgl@sss.pgh.pa.us>
@ 2019-04-30 15:27 ` Mike LAZLO <giantmetfan@comcast.net>
0 siblings, 0 replies; 7+ messages in thread
From: Mike LAZLO @ 2019-04-30 15:27 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql@lists.postgresql.org
THANKS! That was done with an pgAdmin replace! Now it runs.
Sometimes it just takes a second set of eyes!
> On April 30, 2019 at 9:47 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
> Mike LAZLO <giantmetfan@comcast.net> writes:
> > What is wrong with this picture:
>
> Hm, the error message is pretty unhelpful, but I think the root problem
> is too many "NEW"s in several places:
>
> > , NEW.NEW.aircraft_key::int
> ^^^^^^^
>
> regards, tom lane
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: ERROR: missing FROM-clause entry for table "new"
2019-04-30 13:41 ERROR: missing FROM-clause entry for table "new" Mike LAZLO <giantmetfan@comcast.net>
@ 2019-04-30 13:53 ` Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
1 sibling, 0 replies; 7+ messages in thread
From: Voillequin, Jean-Marc @ 2019-04-30 13:53 UTC (permalink / raw)
To: Mike LAZLO <giantmetfan@comcast.net>; pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Hello,
You wrote NEW twice: NEW.NEW
INSERT INTO AIRCRAFT
VALUES (NEW.ev_id
, NEW.NEW.aircraft_key::int
, NEW.NEW.regis_no
, NEW.NEW.ntsb_no
From: Mike LAZLO [mailto:giantmetfan@comcast.net]
Sent: Tuesday, April 30, 2019 3:42 PM
To: pgsql-sql@lists.postgresql.org
Subject: ERROR: missing FROM-clause entry for table "new"
CAUTION: This email originated from outside of Moody's. Do not click links or open attachments unless you recognize the sender and know the content is safe.
What is wrong with this picture:
--trigger function:
CREATE OR REPLACE FUNCTION populateAircraft()
RETURNS TRIGGER AS $populateAircraft$
BEGIN
INSERT INTO AIRCRAFT
VALUES (NEW.ev_id
, NEW.NEW.aircraft_key::int
, NEW.NEW.regis_no
, NEW.NEW.ntsb_no
, NEW.acft_missing
, NEW.far_part
, NEW.flt_plan_filed
, NEW.flight_plan_activated
, NEW.damage
, NEW.acft_fire
, NEW.acft_expl
, NEW.acft_make
, NEW.acft_model
, NEW.acft_series
, NEW.acft_serial_no
, NEW.cert_max_gr_wt::int
, NEW.acft_category
, NEW.acft_reg_cls
, NEW.homebuilt
, NEW.fc_seats::int
, NEW.cc_seats::int
, NEW.pax_seats::int
, NEW.total_seats::smallint
, NEW.num_eng::smallint
, NEW.fixed_retractable
, NEW.type_last_insp
, TO_TIMESTAMP(NEW.date_last_insp,'MM/DD/YY HH24:MI:SS')
, NEW.afm_hrs_last_insp::real
, NEW.afm_hrs::real
, NEW.elt_install
, NEW.elt_oper
, NEW.elt_aided_loc_ev
, NEW.elt_type
, NEW.owner_acft
, NEW.owner_street
, NEW.owner_city
, NEW.owner_state
, NEW.owner_country
, NEW.owner_zip
, NEW.oper_individual_name
, NEW.oper_name
, NEW.oper_same
, NEW.oper_dba
, NEW.oper_addr_same
, NEW.oper_street
, NEW.oper_city
, NEW.oper_state
, NEW.oper_country
, NEW.oper_zip
, NEW.oper_code
, NEW.certs_held
, NEW.oprtng_cert
, NEW.oper_cert
, NEW.oper_cert_num
, NEW.oper_sched
, NEW.oper_dom_int
, NEW.oper_pax_cargo
, NEW.type_fly
, NEW.second_pilot
, NEW.dprt_pt_same_ev
, NEW.dprt_apt_id
, NEW.dprt_city
, NEW.dprt_state
, NEW.dprt_country
, NEW.dprt_time::smallint
, NEW.dprt_timezn
, NEW.dest_same_local
, NEW.dest_apt_id
, NEW.dest_city
, NEW.dest_state
, NEW.dest_country
, NEW.phase_flt_spec::int
, NEW.report_to_icao
, NEW.evacuation
, TO_TIMESTAMP(NEW.lchg_date,'MM/DD/YY HH24:MI:SS')
, NEW.lchg_userid
, NEW.afm_hrs_since
, NEW.rwy_num
, NEW.rwy_len::int
, NEW.rwy_width::int
, NEW.site_seeing
, NEW.air_medical
, NEW.med_type_flight
, NEW.acft_year::int
, NEW.fuel_on_board
, NEW.commercial_space_flight::bit
, NEW.unmanned::bit
, NEW.ifr_equipped_cert::bit
, NEW.elt_mounted_aircraft::bit
, NEW.elt_connected_antenna::bit
, NEW.elt_manufacturer
, NEW.elt_model
, NEW.elt_reason_other::text);
RETURN NULL; -- result is ignored since this is an AFTER trigger
END;
$populateAircraft$ LANGUAGE plpgsql;
-- Trigger:
CREATE TRIGGER UTR_AI_STAGE_AIRCRAFT
AFTER INSERT ON STAGE_AIRCRAFT
FOR EACH ROW
EXECUTE PROCEDURE populateAircraft();
--Insert:
INSERT INTO ntsbdata.ssa.stage_aircraft (ev_id, aircraft_key, regis_no, ntsb_no, acft_missing, far_part, flt_plan_filed, flight_plan_activated, damage, acft_fire, acft_expl, acft_make, acft_model, acft_series, acft_serial_no, cert_max_gr_wt, acft_category, acft_reg_cls, homebuilt, fc_seats, cc_seats, pax_seats, total_seats, num_eng, fixed_retractable, type_last_insp, date_last_insp, afm_hrs_last_insp, afm_hrs, elt_install, elt_oper, elt_aided_loc_ev, elt_type, owner_acft, owner_street, owner_city, owner_state, owner_country, owner_zip, oper_individual_name, oper_name, oper_same, oper_dba, oper_addr_same, oper_street, oper_city, oper_state, oper_country, oper_zip, oper_code, certs_held, oprtng_cert, oper_cert, oper_cert_num, oper_sched, oper_dom_int, oper_pax_cargo, type_fly, second_pilot, dprt_pt_same_ev, dprt_apt_id, dprt_city, dprt_state, dprt_country, dprt_time, dprt_timezn, dest_same_local, dest_apt_id, dest_city, dest_state, dest_country, phase_flt_spec, report_to_icao, evacuation, lchg_date, lchg_userid, afm_hrs_since, rwy_num, rwy_len, rwy_width, site_seeing, air_medical, med_type_flight, acft_year, fuel_on_board, commercial_space_flight, unmanned, ifr_equipped_cert, elt_mounted_aircraft, elt_connected_antenna, elt_manufacturer, elt_model, elt_reason_other) VALUES ('20001208X07734','1','N6172C','LAX97FA143 ','N','091 ','IFR ',NULL,'DEST','NONE','NONE','Cessna ','T210N ','T210N ','210-63820 ','3800','AIR ','USUS','N',NULL,NULL,NULL,'6','1','RETR','ANNL','11/16/96 00:00:00','3.40000000e+01','1.64300000e+03','Y','U','U',NULL,'JAMES E. ELDREDGE ','4039 KNOLL RIDGE AVE. ','LAS VEGAS ','NV',' ','89030 ',NULL,' ','Y','RANGER ENTERPRISES ','Y',' ',' ',' ',' ',' ',' ','N','N ','UNK',NULL,NULL,NULL,NULL,'PERS','N','N','LVS ','LAS VEGAS ','NM',' ','1750','MST','LOCL','VGT ',' ','NV',' ','540',NULL,NULL,'01/02/01 10:34:39','dbo',NULL,'0',NULL,NULL,'N','N',NULL,NULL,NULL,'0','0','0','0','0',NULL,NULL,NULL) was aborted: ERROR: missing FROM-clause entry for table "new"
Where: PL/pgSQL function populateaircraft() line 26 at SQL statement
?
The only thing I can find related to this error with NEW variables is dynamic pl/pgsql which this is not.
Thanks in advanced
-----------------------------------------
Moody's monitors email communications through its networks for regulatory compliance purposes and to protect its customers, employees and business and where allowed to do so by applicable law. The information contained in this e-mail message, and any attachment thereto, is confidential and may not be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.
This email was sent to you by Moody’s Investors Service EMEA Limited
Registered office address:
One Canada Square
Canary Wharf
London, E14 5FA
Registered in England and Wales No: 8922701
-----------------------------------------
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2019-04-30 15:27 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-09-14 00:40 ERROR: missing FROM-clause entry for table "new" James Sharrett <jsharrett@tidemark.net>
2012-09-14 01:06 ` David Johnston <polobo@yahoo.com>
2012-09-14 14:06 ` James Sharrett <jsharrett@tidemark.net>
2019-04-30 13:41 ERROR: missing FROM-clause entry for table "new" Mike LAZLO <giantmetfan@comcast.net>
2019-04-30 13:47 ` Re: ERROR: missing FROM-clause entry for table "new" Tom Lane <tgl@sss.pgh.pa.us>
2019-04-30 15:27 ` Re: ERROR: missing FROM-clause entry for table "new" Mike LAZLO <giantmetfan@comcast.net>
2019-04-30 13:53 ` RE: ERROR: missing FROM-clause entry for table "new" Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox