Hi Craig,
2 years ago, I had to do some porting from MS SQL to Postgres.
All the application logic was coded in stored procedures...
The major problem I was faced to, was to port procedures returning multiple
result-sets...
Another problem was that there is no default value for stored procedures in
PostgreSQL, so you have to set all parameters and modify calling
applications to do so...
I have written some tips for porting but in French.
If you face to special problems, don't hesitate to ask for and if I perhaps
encountered the same problem...
Patrick
----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Craig Bryden
Sent: vendredi 7 janvier 2005 11:04
To: mike@fuhr.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer
Hi Michael
I am having some problems porting my Stored Procedures. I am using the
pl/pgsql language. Instead of irritating/spamming everyone on this mailing
list, I was hoping that there would be a comprehensive book that focusses on
how to do DB things in PostgreSQL, but that does not spend too much time
explaining RDBMS basics.
Thanks
Craig
>From: Michael Fuhr <mike@fuhr.org>
>To: Craig Bryden <brydencraig@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Books for experienced DB developer
>Date: Fri, 7 Jan 2005 02:58:29 -0700
>
>On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote:
>
> > I am a very experienced MS-SQL developer. I am looking to port a
>database
> > to PostgreSQL. Which books that are available would be ideal for someone
> > who is already an experienced DB developer?
>
>PostgreSQL has good documentation so I'd suggest starting there.
>If the documentation doesn't cover something you want to know then
>please provide more info about what you're looking for.
>
>--
>Michael Fuhr
>http://www.fuhr.org/~mfuhr/
_________________________________________________________________
Research SA schools and varsities on MSN Search. http://search.msn.co.za
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings