Re: [GENERAL] allowing users access to a trusted C function

Jeff Davis <[EMAIL PROTECTED]> writes: I created (as a superuser) a set of C functions to handle boolean arithmetic (has to do with simplifying search queries of mine). I would like users to be able to access those functions somehow. >> >> If the functions are listed in pg_proc, an

Re: [GENERAL] allowing users access to a trusted C function

Tom Lane wrote: > Jeff Davis <[EMAIL PROTECTED]> writes: > > I created (as a superuser) a set of C functions to handle boolean > > arithmetic (has to do with simplifying search queries of mine). I would > > like users to be able to access those functions somehow. > > If the functions are listed i

Re: [GENERAL] Max sessions question

hi tim the answer is very much there try out man postmaster.. To increase the number of backends use the -N option. Hope this helps Anand On Fri, Dec 22, 2000 at 11:37:24AM -0800, Tim Barnard wrote: >Hello all, >I've looked through the docs and I can't find any answers to this question: How can I

[GENERAL] postmasteralive()

In my application I need to know whether the postmaster is alive or not and also whether a particular database is accessible or not. I need api's to do this. Are there any? thanks, Sandeep

[GENERAL] Max sessions question

Hello all, I've looked through the docs and I can't find any answers to this question: How can I increase the maximum number of sessions (clients)? I understand from a previous posting that the default is set to 16.   Tim HCC  

Re: [GENERAL] How crypting passwords in postgres DB?

On Fri, Dec 22, 2000 at 02:14:59PM +0100, [EMAIL PROTECTED] wrote: > However, passwords appear clear in the database. > How passwords can be crypted in the database? Postgres doesn't include any password/hashing functions natively. So you'll either need to write the hashing functions yourself (s

Re: [GENERAL] allowing users access to a trusted C function

Jeff Davis <[EMAIL PROTECTED]> writes: > I created (as a superuser) a set of C functions to handle boolean > arithmetic (has to do with simplifying search queries of mine). I would > like users to be able to access those functions somehow. If the functions are listed in pg_proc, anyone can call t

[GENERAL] Re: Very slow select

Stefano Bargioni <[EMAIL PROTECTED]> writes: >> What does EXPLAIN say about the two queries? > ucc2=> explain select count(*) from document where xtitle='a'; > NOTICE: QUERY PLAN: > Aggregate (cost=70.61 rows=759 width=4) > -> Index Scan using xtitle_index on document (cost=70.61 rows=759 wi

Re: [GENERAL] Re: [HACKERS] Merry X-Mass

And beware the Y2K + 1 bug. :) Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com - Original Message - From: "Partyka Robert" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, Dec

[GENERAL] How crypting passwords in postgres DB?

Hello, I order to escape from .htaccess, I want to save user passwords in my database. However, passwords appear clear in the database. How passwords can be crypted in the database? I use PHP 3.0.16, Cobalt Raq3i. Thanks

[GENERAL] Re: Very slow select

> Stefano Bargioni writes: > > SELECT FROM t WHERE a='my string'; works very fast. The same select > > made on b is very slow (2 or 3 seconds), as if no index exists for > > column b. > > What does EXPLAIN say about the two queries? > > regards, tom lane > Dear Tom, thank

[GENERAL] allowing users access to a trusted C function

I created (as a superuser) a set of C functions to handle boolean arithmetic (has to do with simplifying search queries of mine). I would like users to be able to access those functions somehow. They are very simple functions so I can't imagine they would be exploited (unless I am missing somethin