Mailing List Archive


Back to the month index Back to the list index
aoster (alster@interport.net)
Wed, 11 Sep 1996 10:00:38 -0400 (EDT) 

Date: Wed, 11 Sep 1996 10:00:38 -0400 (EDT)
From: aoster <alster@interport.net>
Subject: Re: [mSQL] DB Loader Script must run twice
Message-Id: <Pine.SUN.3.93.960911095916.25037o-100000@interport.net>

On Tue, 10 Sep 1996, Joao Marcos Melo Mendes wrote:

> I have a Perl script that drops all the tables in a DB, then proceeds to
> create and populate them with values from a bunch of text files.
>
> Systematically, the script complains of a non-unique value in a key
> column and aborts, but if I run it again, it completes without errors.
>
> I know for a fact that the text file does not contain a repeat value in
> the key column for that table.
>
> The best explanation I can come up with is that the script is failing to
> drop all the tables, but I can't find a valid reason for that, since I am
> getting the table names from the API.

I think I have seen this before. It's really odd ....I wound up doing
"delete from mytable" for each table to clear them ...which works fine

                                       ---
                    alster@interport.net allen@metaverse.com

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!