[GENERAL] Re: [HACKERS] random() function produces wrong range

2000-08-03 Thread Roland Roberts
-BEGIN PGP SIGNED MESSAGE- > "Thomas" == Thomas Swan <[EMAIL PROTECTED]> writes: Thomas> Is it possible to test (during configure phase) and then Thomas> go from there... or does it need to be the same for all Thomas> platforms? You should be able to test, but it is, of

Re: [GENERAL] Re: [HACKERS] random() function produces wrong range

2000-08-03 Thread Roland Roberts
-BEGIN PGP SIGNED MESSAGE- > "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> Actually the odds are far better than that. If the range is Tom> 2^31-1 then only about 2^-16th of the outputs should be less Tom> than 2^15. So ten probes gives you a failure probability of

[GENERAL] Re: [SQL] Permissons on database

2001-03-12 Thread Roland Roberts
> "bk" == Boulat Khakimov <[EMAIL PROTECTED]> writes: bk> How do I grant permissions on everything in the selected bk> databes? bk> GRANT doesnt take as on object database name nor does it bk> accept wild chars Attached is some Perl code I wrote long ago to do this. Thi

[GENERAL] Triggers: options besides compiled code?

1998-07-09 Thread Roland Roberts
I started to look at the triggers documentation and was immediately dismayed to discover that I would have compile code to create a trigger. I have been using the old "rules" mechanism to automatically put a sequence number into a tuple when inserting new rows. Are my choices limited to just (1)

Re: [GENERAL] Triggers: options besides compiled code?

1998-07-12 Thread Roland Roberts
> "dej" == Jackson, DeJuan <[EMAIL PROTECTED]> writes: >> if you insert a new row, isn't the sequence automatically >> inserted? >> dej> It is if you use table defaults. (see 'create table', and dej> 'netval()') Thanks for the tip; Richard Lynch <[EMAIL PROTECTED]> had

[GENERAL] PostgreSQL connect options?

1998-08-01 Thread Roland Roberts
Once upon a time, I know I saw an example of using connect options to specify things like a user name. I can't find any examples in any of the references now. So what are some of the options and how does one specify them? roland -- Roland B. Roberts, PhD Custom Software Soluti

[GENERAL] PHP and keystone (formerly PTS)

1998-08-01 Thread Roland Roberts
This isn't exactly a PostgreSQL question, but... I've sent e-mail to [EMAIL PROTECTED], the author of Keystone, about what one needs to do to get Keystone to work with PostgreSQL. I have it almost working, and am wondering if anyone here has successfully used Keystone with PostgreSQL. What seem

Re: [GENERAL] PostgreSQL connect options?

1998-08-01 Thread Roland Roberts
>>>>> "Maarten" == Maarten Boekhold <[EMAIL PROTECTED]> writes: Maarten> On Sat, 1 Aug 1998, Roland Roberts wrote: [...] Maarten> PQconnectdb("dbname=database user=username password=pwd Maarten> authtype=password"); This

[GENERAL] PostgreSQL catalogues: how to find the primary key?

1998-08-02 Thread Roland Roberts
-BEGIN PGP SIGNED MESSAGE- I've been trying to get Keystone (http://www.stonekeep.com/keystone/) up and running. The PHP script it uses are really oriented to MySQL, although there is a mostly complete set of PostgreSQL functions written for it. One thing missing is a query to find the