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