John Puster ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Receiving "No such file or directory" error from the database
Long Description
While setting up the sourceforge package (which requires an installation of PostgreSQL
7.1), a script created a temporary table called user_metric_tmp1_1. This table is
impossible to browse, alter, or drop. All said actions on this table result in the
following error message: "ERROR: cannot open user_metric_tmp1_1: No such file or
directory"
I have done an strace on this query given from the command line, and it does not
appear to be actually trying to access this file anywhere, even if it were to exist
somewhere.
There does not seem to be anything unusual about the table. Unfortuneatly, I am unsure
what query created or last modified this table.
The machine is an Intel Pentium III running Redhat Linux 6.2 (kernel 2.2.14),
PostgreSQL 7.1 beta 4, egcs ver. 2.91.66
Sample Code
sourceforge=> \d user_metric_tmp1_1
Table "user_metric_tmp1_1"
Attribute | Type | Modifier
-----------------------+------------------+--------------------
user_id | integer | not null default 0
times_ranked | double precision | default 0
avg_raters_importance | double precision | not null default 0
avg_rating | double precision | not null default 0
metric | double precision | not null default 0
sourceforge=> select * from user_metric_tmp1_1 ;
ERROR: cannot open user_metric_tmp1_1: No such file or directory
No file was uploaded with this report
