Re: [BUGS] backend don't use index when querying by indexed column

2001-08-06 Thread Tom Lane
[EMAIL PROTECTED] writes: > backend don't use index when querying by indexed column This is not necessarily a bug. > when i try to explain this select i will got this: > explain select * from formula where id_formula = 1; > NOTICE: QUERY PLAN: > Seq Scan on formula (cost=0.00..10919.89 rows=4

[BUGS] backend don't use index when querying by indexed column

2001-08-06 Thread pgsql-bugs
Zdenek Habala ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description backend don't use index when querying by indexed column Long Description I have a table named formula with this structure: id_formula | intege

Re: [BUGS] help for:FATAL 1: configuration file `postgresql.conf'has wrong permissions

2001-08-06 Thread Peter Eisentraut
Tom Lane writes: > Seems to me it makes more sense to check $PGDATA, not one individual > file within the directory. Ultimately we depend on $PGDATA to have > the right permissions. Check moved. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter