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 , Carnegie_Class varchar(250), Affiliation varchar(250), Level_of_Instruction varchar(250)
)
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
