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')
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? |