pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: RestrictionClauseSelectivity: bad value -1.998477
4+ messages / 3 participants
[nested] [flat]
* ERROR: RestrictionClauseSelectivity: bad value -1.998477
@ 1999-02-01 02:34 Stefan Hornburg <racke@linuxia.de>
0 siblings, 0 replies; 4+ messages in thread
From: Stefan Hornburg @ 1999-02-01 02:34 UTC (permalink / raw)
To: pgsql-interfaces
The above error lurks in my Apache logs. I'm totally puzzled about the
cause. I'm trying to use authentification from a Postgres database with:
- Apache 1.3.4/mod_ssl 2.1.7
- Postgres 6.4
- mod_auth_pgsql 0.1
- Linux 2.0.33/libc5
Apache configuration:
<Location /ecoservice/offer/>
AuthPGSQLDatabase cex
AuthPGSQLUserTable company
AuthPGSQLUserField login
AuthPGSQLPasswordField passwd
AuthName "Cex Inner Area"
AuthType basic
require valid-user
</Location>
The login and passwd fields are empty, but that should result in a
"Authentification failed" box.
This one works fine:
<LocationMatch /ecoservice/(admin|compedit)/>
AuthPGSQLDatabase cex
AuthPGSQLUserTable admin
AuthPGSQLUserField login
AuthPGSQLPasswordField passwd
AuthName "Cex Admin Area"
AuthType basic
require valid-user
</LocationMatch>
Ciao
Racke
--
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-393656 (Coming soon: www.linuxia.de)
Come to the land of real computing where penguins and their friends
spreading the word of Open Source which crushes windows instantly.
^ permalink raw reply [nested|flat] 4+ messages in thread
* ERROR: RestrictionClauseSelectivity: bad value -1.998477
@ 1999-02-02 19:09 Stefan Hornburg <racke@gundel.han.de>
0 siblings, 1 reply; 4+ messages in thread
From: Stefan Hornburg @ 1999-02-02 19:09 UTC (permalink / raw)
To: pgsql-interfaces
The above error lurks in my Apache logs. I'm totally puzzled about the
cause. I'm trying to use authentification from a Postgres database with:
- Apache 1.3.4/mod_ssl 2.1.7
- Postgres 6.4
- mod_auth_pgsql 0.1
- Linux 2.0.33/libc5
Apache configuration:
<Location /ecoservice/offer/>
AuthPGSQLDatabase cex
AuthPGSQLUserTable company
AuthPGSQLUserField login
AuthPGSQLPasswordField passwd
AuthName "Cex Inner Area"
AuthType basic
require valid-user
</Location>
The login and passwd fields are empty, but that should result in a
"Authentification failed" box.
This one works fine:
<LocationMatch /ecoservice/(admin|compedit)/>
AuthPGSQLDatabase cex
AuthPGSQLUserTable admin
AuthPGSQLUserField login
AuthPGSQLPasswordField passwd
AuthName "Cex Admin Area"
AuthType basic
require valid-user
</LocationMatch>
Ciao
Racke
--
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-393656 (Coming soon: www.linuxia.de)
Come to the land of real computing where penguins and their friends
spreading the word of Open Source which crushes windows instantly.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477
@ 1999-02-03 09:18 Dirk Lutzebaeck <lutzeb@aeccom.com>
parent: Stefan Hornburg <racke@gundel.han.de>
0 siblings, 1 reply; 4+ messages in thread
From: Dirk Lutzebaeck @ 1999-02-03 09:18 UTC (permalink / raw)
To: Stefan Hornburg <racke@gundel.han.de>; +Cc: pgsql-interfaces
Stefan Hornburg writes:
> The above error lurks in my Apache logs. I'm totally puzzled about the
> cause. I'm trying to use authentification from a Postgres database with:
I have seen this also. Find out the table, copy it, drop the old one,
rename it. This worked for me. Take care of oid references to your
records in your table.
Dirk
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477
@ 1999-02-03 15:20 Stefan Hornburg <racke@gundel.han.de>
parent: Dirk Lutzebaeck <lutzeb@aeccom.com>
0 siblings, 0 replies; 4+ messages in thread
From: Stefan Hornburg @ 1999-02-03 15:20 UTC (permalink / raw)
To: Dirk Lutzebaeck <lutzeb@aeccom.com>; +Cc: pgsql-interfaces
Dirk Lutzebaeck <lutzeb@aeccom.com> writes:
> Stefan Hornburg writes:
>
> > The above error lurks in my Apache logs. I'm totally puzzled about the
> > cause. I'm trying to use authentification from a Postgres database with:
>
> I have seen this also. Find out the table, copy it, drop the old one,
> rename it. This worked for me. Take care of oid references to your
> records in your table.
>
> Dirk
>
After searching the archives, it seems that it is indeed a PostgreSQL
problem. A better workaround is to issue the SQL statement
"VACUUM ANALYZE".
Ciao Racke
--
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-393656 (Coming soon: www.linuxia.de)
Come to the land of real computing where penguins and their friends
spreading the word of Open Source which crushes windows instantly.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-02-03 15:20 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-01 02:34 ERROR: RestrictionClauseSelectivity: bad value -1.998477 Stefan Hornburg <racke@linuxia.de>
1999-02-02 19:09 ERROR: RestrictionClauseSelectivity: bad value -1.998477 Stefan Hornburg <racke@gundel.han.de>
1999-02-03 09:18 ` Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477 Dirk Lutzebaeck <lutzeb@aeccom.com>
1999-02-03 15:20 ` Re: [INTERFACES] ERROR: RestrictionClauseSelectivity: bad value -1.998477 Stefan Hornburg <racke@gundel.han.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox