This is the test message only
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
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 <
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.
===
- 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
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
/* 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
> /* 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
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
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
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
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
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
> > 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,
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
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
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
> 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
"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
19 matches
Mail list logo