RestrictionClauseSelectivity

From: Ingo Assenmacher <Ingo(dot)Assenmacher(at)soziologie(dot)rwth-aachen(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: RestrictionClauseSelectivity
Date: 2000-02-23 11:41:50
Message-ID: 38B3C77E.F364329D@soziologie.rwth-aachen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All!

I have the following table:

Name: recent

+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| datum | date not null
| 4 |
| aktuell_text | text not null
| var |
| erzeuger | char()
| 5 |
| index | int2
| 2 |
+----------------------------------+----------------------------------+-------+

Filled with some data (about 9 rows).

I want to delete a specific row with:

=>delete from aktuelles where index=9;

which results in:

ERROR: RestrictionClauseSelectivity: bad value 2.280761

Where can I find help on this?

I am using PostgreSQL V6.4 on a Linux/i386 2.2.10 System.

Thanks for your help!

Regards, Ingo.

Browse pgsql-general by date

  From Date Subject
Next Message Ingo Assenmacher 2000-02-23 11:50:34 RestrictionClauseSelectivity
Previous Message Wim Ceulemans 2000-02-23 11:09:14 Re: [GENERAL] AW: [HACKERS] TRANSACTIONS