[BUGS] Join Problem in Postgres 7.0.2

2000-11-29 Thread pgsql-bugs
Khang Le ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Join Problem in Postgres 7.0.2 Long Description Database: Postgres 7.0.2 Platform: Red Hat Linux release 6.0 (Hedwig) Kernel 2.2.5-15smp on an i586 Date: 11

Re: [BUGS] Join Problem in Postgres 7.0.2

2000-11-29 Thread Tom Lane
[EMAIL PROTECTED] writes: > I get into a situation, in which I think it is a bug in either psql or > the database. I have experienced that when I ran two queries in psql, > which are equivalent, I received two different results Does EXPLAIN show that the failing query has a Merge Join directly u

Re: [BUGS] PortalHeapMemoryFree...in diskless client

2000-11-29 Thread Karla Peralta
Tom Lane wrote: > Karla Peralta <[EMAIL PROTECTED]> writes: > >> Show us a sequence of queries that causes these messages, and we'll > >> fix it ... > > > The messages show ups in two queries > > It hardly seems likely that such simple queries would trigger a failure > like this. I believe, for

[BUGS] LIKE on index bug

2000-11-29 Thread Vit Pavlik
I have problem with LIKE operator when index scan is used. When I use pattern with space just before '%' character (e.g. 'Line %'), I get bad results. For example: test=# create table test ( a int, b varchar(20)); CREATE test=# create index test_b on test(b); CREATE test=# create function fill_t

Re: [BUGS] Both cross-named & compound foreign key constaints fail

2000-11-29 Thread Stephan Szabo
On Mon, 27 Nov 2000 [EMAIL PROTECTED] wrote: Won't have a full answer until I'm home, but figured I'd send something. > Description: Run the psql script below to generate > the following error: > psql:bug.sql:54: ERROR: > const