Internal errors when creating views ...

Поиск
Список
Период
Сортировка
От marten@feki.toppoint.de
Тема Internal errors when creating views ...
Дата
Msg-id 199909090211.TAA13857@feki.toppoint.de
обсуждение исходный текст
Ответы Re: [INTERFACES] Internal errors when creating views ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-interfaces
Actually I've send this error notice to some pgsql newsgroups
before, but I get no real answer to this problem.

Now I've some further informations for you about this
error. The error has nothing to do with column names or anything
like this. It's an internal error of PostgreSQL and I've no idea
how to solve it. I'm not very happy, that I get such errors with
a database and we gave up the idea to use PostgreSQL for our
application noew and we'll wait another year.

Perhaps you may wonder how large such statements are. They are all
statements created by a framework automatically and this framework
works under several databases - Oracle, Sybase, DB2, Adabas etc.

Now to the internal error:

I create a table using the following statement without any problems:

create table TDFROBJECT(PHID CHAR(15) NOT NULL,BLOCKED CHAR(15),CACHABLE
CHAR(1),COMPANYID CHAR(15),DFPREVIOUSVERSIOID CHAR(15),DFRASCORDER
CHAR(1),DFRATTCRTDODATETIM TIMESTAMP,DFRATTMODDODATETIM
TIMESTAMP,DFRCONCRTDODATETIM TIMESTAMP,DFRCONMODDODATETIM
TIMESTAMP,DFRDOCDATETIME TIMESTAMP,DFRRESOURCELIMIT INT4,DFRRESOURCEUSED
INT4,DFRROOTID CHAR(15),DOCLAYOUTID CHAR(15),DOCOWNERID
CHAR(15),DOCUMETYPATTRIBUID CHAR(15),ENDDATEANDTIME TIMESTAMP,INTFLGS
INT4,PAGES INT2,PARENTDFROBJECTID CHAR(15),PHDOCLAYOUTID
CHAR(15),PURGEDDATEANDTIME TIMESTAMP,REFERENCDFROBJECID
CHAR(15),REFERENTDELETED CHAR(1),RELEASESTATE CHAR(1),STARTDATEANDTIME
TIMESTAMP,VERSIONSTATE CHAR(1),DFRTITLE VARCHAR(80),OBJECTREFERENCE
CHAR(15),OBJECTTYPE VARCHAR(30),FILENAME VARCHAR(30),ODMAAUTHOR
VARCHAR(30),ODMDOCVERSION VARCHAR(25),ODMSUBJECT
VARCHAR(80),ODMTITLETEXT VARCHAR(80),GROUPTYPE
VARCHAR(30),SEARCHCRITERIA VARCHAR(30),SEARCHDOMAIN VARCHAR(30))

Then I try to create a view on this table and the following commands
works:

create view VTDFROBJECT AS SELECT

OBJECTREFERENCE,PHID,BLOCKED,CACHABLE,COMPANYID,DFPREVIOUSVERSIOID,DFRASCORDER,DFRATTCRTDODATETIM,DFRATTMODDODATETIM,DFRCONCRTDODATETIM,DFRCONMODDODATETIM,DFRDOCDATETIME,DFRRESOURCELIMIT,DFRRESOURCEUSED,DFRROOTID,DOCLAYOUTID,DOCOWNERID,DOCUMETYPATTRIBUID,ENDDATEANDTIME,INTFLGS,PAGES,PARENTDFROBJECTID,PHDOCLAYOUTID,PURGEDDATEANDTIME,REFERENCDFROBJECID,REFERENTDELETED,RELEASESTATE,STARTDATEANDTIME,VERSIONSTATE
FROM TDFROBJECT

Now I add another column to the statement and it fails:

create view VTDFROBJECT AS SELECT

OBJECTREFERENCE,PHID,BLOCKED,CACHABLE,COMPANYID,DFPREVIOUSVERSIOID,DFRASCORDER,DFRATTCRTDODATETIM,DFRATTMODDODATETIM,DFRCONCRTDODATETIM,DFRCONMODDODATETIM,DFRDOCDATETIME,DFRRESOURCELIMIT,DFRRESOURCEUSED,DFRROOTID,DOCLAYOUTID,DOCOWNERID,DOCUMETYPATTRIBUID,ENDDATEANDTIME,INTFLGS,PAGES,PARENTDFROBJECTID,PHDOCLAYOUTID,PURGEDDATEANDTIME,REFERENCDFROBJECID,REFERENTDELETED,RELEASESTATE,STARTDATEANDTIME,VERSIONSTATE,DFRTITLE
FROM TDFROBJECT

The frontend gets the error message:  "DefineQueryRewrite: rule plan
string too big"

The backend prints the following messages:

SIIncNumEntries: table is 70% full, signaling postmaster
pmdiew 12
ERROR: DefineQueryRewrite: rule plan string too big !


Software: PostgreSQL 6.5.1 under SuSE 6.1


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

Предыдущее
От: "Sergio A. Kessler"
Дата:
Сообщение: odbc DM 3.5x
Следующее
От: Byron Nikolaidis
Дата:
Сообщение: Re: [INTERFACES] odbc DM 3.5x