Обсуждение: 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

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

-----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.