Re: [GENERAL] Clarification

2000-12-05 Thread Alain Toussaint
> > that too is an option but it would hurt me to have to insert 20K record > > or > > something like that with a web browser. > > H How ODBC driver is supposed to help with that? Upload a CSV or > FF file and run bulk insert with COPY. with ODBC: user load the database client app (

Re: [GENERAL] Clarification

2000-12-05 Thread KuroiNeko
> that too is an option but it would hurt me to have to insert 20K record > or > something like that with a web browser. H How ODBC driver is supposed to help with that? Upload a CSV or FF file and run bulk insert with COPY. > maybe because it is/was a deal between Apple and HK to b

Re: [GENERAL] Clarification

2000-12-05 Thread Alain Toussaint
> Not actually necessary. After all, make client part do what it's supposed > to- get user input and display server responses. Browser on Macs and > HTTP/CGI + PGSQL on the server will do in most cases. that too is an option but it would hurt me to have to insert 20K record or something

Re: [GENERAL] Questions from a Newbie

2000-12-05 Thread Tom Lane
Hunter Hillegas <[EMAIL PROTECTED]> writes: > 2. While 7.1 CVS built fine on Red Hat 6.2, I can't get it to build on MacOS > X Public Beta. This is being looked at, see "darwin" traffic on pgsql-patches and pgsql-hackers. Dunno about your JDBC question tho ... ask on pgsql-interfaces ...

[GENERAL] Questions from a Newbie

2000-12-05 Thread Hunter Hillegas
I am considering migrating to PostgreSQL 7.1 from mySQL for some of my Web applications. I have a couple of questions: 1. The JDBC driver for mySQL will automatically escape special characters (like single quotes) if you use the PreparedStatement class. Does the Postgre JDBC driver do the same t

Re: [GENERAL] Clarification

2000-12-05 Thread KuroiNeko
> the only thing remaining to know is if > there's PostgreSQL ODBC-like drivers for MacOS and/or applications able > to > work with PostgreSQL. Not actually necessary. After all, make client part do what it's supposed to- get user input and display server responses. Browser on Macs and

Re: [GENERAL] Clarification

2000-12-05 Thread Alain Toussaint
> As I've recieved some "interesting" emails to clarify: > > I wish to run postgresql on a Linux (Slackware) server over a LAN. > > The client must reside on Apple MacIntosh (12 of them) > > I am not familair with any client that will allow this. I have no > problem with Linux or mac, I have very

Re: [GENERAL] Overhead of tables.

2000-12-05 Thread Soma Interesting
At 11:48 PM 12/5/2000 -0500, you wrote: >Soma Interesting <[EMAIL PROTECTED]> writes: > > I'd like to get an idea of the overhead introduced by large quantity of > > tables being hosted off a single PostgreSQL server. It is possible I'll be > > wanting to host upwards of 200-500 tables per server.

Re: [GENERAL] Many postmasters...

2000-12-05 Thread Tom Lane
Jean-Christophe Boggio <[EMAIL PROTECTED]> writes: > * Is it normal that > ps aux |grep postgres > shows (what we want : processes own by postgres) multiple postgres > backends (which seems normal to me) *AND* multiple postmaster (same > full cmd line). > Sometimes we also have "defunct"

Re: [GENERAL] Overhead of tables.

2000-12-05 Thread Tom Lane
Soma Interesting <[EMAIL PROTECTED]> writes: > I'd like to get an idea of the overhead introduced by large quantity of > tables being hosted off a single PostgreSQL server. It is possible I'll be > wanting to host upwards of 200-500 tables per server. Essentially, will I > be surprised to find

[GENERAL] Clarification

2000-12-05 Thread ashley
As I've recieved some "interesting" emails to clarify: I wish to run postgresql on a Linux (Slackware) server over a LAN. The client must reside on Apple MacIntosh (12 of them) I am not familair with any client that will allow this. I have no problem with Linux or mac, I have very limited exper

RE: [GENERAL] mailing list

2000-12-05 Thread Sam and Lisa Snow
I would suggest something like what is in use at http://www.openacs.org . The advantage is that the posts are easier to archive / search / find. You still get delivery via email, but the disadvantage is that you cannot reply without going to the web page. Sam -Original Message- From: [EM

Re: [GENERAL] Many postmasters...

2000-12-05 Thread GH
On Wed, Dec 06, 2000 at 02:06:01AM +0100, some SMTP stream spewed forth: > Hi everyone, Hi > > Using Linux RH7.0 with correct gcc and glibc, PG7.03, Apache 1.3.14 > and PHP4. We have several unresolved questions : Ah, but do not we all? ;-) > > * Is it normal that Er, it seems so...not sure

Re: [GENERAL] MacIntosh

2000-12-05 Thread Alain Toussaint
> I need to run a Linux Server with MacIntosh clients. > > Is this possible? yes (that is,as long as your mac understand the internet protocol) !!but..what kind of server ?? Alain

[GENERAL] PostgreSql and XA

2000-12-05 Thread Sandeep Joshi
Hi, Do you know if XA can be used as a resource manager? Is there any code available? OR How do I do a transaction which spans two databases automatically in Postgres? Thanks in advance, Sandeep