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.
On 7 December 2011 10:08, mamatha_kagathi_c...@dell.com 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
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 PROCEDURE
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.
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 the
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 community)
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...@dell.com wrote:
Hi Alban/Craig
; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [pgadmin-support] Help for Migration
On 7 December 2011 10:08, mamatha_kagathi_c...@dell.com 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
-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 the output
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.commailto:mamatha_kagathi_c...@dell.com wrote:
HI Craig,
Yes I am using EnterpriseDB
, October 25, 2011 8:30 AM
To: Alban Hertroys
Cc: Chan, Mamatha Kagathi; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [pgadmin-support] Help for Migration
On 25/10/11 03:36, Alban Hertroys wrote:
On 24 Oct 2011, at 14:24, mamatha_kagathi_c...@dell.com wrote:
Hi ,
I have migrated Sql Server
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:
On 24 Oct 2011, at 14:24, mamatha_kagathi_c...@dell.com 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
On 25/10/11 03:36, Alban Hertroys wrote:
On 24 Oct 2011, at 14:24, mamatha_kagathi_c...@dell.com 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
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
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
16 matches
Mail list logo