Re: [ADMIN] gmake check runs just 13 tests instead of 77

2002-11-18 Thread Andrew Sullivan
On Wed, Nov 13, 2002 at 07:56:38AM -0500, Andrew Sullivan wrote: > I'll bet it had to do with a funky path I had, though; probably I > picked up a different awk (there are two on Solaris), because I was > also working on another problem during the same period. (I can try For the record, I did co

[ADMIN] IN subselects and index / seq_scan question....

2002-11-18 Thread Marc Mitchell
I am having an optimization problem with queries that include IN clauses and subselects. xxx=> select version(); version - PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 The basic query I have is

[ADMIN] Confused about user permissions and pg_hba.conf

2002-11-18 Thread Graham Wilson
Hi all, I have searched through the archives but after 2 days of trying, I still cannot figure out how to get postgres permissions to work the way I need them to. What I am trying to do is setup Postgresql on a Linux server so that users can connect from anywhere on the subnet and edit tables t

Re: [ADMIN] IN subselects and index / seq_scan question....

2002-11-18 Thread Tom Lane
"Marc Mitchell" <[EMAIL PROTECTED]> writes: > I am having an optimization problem with queries that include IN clauses > and subselects. The optimizer currently has no clue at all about dealing with "IN (subselect)", and always converts it into the worst sort of nested-loop plan. I'm hoping to do