Thread: Problem

Problem

From
"Pedro Belmino"
Date:
Hello,<br />I am a developer, I am working in the creation of hypothetical index in the data base postgresql 8.2.4. I
havea problem, the data base init normally but when I try to connect to the database it shows the following error:<br
/>TRAP:FailedAssertion("!(!isnull)", File: "relcache.c", Line: 959) .<br />You could help me to figure out what could
itbe?<br /><br />Yours truly.<br /><br /><br /><br /> 

Re: Problem

From
"Heikki Linnakangas"
Date:
Pedro Belmino wrote:
> Hello,
> I am a developer, I am working in the creation of hypothetical index in the
> data base postgresql 8.2.4. I have a problem, the data base init normally
> but when I try to connect to the database it shows the following error:
> TRAP: FailedAssertion("!(!isnull)", File: "relcache.c", Line: 959) .
> You could help me to figure out what could it be?

We're going to need much more information.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


Re: Problem

From
Tom Lane
Date:
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> Pedro Belmino wrote:
>> I am a developer, I am working in the creation of hypothetical index in the
>> data base postgresql 8.2.4. I have a problem, the data base init normally
>> but when I try to connect to the database it shows the following error:
>> TRAP: FailedAssertion("!(!isnull)", File: "relcache.c", Line: 959) .
>> You could help me to figure out what could it be?

> We're going to need much more information.

Indeed.  The failure suggests that you tried to modify the structure of
pg_index rows and didn't get all the consequences right ... but what you
said does not offer any reason to change pg_index.

There's already some things in CVS HEAD about allowing plugins to
manufacture hypothetical indexes for the planner to consider --- have
you looked at that?
        regards, tom lane