Re: [BUGS] [GENERAL] cache lookup of relation 165058647 failed

2004-05-05 Thread Sean Chittenden
temp tables don't use the shared buffer cache, how can this be related to the BG writer? Don't the system catalogs use the shared buffer cache? BEGIN; SELECT create_temp_table_func(); -- Inserts a row into pg_class via CREATE TEMP TABLE -- Do other stuff COMMIT; -- After the commit, the ro

[BUGS] problem with instalation plpgsql on Mandrake

2004-05-05 Thread Pavel Stehule
Hello I try install cvs version PostgreSQL on Mandrake 8.1. 7.4.2 I installed without problems, but when I tryed registration of plpgsql I get message ERROR: could not load library "/usr/lib/plpgsql.so:" /usr/lib/plpgsql.so: undefined symbol: MakeExprContext Can You Help me Thank You Pavel -

Re: [BUGS] problem with instalation plpgsql on Mandrake

2004-05-05 Thread Tom Lane
Pavel Stehule <[EMAIL PROTECTED]> writes: > ERROR: could not load library "/usr/lib/plpgsql.so:" /usr/lib/plpgsql.so: > undefined symbol: MakeExprContext I think you've got the wrong version of plpgsql.so. regards, tom lane ---(end of broadcast)--

Re: [BUGS] Killing the backends

2004-05-05 Thread Tom Lane
Helvio Hild <[EMAIL PROTECTED]> writes: > llamados=> SELECT int8in(8); > server closed the connection unexpectedly This is fixed as of PG 7.3. It's not fixable in earlier releases because they don't have a type-safe way of declaring I/O functions. regards, tom lane -

[BUGS] PostgreSQL 7.4.1 JDBC driver bug

2004-05-05 Thread Declan Lynch
PostgreSQL 7.4.1 JDBC driver bug   In the package   org.postgresql.geometric   the class PGcircle contains what I think is an "oversight".   For classes in this package fields are declared "public" allowing direct access.  This is true for all classes execept PGcircle where the radius field

[BUGS] Security Measures (SafeHarbor) (KMM82003618V76837L0KM)

2004-05-05 Thread CustomerSupport
Dear eBay member We recently noticed one or more attempts to log in to your eBay account from a foreign IP address and we have reasons to belive that your account was hijacked by a third party without your authorization. If you recently accessed your account while traveling,the unu

[BUGS] Turkish locale bug

2004-05-05 Thread Ismail Kizir
Hi everybody, Five years ago, i sent a patch for postgresql turkish locale patch, but nobody has taken it into consideration. Now, the source tree is totally different and pg team says they 'partially' fixed turkish locale problem. But it is still non-functional. I don't understand this, because t

Re: [BUGS] Bug in optimizer

2004-05-05 Thread Gaetano Mendola
Timo Nentwig wrote: This is very slow: SELECT urls.id FROM urls WHERE ( urls.id <> ALL (SELECT html.urlid FROM html) ); ...while this is quite fast: SELECT urls.id FROM urls WHERE ( NOT (EXISTS (SELECT html.urlid FROM tml WHERE ( html.urlid = urls.id ))) ); Are you using the

Re: [BUGS] Turkish locale bug

2004-05-05 Thread Devrim GUNDUZ
Hi, On Wed, 5 May 2004, Ismail Kizir wrote: > The solution is very simple : Don't use a locale-dependent lowercase > function in the keyword parsing process. Search the archives in -hackers -- with my name and Nicolai Tufar. This discussion has been made already. Also, there is a problem in g

Re: [BUGS] [GENERAL] cache lookup of relation 165058647 failed

2004-05-05 Thread Sean Chittenden
I'v find out that this error occurs in: dependency.c file 2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of relation 149064743 failed 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist in getRelationDescr