[GENERAL] query string too long

[leshan]

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=>






************