query string too long

Поиск
Список
Период
Сортировка
От leshan
Тема query string too long
Дата
Msg-id 37F4D3A5.65531E52@ugsolutions.com
обсуждение исходный текст
Список 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=>






В списке pgsql-general по дате отправления:

Предыдущее
От: jose soares
Дата:
Сообщение: Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT