Postgres Pro
Downloads
Home   >   mailing lists

Thread: Need some urgent help.

Need some urgent help.

From
"Naveen Kaul"
Date:
Hi there,
 
We plan to use PgAdmin tool for connecting to the ProsgreSQL. Our problem is that we have our development environment set in MS SQL 7/2000. We migrated the tables and database structure successfully, but are not in a position to migrate the Stored Procs.
 
How can this be done?  We are working on deadline and would appreciate your help.
 
 
Thanks,
 
Naveen
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/2002

Re: Need some urgent help.

From
Dave Page
Date:
Hi,
 
Stored procedures must be ported manually into the procedural language of your choice. You can use pgAdmin to make this easier than typing SQL directly into a shell, but you will still have to do the hard part I'm afraid.
 
Regards, Dave.
 
-----Original Message-----
From: Naveen Kaul [mailto:naveenk@systelinc.com]
Sent: 12 April 2002 12:27
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Need some urgent help.

Hi there,
 
We plan to use PgAdmin tool for connecting to the ProsgreSQL. Our problem is that we have our development environment set in MS SQL 7/2000. We migrated the tables and database structure successfully, but are not in a position to migrate the Stored Procs.
 
How can this be done?  We are working on deadline and would appreciate your help.
 
 
Thanks,
 
Naveen
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/2002

Re: Need some urgent help.

From
Jean-Michel POURE
Date:
Le Vendredi 12 Avril 2002 13:27, vous avez écrit :
> How can this be done?  We are working on deadline and would appreciate your
> help.

PostgreSQL offers several server-side languages including plpgsql, plperl,
plpython, etc... IMHO, the easiert language to learn is plpgsql. Information
can be found on http://www.postgresql.org/idocs/index.php?plpgsql.html.

Use createlang as explained in
http://www.postgresql.org/idocs/index.php?app-createlang.html to enable
plpgsql.

pgAdmin2 is the perfect tool for writing plpgsql server-side scripts.

Have fun,
Jean-Michel

Re: Need some urgent help.

From
"Naveen Kaul"
Date:
Hi Dave,
 
I have a problem with postgres. One of my table hold about 65,000 records. If I use the simple select * on this table, the pgadmin tool hangs and the postgres throws up the following exception.
 
"NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend
        died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am
        going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
        server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request."
 
I wonder what could be wrong. I increased the the buffer size from 256 to 512. Still the same thing.
 
Your help would be highly apperciated.
 
Thanks,
 
Naveen
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002

Re: Need some urgent help.

From
"Dave Page"
Date:
 
-----Original Message-----
From: Naveen Kaul [mailto:naveenk@systelinc.com]
Sent: 27 May 2002 11:10
To: Dave Page; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Need some urgent help.

Hi Dave,
 
I have a problem with postgres. One of my table hold about 65,000 records. If I use the simple select * on this table, the pgadmin tool hangs and the postgres throws up the following exception.
 
"NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend
        died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am
        going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
        server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request."
 
I wonder what could be wrong. I increased the the buffer size from 256 to 512. Still the same thing.
 
I don't know what would cause this (pgAdmin will load over 65535 records so it's not a 16 bit overflow at the client end), as you say though, the message is coming from PostgreSQL, not pgAdmin - perhaps someone on pgsql-general@postgresql.org may have some idea?
 
Sorry I can't be more help.
 
Regards, Dave.