Re: Books for experienced DB developer
От | Patrick FICHE |
---|---|
Тема | Re: Books for experienced DB developer |
Дата | |
Msg-id | 1DC6C8C88D09D51181A40002A52869299A35FA@intranet обсуждение исходный текст |
Ответ на | Books for experienced DB developer ("Craig Bryden" <brydencraig@hotmail.com>) |
Ответы |
Re: Books for experienced DB developer
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: