07, 2011 6:53 PM
To: Chan, Mamatha Kagathi
Cc: haram...@gmail.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [pgadmin-support] Help for Migration
On 12/07/2011 06:57 PM,
mamatha_kagathi_c...@dell.com<mailto:mamatha_kagathi_c...@dell.com> wrote:
HI Craig,
Yes I am using Enterp
-general@postgresql.org
Subject: Re: [GENERAL] [pgadmin-support] Help for Migration
On 12/07/2011 05:44 PM, mamatha_kagathi_c...@dell.com wrote:
> I am using postgres 9.0.4
I don't think you are, actually, I think you're using EnterpriseDB Postgres
Plus Advanced Server.
Please past
#x27;,'');
EDB-SPL Procedure successfully completed
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: Wednesday, December 07, 2011 2:56 PM
To: Chan, Mamatha Kagathi
Cc: ring...@ringerc.id.au; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [pgadmin-suppo
essage-
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: Wednesday, December 07, 2011 1:48 PM
To: Chan, Mamatha Kagathi
Cc: haram...@gmail.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [pgadmin-support] Help for Migration
On 12/07/2011 03:23 PM, mamatha_kagathi_c...@de
On Wed, 2011-12-07 at 14:30 +0100, Guillaume Lelarge wrote:
> On Wed, 2011-12-07 at 21:23 +0800, Craig Ringer wrote:
> > On 12/07/2011 06:57 PM, mamatha_kagathi_c...@dell.com wrote:
> > [...]
> > > I can also get the same result if I execute it in pgadmin (version
> > > downloaded from postgres co
On Wed, 2011-12-07 at 21:23 +0800, Craig Ringer wrote:
> On 12/07/2011 06:57 PM, mamatha_kagathi_c...@dell.com wrote:
> [...]
> > I can also get the same result if I execute it in pgadmin (version
> > downloaded from postgres community) which is on a different client machine
> > but connected to
On 12/07/2011 06:57 PM, mamatha_kagathi_c...@dell.com wrote:
HI Craig,
Yes I am using EnterpriseDB Postgres Plus Advanced Server.
But does that mean Postgres 9.0 version from Postgres community and Postgres9.0
version from EnterpriseDB works differently?
Yes! They're different things. Enterpris
On 12/07/2011 05:44 PM, mamatha_kagathi_c...@dell.com wrote:
I am using postgres 9.0.4
I don't think you are, actually, I think you're using EnterpriseDB
Postgres Plus Advanced Server.
Please past the output of the "SELECT version();" command.
Here's what happens if you try "CREATE PROCEDUR
On 7 December 2011 10:08, wrote:
> The procedure definition is
> CREATE OR REPLACE PROCEDURE
> -- So I am not calling a function but a procedure.
I don't think CREATE PROCEDURE is actually a valid command in
Postgres. The 9.0 documentation seems to confirm that
(http://www.postgresql.org/docs/9
On 12/07/2011 03:23 PM, mamatha_kagathi_c...@dell.com wrote:
Hi Alban/Craig,
Employeedetailinsert is procedure I have created in PostgreSQL. When I try to
execute the procedure directly in Pgadmin as
EXEC Employeedetailinsert (parameters same as below) It works fine with desired
result.
PgAdm
function matches the
given name and argument types. You might need to add explicit type casts.
/postgresql/EmployeeDetails.asp, line 656
-error end
Thanks,
Mamatha
-Original Message-
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: Tuesday, October 25, 2011 8:30 AM
To: Alban Her
On 25/10/11 03:36, Alban Hertroys wrote:
> On 24 Oct 2011, at 14:24, wrote:
>
>> Hi ,
>>
>> I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also
>> successfully able to connect classic ASP to the migrated database. But when
>> the page reaches a stage where it is accessing a
On 24 Oct 2011, at 14:24, wrote:
> Hi ,
>
> I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also
> successfully able to connect classic ASP to the migrated database. But when
> the page reaches a stage where it is accessing a procedure I get the
> following error.
>
> Post
Hi ,
I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also
successfully able to connect classic ASP to the migrated database. But when the
page reaches a stage where it is accessing a procedure I get the following
error.
PostgreSQL Native Provider error '80040e14'
ERROR: syn
On Tue, Sep 06, 2011 at 12:17:28PM +, mamatha_kagathi_c...@dell.com wrote:
> Hi,
>
> I am trying to migrate a very small MS SQL Server Database (with 200
> records max, 20 tables, 10 stored procedures) to PostgreSQL. I tried
> browsing through internet to find technical steps but I found some
Hi,
I am trying to migrate a very small MS SQL Server Database (with 200 records
max, 20 tables, 10 stored procedures) to PostgreSQL. I tried browsing through
internet to find technical steps but I found some blogs with vague discussion
for same. Kindly let me know where to look for the inform
16 matches
Mail list logo
