Problems with insert (fwd)

From: John McKown <jmckown(at)prodigy(dot)net>
To: PostgreSQL general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Problems with insert (fwd)
Date: 2000-07-28 00:30:34
Message-ID: Pine.LNX.4.21.0007271927150.22004-100000@linux2.johnmckown.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>1. The insertion could be fast, if I'd switch off autocommit. In
>adabastcl I have the commands to do this. Is something like this
>possible via sql, psql oder the tcl-extension ? I usually use psql to
>insert data from a file, but a tcl solution would help to.

<snip>

In psql, simply use the "begin" command to begin a transaction. Now do
your "insert" commands. Finish up with a "commit" command. I think this is
the same in all the various interface languages. At least I've seen things
like (in python>:

import pg;
db=pg.DB(....)
db.query('BEGIN')
... more db.query('INSERT ...') commands
db.query('COMMIT')

Browse pgsql-general by date

  From Date Subject
Next Message Jeffery Collins 2000-07-28 00:49:01 Connection problem under extreme load.
Previous Message Chris Bitmead 2000-07-28 00:03:36 Re: 4 billion record limit?