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 : [EMAIL PROTECTED] tél : 01 69 29 36 18 ---------------------------------------------------------------------------- --------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Craig Bryden Sent: vendredi 7 janvier 2005 11:04 To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> >To: Craig Bryden <[EMAIL PROTECTED]> >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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster