execute transaction / insert rows - Mailing list pgsql-general

From Johnson, Shaunn
Subject execute transaction / insert rows
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73FF5@snt452.corp.bcbsm.com
Whole thread Raw
List pgsql-general

Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10.

Are there any examples out there to insert / update
a table for every, say, 1000 records via SQL? I'm having
a hard time just inserting into the table ... it seems
that there isn't anything going on AND I need to commit
the transaction if the query gets killed somehow.

Thanks!

-X

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Query plan not using index for some reason.
Next
From: Jean-Christian Imbeault
Date:
Subject: count() for a select statement?