Re: [GENERAL] running a query file of 42MB

2004-12-28 Thread Nefnifi, Kasem
gsql-general@postgresql.org Subject: Re: [GENERAL] running a query file of 42MB Don't use OIDs for primary keys, please, please. Use a Sequence instead, and replace your SELECT oid by SELECT currval('sequence_name') On Tue, 28 Dec 2004 15:44:56 +0100, Nefnifi

Re: [GENERAL] running a query file of 42MB

2004-12-28 Thread Pierre-Frédéric Caillaud
Don't use OIDs for primary keys, please, please. Use a Sequence instead, and replace your SELECT oid by SELECT currval('sequence_name') On Tue, 28 Dec 2004 15:44:56 +0100, Nefnifi, Kasem <[EMAIL PROTECTED]> wrote: dear all, it is okay, the import by psql is faster and quit, it is running n

Re: [GENERAL] running a query file of 42MB

2004-12-28 Thread Nefnifi, Kasem
dear all, it is okay, the import by psql is faster and quit, it is running now. i've found an error in the query, it was the decimal separator that must be "." and not ",". now it's working. thx to all kasem, -Original Message- From: Nefnifi, Kasem Sent: Tuesday, December 28, 2004 2:28