Hello, all. I have a query that runs perfectly when I run it from
pgAdmin3, but bombs when I run it from ColdFusion using the JDBC
driver. I'm using postgres 7.4. The query uses dblink(), which I assume
is the source of the problem.
Can anyone provide me with any insight about why this would fail over
JDBC? Thanks
select *
into cupahr_tblunit_20050120
from dblink('dbname=tafkan', '
select u.*, c1.className as Carnegie_Class, c2.className as
Affiliation, c3.className as Level_of_Instruction
from tblunit u
inner join tblClassType ct1 on ct1.clientID = 33 and ct1.classTypeName
= ''Carnegie Class''
left join tblLinkUnitClass l1 on l1.unitID = u.unitID and
l1.classTypeID = ct1.classTypeID
left join tblClass c1 on c1.classID = l1.classID
inner join tblClassType ct2 on ct2.clientID = 33 and ct2.classTypeName
= ''Affiliation''
left join tblLinkUnitClass l2 on l2.unitID = u.unitID and
l2.classTypeID = ct2.classTypeID
left join tblClass c2 on c2.classID = l2.classID
inner join tblClassType ct3 on ct3.clientID = 33 and ct3.classTypeName
= ''Level of Instruction''
left join tblLinkUnitClass l3 on l3.unitID = u.unitID and
l3.classTypeID = ct3.classTypeID
left join tblClass c3 on c3.classID = l3.classID
where u.clientid = 33
') as tblunit(
unitid int4,
clientid int4,
groupid int4,
logoid int4,
shortname varchar(50),
unitname varchar(150),
address1 varchar(100),
address2 varchar(100),
city varchar(50),
state varchar(50),
zip varchar(10),
plus4 varchar(4),
country varchar(50),
phone varchar(50),
fax varchar(50),
o_iid int4,
o_environmentid int4,
o_itype int4,
importunitid int4,
importgroupid int4,
membertype char(10),
membertypeid int4,
isgroupsummary bool,
lastupdate timestamp
