[GENERAL] test

2000-06-28 Thread igor
This is the test message only

[GENERAL] Publishing my book

2000-06-28 Thread Bruce Momjian
I had an interesting discussion with Addison-Wesley today. It seems I will be acting as the compositor for my book, meaning I get all the edits they find and merge them into my version. The more interesting part is that they are going to be printing the book directly from the LyX/Latex generated

Re: [GENERAL] Limit for an transaction

2000-06-28 Thread John Huttley
I've had this also. The problem has always been that I've made a mistake in my SQL. Since the transaction is going to rollback anyway, any subsequent changes are ignored. I've done 95,000 inserts in a transaction without problems. Regards John - Original Message - From: Matthias Teege <

[GENERAL] problems with transactions in C++Builder

2000-06-28 Thread igor
Greatings! Help me please to resolve my problem. As appeared, postgesql server doesn't rollback transaction, when I use C++ Builder environment. May be sombody have an idea, how to make it work? The test source in the bottom of the letter. I will be very greatefull for any help. Igor. ===

Re: [GENERAL] Transactions and web applications

2000-06-28 Thread Michael Mayo
- Original Message - From: "Lincoln Yeoh" <[EMAIL PROTECTED]> > What are the recommended ways to do transactions in web applications? > > Right now I have persistent database connections, but currently they are > shared by multiple sessions. So I make sure that database level > transaction

Re: [GENERAL] Comments with embedded single quotes

2000-06-28 Thread Tom Lane
Richard Harvey Chapman <[EMAIL PROTECTED]> writes: > Are single quotation marks not allowed in comments? > test2=# /* John's cat is fat. */ > test2'# > test2'# '*/ > test2-# ; > ERROR: Unterminated quoted string > test2=# They are, but it looks like psql's primitive parser is confused here. Wha

[GENERAL] Comments with embedded single quotes

2000-06-28 Thread Richard Harvey Chapman
/* log will probably just be a table for Saruman's use only. */ Are single quotation marks not allowed in comments? test2=# /* John's cat is fat. */ test2'# test2'# '*/ test2-# ; ERROR: Unterminated quoted string test2=# I have the SQL + comments for creating my database in files that are just

Re: [GENERAL] Comments with embedded single quotes

2000-06-28 Thread Bruce Momjian
> /* log will probably just be a table for Saruman's use only. */ > > Are single quotation marks not allowed in comments? > > test2=# /* John's cat is fat. */ > test2'# > test2'# '*/ > test2-# ; > ERROR: Unterminated quoted string > test2=# > > I have the SQL + comments for creating my databas

[GENERAL] pg_atoi()

2000-06-28 Thread Richard Harvey Chapman
Is there a reason why pg_atoi() was programmed to fail if the entire input string is not valid? i.e. "109" yields 109, but "109 apples" yields an error. Snippet from pg_atoi() in src/backend/utils/adt/numutils.c: l = strtol(s, &badp, 10); if (errno) /* str

Re: [GENERAL] pg_atoi()

2000-06-28 Thread Tom Lane
Richard Harvey Chapman <[EMAIL PROTECTED]> writes: > Is there a reason why pg_atoi() was programmed to fail if the entire > input string is not valid? > i.e. "109" yields 109, but "109 apples" yields an error. Because that's what it ought to do, if you ask me ;-). "109 foo" is not a valid integer

Re: Re[2]: [GENERAL] Restricting queries by the presence of a WHERE clause

2000-06-28 Thread Tom Lane
John Morton <[EMAIL PROTECTED]> writes: >> webclient <---> proxy <---> Postgres > Minuses: > - Another machine to buy > - Root on the proxy is as bad as root was on the secure server, so.. > - The simple hack will need thorough security auditing > - It's yet another machine to secure. > - It

Re: [GENERAL] Interface Question

2000-06-28 Thread Charles Tassell
All of the different interfaces have there own way of specifying the host to connect to (eg, with pgsql it's "pgsql -h hostname databasename") You also have to setup the pg_hba.conf file in your PGDATA directory (/usr/local/pgsql/data on my machine) to allow access from the remote machine. U

Re[2]: [GENERAL] Restricting queries by the presence of a WHERE clause

2000-06-28 Thread John Morton
On Wed, 28 Jun 2000 11:50:25 -0400 you wrote: > John Morton <[EMAIL PROTECTED]> writes: > > What I'd like to be able to do is have the database drop any SELECT, > > UPDATE or DELETE queries unless they have something fairly specific in > > their WHERE clause. > > What about COPY? Er.. wh

Re: Re[2]: [GENERAL] Restricting queries by the presence of a WHERE clause

2000-06-28 Thread Lincoln Yeoh
> > webclient <---> proxy <---> Postgres > >Ok. Pluses: > >- The standalone program is easier to hack together than delving into the > database I could probably just hack on SQL Relay or something. >- The proxy can be as tightly secured as the database without losing > functionallity,

Re[2]: [GENERAL] Restricting queries by the presence of a WHERE clause

2000-06-28 Thread John Morton
On Wed, 28 Jun 2000 07:32:11 -0500 (EST) you wrote: > Wouldn't it be possible to create a trigger and check for the where clause > there? First of all, I've got no idea how to check a where clause inside a trigger, which was the main reason I asked :-) I've only every built trigger functions

[GENERAL] FW: Error

2000-06-28 Thread Ned Lilly
Marc, I'm forwarding your note to the PostgreSQL-GENERAL discussion list. Regards, Ned > -Original Message- > From: Marc Allard [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 28, 2000 12:51 PM > Subject: Error > > I am sorry to send you this e-mail, but I don't where to send this

[GENERAL] Interface Question

2000-06-28 Thread kurt miller
How would I connect a Unix client (perl,psql,etc.) on one machine to a Unix postgres backend on another machine? Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Re: [GENERAL] anyone heard of "recall"?

2000-06-28 Thread Bruce Momjian
> Here's an interesting approach to redundancy - I wonder how much of a > performance hit postgres would take if it optionally used this for > underlying table storage? > http://www.fault-tolerant.org/recall/recall-faq.html > > Browsing through the cvs tree, I even see a postgres director

Re: [GENERAL] Lingering Backend Processes

2000-06-28 Thread Tom Lane
"Arthur M. Kang" <[EMAIL PROTECTED]> writes: > If a postgres connection dies without implicitly disconnecting from the > database, it seems that the backend processes hangs around > indefinitely. Does anyone know of a way to get around this?? This sounds like a bug in either your webserver or th