From: | leshan <leshan(at)ugsolutions(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | query string too long |
Date: | 1999-10-01 15:30:45 |
Message-ID: | 37F4D3A5.65531E52@ugsolutions.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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=>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-10-01 15:48:34 | Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT |
Previous Message | jose soares | 1999-10-01 15:14:33 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |