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? And Postgres9.0 from community has a limitation for procedures? I actually changed the stored procedure to Function and now I can get the desired result from psql, pgadmin and ASP consistently. 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 server on enterpriseDB version As EXEC proc. Please let me know your thoughts so that I can understand the difference between the versions. Thanks, Mamatha -----Original Message----- From: Craig Ringer [mailto:ringerc@xxxxxxxxxxxxx] Sent: Wednesday, December 07, 2011 3:37 PM To: Chan, Mamatha Kagathi Cc: haramrae@xxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [pgadmin-support] Help for Migration On 12/07/2011 05:44 PM, Mamatha_Kagathi_Chan@xxxxxxxx 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 PostgreSQL: $ psql regress psql (9.1.1) Type "help" for help. regress=> select version(); version ------------------------------------------------------------------------------------------------------------- PostgreSQL 9.1.1 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.6.1 20110824 (Red Hat 4.6.1-8), 64-bit (1 row) regress=> CREATE OR REPLACE PROCEDURE test () RETURNS void AS $$ regress$> BEGIN regress$> RETURN; regress$> END; regress$> $$ LANGUAGE 'plpgsql'; ERROR: syntax error at or near "PROCEDURE" LINE 1: CREATE OR REPLACE PROCEDURE test () RETURNS void AS $$ ^ > I can actually use EXEC in psql which seem to be throwing some error in Craig's case. That's because it seems you're not actually using PostgreSQL. You need to contact EnterpriseDB technical support for assistance if you are using EnterpriseDB. If it's another product, please specify. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
