Thread

1. Who can resolve this BUG ?

   Alexander Dederer <dederer@spb.cityline.ru> — 2001-05-17T05:37:22Z

   INM1=# explain select ref_num from grls where ag_id in (24);
   Index Scan using grls_ag_id on grls  (cost=0.00..597.87 rows=849 width=12)
   
   IMN1=# explain select ref_num from grls where ag_id in (select 24);
   Seq Scan on grls  (cost=0.00..992.44 rows=30195 width=12)
     SubPlan
       ->  Materialize  (cost=0.00..0.00 rows=0 width=0)
             ->  Result  (cost=0.00..0.00 rows=0 width=0)
   
   IMN1=# explain select ref_num from grls where ag_id = (select 24);
   Index Scan using grls_ag_id on grls  (cost=0.00..597.87 rows=849 width=12)
     InitPlan
       ->  Result  (cost=0.00..0.00 rows=0 width=0)
   
   ". . . in (24)  " work in 35 faster than ". . . in (select 24)". In the 
   last don't use indices for increase perfomans. 
   It's  been normaly work in PostgreSQL version 7.2 ? Or not?
   
   P.S.
   Sorry my English.
   
   

2. Re: Who can resolve this BUG ?

   Gregory Wood <gregw@com-stock.com> — 2001-05-18T16:11:08Z

   > IMN1=# explain select ref_num from grls where ag_id = (select 24);
   > Index Scan using grls_ag_id on grls  (cost=0.00..597.87 rows=849 width=12)
   >   InitPlan
   >     ->  Result  (cost=0.00..0.00 rows=0 width=0)
   >
   > ". . . in (24)  " work in 35 faster than ". . . in (select 24)". In the
   > last don't use indices for increase perfomans.
   > It's  been normaly work in PostgreSQL version 7.2 ? Or not?
   
   http://www.ca.postgresql.org/docs/faq-english.html#4.23
   
   Greg
   
   
   

3. password politic

   iafmgc@unileon.es — 2001-05-18T18:07:14Z

   Dear All,
   
    I am trying to configure the access to the postgreSQL server through web. I
   would like that someone could give
   a general idea of how the password politic works in PostgreSQL.
   
    Let me explain what I have tried so far.
   
    I want to do access to PostgreSQL using password encryption. What I have
   read is that in that case you need to use
   the passwd file.
   
    I tried to use the commands for adding a user to the system (create user or
   createuser on the system prompt) but I have
   seen that in that case, postgreSQL dont add a entry for the new user in the
   passwd file. BUT if I use the command "pg_passwd passwd" and gives the
   details for the new user, then it does add the entry to the passwd file, but
   not in the pg_pwd file where stores the names of the users of postgreSQL (I
   tried to access through the psql command to the database and the user doesnt
   exist after only have added using pg_passwd).
   
    Does this mean that I have to do this two steps?. I am developing an
   administration application under C++ Builder and I would like to add users
   from that application using SQL, trigger, fuctions or whatever. How can I do
   it without doing it manually?
   
    I hope I have explained myseft clearly.
   
    Thank you in advance and sorry for my English
   
    Miguel