[GENERAL] unsubscribe

2005-03-07 Thread Nefnifi, Kasem
Disclaimer: This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any ac

[GENERAL] stored procedure from oracle to pgsql

2005-01-19 Thread Nefnifi, Kasem
Dear, I'm new in pgsql, come from oracle and sql server. any one can help by transferring a pl/sql procedure that imports data from a flat file, using UTL_FILE, and inserts or updates tables. bellow the proc: CREATE OR REPLACE Procedure UPD is sOracleMsg varchar2(512); sCusto

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

2004-12-28 Thread Nefnifi, Kasem
712 28 63 GSM : +32 495 25 12 33 Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> www.atosorigin.com <http://www.atosorigin.com> -Original Message- From: Pierre-Frédéric Caillaud [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 28, 2004 4:10 PM To: Nefnifi, Kasem; p

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: T

[GENERAL] running a query file of 42MB

2004-12-28 Thread Nefnifi, Kasem
I'm trying to run query generated by an import script. postgresql 8 onder windows XP. the file is about 42MB, i've opened this file by pgAdminIII and start the query, it inserts data into 3 tables and after makes some update. the time is too much and it hangs up without any commit. any body know

Re: [GENERAL] starting the database server

2004-11-30 Thread Nefnifi, Kasem
est to me and thx in advance. -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 5:42 PM To: Nefnifi, Kasem Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] starting the database server Nefnifi, Kasem wrote: > Hi Richard, bellow the

Re: [GENERAL] starting the database server

2004-11-30 Thread Nefnifi, Kasem
uot; -- end log file -- Best Regards / Vriendelijke Groeten / Salutations Distinguées / Freundliche Grüße !!! Kasem NEFNIFI AtosOrigin Belgium N.V. Minervastraat 7 1930 Zaventem (Belgium) Tel : +32(0)2 712 28 30 Fax : +32(0)2 712 28 63 GSM : +32 495 25 12 33 Ema

[GENERAL] starting the database server

2004-11-30 Thread Nefnifi, Kasem
Hello,   I'm using a windows 2000 advanced server, postgresql was installed and working fine, and I'm using pgadminIII. the database server cannot start and get error "is the postmaster running with -i on localhost 127.0.0.1 and accepting tcp/ip connection on the port 5432"   the last ti