Re: [GENERAL] [pgadmin-support] Help for Migration

Hi Craig, The procedure definition is CREATE OR REPLACE PROCEDURE employeedetailinsert(dellbadgeid character varying DEFAULT NULL::character varying, empid character varying DEFAULT NULL::character varying, firstname character varying DEFAULT NULL::character varying, lastname character

Re: [GENERAL] [pgadmin-support] Help for Migration

I am using postgres 9.0.4 . I can actually use EXEC in psql which seem to be throwing some error in Craig's case. Also I am able to create procedure and execute them in pgadmin and psql. This piece of code was migrated from Oracle database (MS-SQL to Oracle then Oracle to Postgres).

Re: [GENERAL] [pgadmin-support] Help for Migration

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

Re: [GENERAL] [pgadmin-support] Help for Migration

Thanks everybody for helping me understand how postgres works with stored programs. I will remember in future to put certain information clearly as mentioned in the website suggested by Craig. Thanks for that as well. From: Craig Ringer [mailto:ring...@ringerc.id.au] Sent: Wednesday, December

Re: [GENERAL] [pgadmin-support] Help for Migration

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. But When I call the procedure in Classic ASP I get the below

[GENERAL] pg_dump error

Hi, I am using PostgreSQL 9.0. It is installed on Windows XP. I am trying to take a backup of the database using pg_dump. But each time I give a command Pg_dump pgdb backup.sql I am prompted for a password and I provided the database password. After this, I got an error as follows..

Re: [GENERAL] [pgadmin-support] Help for Migration

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:

Re: [GENERAL] psqlODBC connection

Thanks Ray and Edson, I was able to finally connect. And the ODBCAD32.exe for 32 as well as 64 bit compatible was present in SYSWOW64 folder. This ODBCAD32.exe contained the PostgreSQL driver in DNS window. Thanks for all the inputs which helped me to figure out the driver and connection

[GENERAL] psqlODBC connection

Hi, I have installed psqlODBC and I can see the dll files in the bin folder. But what shall I do next to connect My ASP page? Please help. Thanks, Mamatha

Re: [GENERAL] psqlODBC connection

Hi Ray, Thanks for the help. Since I am using classic ASP this is exactly what I am looking for. But there is a problem here. When I go the Create New Data Source window as mentioned in step ii, Ifind only sql server and Oracle drivers. I do not see PostgreSQL ODBC driver. But I am sure

[GENERAL] Steps to use pl/pgtcl

Hi, If I am planning to use the procedures/packages present in an sql server in postgresql, can I do it by using pl/pgtcl feature of postgresql? If yes, What shall be my initial and major steps. I am new to postgresql , kindly help me. Thanks, Mamatha

Re: [GENERAL] [pgadmin-support] Help for Migration

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