pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: none
3+ messages / 3 participants
[nested] [flat]
* Re: none
@ 1999-09-02 07:59 Anatoly K. Lasareff <tolik@aaanet.ru>
0 siblings, 0 replies; 3+ messages in thread
From: tolik@aaanet.ru @ 1999-09-02 07:59 UTC (permalink / raw)
To: Martin Neumann <lists@mne.de>; +Cc: pgsql-sql
>>>>> "MN" == Martin Neumann <lists@mne.de> writes:
MN> Every day I get a plain-vanilla ASCII-file containg space-separated
MN> values. I parse the file with a script and make each row in the file an
MN> INSERT-statement. Sometimes one of these many statements contains
MN> rubbish becaused the line in the file I was processing contained
MN> rubbish.
MN> If I did a separate transaction for every INSERT-statement this doesn't
MN> hurt because only one statement (the broken one) doesn't get processed.
MN> But I have to do about 100.000 INSERTs everyday and this is _slow_ if I
MN> let PostgreSQL process each statement individually.
MN> So my idea was to use a chained transaction. This works perfectly as
MN> long as all INSERT-statement are okay. But if one is broken, PostgreSQL
MN> doesn't process the other statements, too.
MN> My goal is to use chained transaction and to don't have to bother
MN> about broken INSERT-statements. Is that possible or to do I have to
MN> check the statements manually (by the script) before executing?
I think your second way is better - check statement in script
before executing.
--
Anatoly K. Lasareff Email: tolik@icomm.ru
^ permalink raw reply [nested|flat] 3+ messages in thread
* None
@ 2002-09-26 17:51 Jordan Reiter <jordan@breezing.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jordan Reiter @ 2002-09-26 17:51 UTC (permalink / raw)
To: pgsql-sql
--
Jordan Reiter mailto:jordan@breezing.com
Breezing.com http://breezing.com
1106 West Main St phone:434.295.2050
Charlottesville, VA 22903 fax:603.843.6931
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: (NONE)
@ 2006-02-08 17:27 BigSmoke <bigsmoke@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: BigSmoke @ 2006-02-08 17:27 UTC (permalink / raw)
To: pgsql-sql
Your question is not clear at all.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-02-08 17:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-02 07:59 Re: none Anatoly K. Lasareff <tolik@aaanet.ru>
2002-09-26 17:51 None Jordan Reiter <jordan@breezing.com>
2006-02-08 17:27 Re: (NONE) BigSmoke <bigsmoke@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox