Re: [GENERAL] Moving data directory from one server to another

2010-03-28 Thread Ehsan Haq
). Please let me know.   Thanks Ehsan --- On Mon, 3/29/10, Yar Tykhiy wrote: From: Yar Tykhiy Subject: Re: [GENERAL] Moving data directory from one server to another To: "Ehsan Haq" Date: Monday, March 29, 2010, 1:01 AM Hi Ehsan, On Fri, Mar 26, 2010 at 11:25:56AM -0700, Ehsan Haq w

[GENERAL] Moving data directory from one server to another

2010-03-26 Thread Ehsan Haq
Hi,    I have two Linux servers both having same Hardware architecture one have ES5 and the other having ES4. Both the servers have same version of PostGres installed (8.3). I want to move all my DBs from ES5 server to ES4 server. I have tried the pg_dump but there are a lot of encoding problems

[GENERAL] definitions of regexp functions required

2010-03-18 Thread Ehsan Haq
Hi,    I am using a relatively older version of Postgres and I need to use the following functions. regexp_matches(), regexp_split_to_array(), and regexp_split_to_table() . Can anybody provide me the definitions of these functions.   Thanks in advance Ehsan

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-12 Thread Ehsan Haq
N 1" and not "This is Out String". Thanks Ehsan --- On Sat, 9/12/09, Merlin Moncure wrote: From: Merlin Moncure Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq To: "Ehsan Haq" Cc: pgsql-general@postgresql.org Date: Saturday, September 12

Re: [GENERAL] Getting Out Parameter in the application using libpq

2009-09-11 Thread Ehsan Haq
re Subject: Re: [GENERAL] Getting Out Parameter in the application using libpq To: "Ehsan Haq" Cc: pgsql-general@postgresql.org Date: Friday, September 11, 2009, 12:08 PM On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq wrote: > > Hi, >    I am looking for a way to get the OUT parameters o

[GENERAL] Getting Out Parameter in the application using libpq

2009-09-10 Thread Ehsan Haq
Hi,    I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE in my application (C++) using C libpq library. I can get the result set of an OUT parameter having REFCURSOR data type through an explicit FETCH ALL from "" but for OUT parameter of type integer/varchar I dont ha