[HACKERS] fatal: cache id 30 (or alike)

2005-02-02 Thread G u i d o B a r o s i o
Following belows thread

http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg43381.html

I am experiencing the same problem on a brand new, extremely fresh, solaris 5.9 
and PostgreSQL 7.4.6 box.

As expected, the problem was solved when passing the -d [1-5] to the 
postmaster. But... I was wondering (after googling and founding less than 1 
page of posts related) if a  diff was submited in order to avoid some strange 
debuging mesages when using the psql :)

OUch...also using GIS, but I don't believe this has something to do.

If needed, I would post the output messages, but thought that the above link 
will (exactly the same messages) provide an idea.

Hints?

Thanks in advance,
Guido



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] fatal: cache id 30 (or alike)

2005-02-02 Thread Tom Lane
G u i d o B a r o s i o [EMAIL PROTECTED] writes:
 Following belows thread
 http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg43381.html

 I am experiencing the same problem on a brand new, extremely fresh, solaris 
 5.9 and PostgreSQL 7.4.6 box.

 As expected, the problem was solved when passing the -d [1-5] to the 
 postmaster. But... I was wondering (after googling and founding less than 1 
 page of posts related) if a  diff was submited in order to avoid some strange 
 debuging mesages when using the psql :)

It's fixed in 8.0, I believe.

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match