Re: [GENERAL] Best practice? Web application: single PostgreSQL

2004-01-13 Thread Keith G. Murphy
Tom Lane wrote: "Keith G. Murphy" <[EMAIL PROTECTED]> writes: Hmmm, mightn't it be kind of nice if there were PAM or krb5 maps in addition to ident maps? ISTM the whole point of PAM is that you plug in your desired security policy outside of the application. You shouldn

Re: [GENERAL] Best practice? Web application: single PostgreSQL

2004-01-13 Thread Keith G. Murphy
John Sidney-Woollett wrote: Keith G. Murphy said: That sounds like an excellent compromise. How do you typically handle the mechanics of authentication from web server to PostgreSQL on the connect, using this scheme? Sorry but I can't help you out here, I'm too much of a newbie wit

Re: [GENERAL] Best practice? Web application: single PostgreSQL

2004-01-13 Thread Keith G. Murphy
John Sidney-Woollett wrote: Keith G. Murphy said: 2) have the web server connecting to the database actually using the user's account (possibly using LDAP authentication against PostgreSQL), and controlling access to different database entities through GRANT, etc. My experience with jav

Re: [GENERAL] Data transfer format between UNIX server and Windows client?

2001-04-05 Thread Keith G. Murphy
"Paul A. Lender" wrote: > > Hi folks > > I submitted this directly to the novice and general news groups -- getting > no responses -- before I had subscribed to the list, and I apologize to > anyone who may have responded previously. > > I've got a FreeBSD 4.2 box running PostgreSQL 7.0.3 and W

Re: [GENERAL] Re: MS Access data to PostgrSQL data

2001-01-19 Thread Keith G. Murphy
Tim Uckun wrote: > > >>hi, > >>can anyone help me ? i need to convert a ms access .mdb file into > >>somthing readable so i can insert it into my postgreSQL db... > >>does anyone have any experiance? (preferably using PHP) > >>Robert Korteweg > >>The Netherlands > > Here is your steps. > 1) Cr

Re: [GENERAL] Re: 4 billion record limit?

2000-07-28 Thread Keith G. Murphy
Mitch Vincent wrote: > > There is something else that many aren't considering. In every application > I've ever written to use any database I use ID numbers of my own making, > always they're integer. 4 billion is the limit on any integer field, not > just the OID so there are limitations everyo

Re: [GENERAL] Re: [HACKERS] TRANSACTIONS

2000-02-25 Thread Keith G. Murphy
Karl DeBisschop wrote: > > To summarize, I stated that the following does not work with > postgresql: > > > $dbh->{AutoCommit} = 0; > > $dbh->do("CREATE TABLE tmp (a int unique,b int)"); > > while (<>){ > > if (/([0-9]+) ([0-9]+)/) { > > $rtv = $dbh->do("INSERT INTO tmp VALUES ($1,$2

Re: [GENERAL] using ID as a key

2000-02-07 Thread Keith G. Murphy
Simon Drabble wrote: I agree with everything Simon says (hmmm, there's a game in that) and would add: It's very likely that at some time you will change your database design such that you will want to add or remove a field or two that uniquely identify the record (hmmm, person's first and last n

Re: [GENERAL] Some MySQL features

1999-12-03 Thread Keith G. Murphy
vincent leycuras wrote: > > Hi! > I'd like to know if pgsql supports the two excellent features that exist in > MySQL: > - the possibility to load the database with ASCII formatted file containing > the data we want to put; > - the index auto incrementation the prevents from having to specify the

Re: [GENERAL] libpq on win32 & postgresql on linux

1999-09-27 Thread Keith G. Murphy
Otavio Exel wrote: > > hello list, > > note: postgres-newbie here! Me, too, pretty much. > > I have: > - a linux box with postgresql 6.3.2 installed; > - a win95 box with postgresql-win32-client-6.4.2 (from > ftp://ftp.postgresql.org) installed; > > the win32 client can't connect due to a