On Wed, Dec 28, 2005 at 09:47:34PM -0700, Michael Fuhr wrote:
> What are you expecting to happen and what actually does happen?
Another thing: are you calling the lo_* functions within a transaction?
As the Client Interfaces section of the Large Objects chapter in
the documentation says, "All larg
ora2pg tool can be used to accomplish the migration from oracle to postgresql.
download it from here...
http://freshmeat.net/projects/ora2pg/
The one in contib directory is an old version i guess.
About clob, blob, and long columns in Oracle all become 'text' in postgresql.
On 12/28/05
Hi, With this i enclosed my requirement. Along with this i would like to know your suggestion and the way to impliment the same as a service. Please note that i am using PGSQL 8.0 no-installer in Windows. One of the member had came up with the suggestion that it is related to Windows impersonal
Tom Lane,
I have read the email you mailed me. And I have SELinux enabled in permissive mode and the testlibpq program can run. I am very happy. In the future, I will use the PostgreSQL and give up the MySQL and other databases. I think the PostgreSQL is better than the others.
Thank you ve
Tom Lane,
I have read the email you mailed me yesterday. And I
have SELinux enabled in permissive mode and the
testlibpq program can run. I am very happy. In the
future, I will use the PostgreSQL and give up the
MySQL and other databases. I think the PostgreSQL is
better than the others.
Thank
Hi, I had tried to implement the no-installer version of PGSQL8.0. Could you please send me the documentation/useful links that helps me to impliment PostgreSQL8.0 no-installer package. I would like to know whether Postgre SQL8.0 no-installer version can be implimented as a service or not. If p
> Hi.
>
> I have exported few files into my DB server running on LINUX os.
> I connected to it remotely from windows and through one sample application
> like webserver i am trying to read the contents of it when ever there is a
> request for the specified file.Using the below example code.
>
On Wed, Dec 28, 2005 at 04:40:02PM +0530, sandhya wrote:
> I have exported few files into my DB server running on LINUX os.
> I connected to it remotely from windows and through one sample application
> like webserver i am trying to read the contents of it when ever there is a
> request for the spe
On Tue, Dec 27, 2005 at 11:48:55 +0200,
Tsirkin Evgeny <[EMAIL PROTECTED]> wrote:
>
> Hi list!
> My issue is as follows :
> I have to do some calculations based on *exact* number of rows in 2
> tables (with a filter) meaning:
> SELECT count(*) FROM a WHERE a.row1 in (1,2,3,4);
> SELECT count(*
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> But in our 7.4.x, there is code like this:
> sync();
> if (IsUnderPostmaster)
> sleep(2);
> sync();
I'm not claiming that that code is correct; it is in fact just as broken
as the traditional custom. You'll notice we don't have it anymore ;-)
>
"Tom Lane" <[EMAIL PROTECTED]> wrote
>
> The actual runtime of the "sync" program is epsilon, because it doesn't
> wait for all the I/O to happen. The entire reason for the custom is
> that the I/O is going on while you type the second "sync".
But in our 7.4.x, there is code like this:
sync();
On Wednesday 28 December 2005 16:22, Tom Lane wrote:
> Gary Stainburn <[EMAIL PROTECTED]> writes:
> > goole=# show lc_ctype;
> > lc_ctype
> > -
> > en_US.UTF-8
> > (1 row)
> >
> > goole=# show server_encoding;
> > server_encoding
> > -
> > UNICODE
> > (1 row)
>
> Hm
As I browse through the contrib directory I find an Oracle directory with
example perl scripts to do just as your asking.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bradley Kieser
Sent: Wednesday, December 28, 2005 10:12 AM
To: Murugan G
Cc: pgsql-a
Gary Stainburn <[EMAIL PROTECTED]> writes:
> goole=# show lc_ctype;
> lc_ctype
> -
> en_US.UTF-8
> (1 row)
> goole=# show server_encoding;
> server_encoding
> -
> UNICODE
> (1 row)
Hm. Well, the error message implies that there's some data in the
database that we
On Wednesday 28 December 2005 15:58, Tom Lane wrote:
> Gary Stainburn <[EMAIL PROTECTED]> writes:
> > ERROR: invalid multibyte character for locale
> > HINT: The server's LC_CTYPE locale is probably incompatible with the
> > database encoding.
>
> The HINT seems straightforward enough to me ;-).
(The announce list is for announcements, not for regular posts. Removing
it again)
Ah, then I see. You use "pg_ctl register" to register a service once the
binaries are copied in. You can copy them using any tool of your choice.
//Magnus
> -Original Message-
> From: [EMAIL PROTECTED]
>
Gary Stainburn <[EMAIL PROTECTED]> writes:
> ERROR: invalid multibyte character for locale
> HINT: The server's LC_CTYPE locale is probably incompatible with the
> database encoding.
The HINT seems straightforward enough to me ;-). What do "show
lc_ctype" and "show server_encoding" say?
On 12/28/05, Jason Minion <[EMAIL PROTECTED]> wrote:
And last but not least, you can do simple day addition and subtractionwith dates using integers. For example:> select '2005-12-26'::date + 8;returns '2006-01-03'. However, I'm not sure if that will work with
7.3.x. Good luck with your 8.x install
Yes.
But Oracle is completely useless at dumping data. You may want to use
the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to
connect both to Oracle and PG.
PLSQL developer is also able to do a connection to both but is
commercial software.
Alternatively, if you are reall
Instead of:
interval "numDays day"
use:
(numDays * (interval '1 day'))
Also, note that in your "select to_char" you have misspelled (sp?)
interval as "inteval".
And last but not least, you can do simple day addition and subtraction
with dates using integers. For example:
> select '2
Hi, Is there any option to install the PGSQL8.1.1 database as a service without using installation application (postgresql-8.1.msi) on windows. If yes what are the steps to follow. FazilMagnus Hagander <[EMAIL PROTECTED]> wrote: > Hi,> > Plz help me to install client only installation as a
Hi folks.
I've just FUBAR'd one of my databases so I dropped it and and then recreated
it from a pg_dump taken at 1am today.
Everything went fine with no errors or warning while recreating everything,
but now one of my selects doesn't work. A quick google and scan of the
postgresql hasn't hel
I need some help. I am trying to get a very simple function
written to help our developers. Unfortunetly, the language we are
developing in is giving us some grief over trying to do a "select
to_char((current_date - inteval '1 day'),'mmdd') into x". It
is complaining about the use of the wor
Title: migrating oracle table to PostgresQL
Hello,
I have some tables containing clob, blob, and long columns in Oracle, Is it possible to migrate these tables into PostgresQL along with data
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
> Hi,
>
> Plz help me to install client only installation as a service
> on windows. I am able to start the database with the client
> only installation package in Win 2k,XP & NT. But only after
> logging as a different user. Please provide me a solution for
> this and to start it as a servi
On 12/27/05, Aftab Alam <[EMAIL PROTECTED]> wrote:
> Hi Michael,
>
> thanks for your reply.
>
> you have mention that i can use plperlu, pltclu, or
> plpython for sending mail, i am using windows version of postgres(7.3.1),
>
on cygwin i guess... so you have to get a version of one of those
langu
Hi.
I have exported few files into my DB server running on LINUX os.
I connected to it remotely from windows and through one sample application
like webserver i am trying to read the contents of it when ever there is a
request for the specified file.Using the below example code.
Is this corr
Hi, Plz help me to install client only installation as a service on windows. I am able to start the database with the client only installation package in Win 2k,XP & NT. But only after logging as a different user. Please provide me a solution for this and to start it as a service on the client
They are not, no.
Murugan G wrote:
Hello,
Can I know whether Oracle's Standby database & RAC concepts available
in PostgresQL
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
===
Sobha Renaissance Inform
29 matches
Mail list logo
