Does any one know a way around the query string too long error?
I am trying to create a view. Below is the create command and the error
message.
Thank you,
Jd
create view external_job as
select
positions.id as position_id, positions.title as position_title,
external, expire, never, area, subarea, manager, travel, info,
overview, prereqs, functions, created,
contact.title as contact_title, contact.id as contact_id,
address1, address2, address3, fax, email,
city, state, country, region
from positions, location, position_location, contact
where
position_id=positions.id
and location_id=location.id
and contact_id=contact.id
;
hr=> \i internal.sql
create view internal_job as
select
positions.id as position_id, positions.title as position_title,
external, expire, never, area, subarea, manager, travel, info,
overview, prereqs, functions, created,
contact.title as contact_title, contact.id as contact_id,
address1, address2, address3, fax, email,
city, state, country, region
from positions, location, position_location, contact
where
position_id=positions.id
and location_id=location.id
and contact_id=contact.id
;
ERROR: DefineQueryRewrite: rule plan string too big.
EOF
hr=>