Books for experienced DB developer

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/

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

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

On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote:

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

At least, this isnt a problem anymore :-)

Regards
Tino

I'm afraid this is still a problem.

From my knowledge, Postgres function is able to return a single result-set

not multiple.
I may have missed some facility...

Regards,
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 Tino Wildenhain
Sent: vendredi 7 janvier 2005 11:45
To: Patrick FICHE
Cc: Craig Bryden; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer

On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote:

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

At least, this isnt a problem anymore :-)

Regards
Tino

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote:

I'm afraid this is still a problem.
From my knowledge, Postgres function is able to return a single result-set
not multiple.
I may have missed some facility...

<rtfm_please> see
http://techdocs.postgresql.org/guides/SetReturningFunctions
<rtfm_please> or
http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835

(fresh from freenode irc #postgresql channel)

Or is it not what you mean?

Regards
Tino

It has been able to do this for some time now... Take a look

33.4.4. SQL Functions Returning Sets

http://www.postgresql.org/docs/7.4/static/xfunc-sql.html

I'm afraid this is still a problem.
From my knowledge, Postgres function is able to return a single result-set
not multiple.
I may have missed some facility...

Regards,
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 Tino Wildenhain
Sent: vendredi 7 janvier 2005 11:45
To: Patrick FICHE
Cc: Craig Bryden; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Books for experienced DB developer

On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote:

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

At least, this isnt a problem anymore :-)

Regards
Tino

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

No, this is only one result-set.
MS SQL Server is able to return multiple result-set.

For example, one SQL Server function can return the result of the following
queries :
SELECT * FROM Table1
SELECT * FROM Table2
SELECT * FROM Table3

with Table1, Table2 and Table3 having different structures...

For example, you can navigate in the result-sets in ODBC using the
SQLMoreResults function...

That's probably not a very usual way of programming but we did it and
experienced problems for porting....

Regards,
Patrick

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------

-----Original Message-----
From: Tino Wildenhain [mailto:tino@wildenhain.de]
Sent: vendredi 7 janvier 2005 12:08
To: Patrick FICHE
Cc: Craig Bryden; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Books for experienced DB developer

On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote:

I'm afraid this is still a problem.
From my knowledge, Postgres function is able to return a single result-set
not multiple.
I may have missed some facility...

<rtfm_please> see
http://techdocs.postgresql.org/guides/SetReturningFunctions
<rtfm_please> or
http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835

(fresh from freenode irc #postgresql channel)

Or is it not what you mean?

Regards
Tino

On Fri, 2005-01-07 at 12:17 +0100, Patrick FICHE wrote:

No, this is only one result-set.
MS SQL Server is able to return multiple result-set.

For example, one SQL Server function can return the result of the following
queries :
SELECT * FROM Table1
SELECT * FROM Table2
SELECT * FROM Table3

with Table1, Table2 and Table3 having different structures...

For example, you can navigate in the result-sets in ODBC using the
SQLMoreResults function...

I wonder how this fits into the SQL standard by any way ;)
Nevertheless you should be able to return 3 cursors you
define in your stored function and use them afterwards.

Regards
Tino

Craig Bryden wrote:

Hi

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?

If you are experienced, I'd say you'd save yourself some cash and be
perfectly fine using the online docs. I'll assume you'll be on a wintel
arch, based on your experience. When you install Postgresql on a Linux
box, you get all the docs installed as well. I don't know about the
windows install.

--
Until later, Geoffrey

Craig Bryden wrote:

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.

Although I "really", "really" do appreciate what you say above these
lists are specifically for helping people with the problems they are having.
It is great that you are willing to read the docs first
(more people should) but as you an experienced developed I would assume
you are going to ask questions that make sense ;).

So please, feel free and take your best shot :)

On a general note it may be productive for you to look at the other
procedural languages as well.

Sincerely,

Joshua D. Drake

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

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Hi
I am new to PostgreSQL and interested in using PostgreSQL in our
application.
But I have questions regarding what our users have to do to install the
software.

I can not find documentation on how to deploy application which uses
PostgreSQL.

Or does the user have to run separate setup (beside our application's setup
program) to just install PostgreSQL as server?

Thanks.

Hong

Which OS are you planning to use? There are pre-built RPMs for Linux,
and pre-compiled binaries for Windows.

On Fri, 7 Jan 2005 06:31:35 -0800, Hong Ji <hj2004@hji.net> wrote:

Hi
I am new to PostgreSQL and interested in using PostgreSQL in our
application.
But I have questions regarding what our users have to do to install the
software.

I can not find documentation on how to deploy application which uses
PostgreSQL.

Or does the user have to run separate setup (beside our application's setup
program) to just install PostgreSQL as server?

Thanks.

Hong

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

I installed pgadminIII and really enjoy their built in documentation reader
for PostgreSQL. The documentation that came with pgadminIII had been
updated for the new version 8 features.

Rick

Geoffrey
<esoteric@3times25.net> To: pgsql-general@postgresql.org
Sent by: cc:
pgsql-general-owner@pos Subject: Re: [GENERAL] Books for experienced DB developer
tgresql.org

01/07/2005 08:58 AM

Craig Bryden wrote:

Hi

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?

If you are experienced, I'd say you'd save yourself some cash and be
perfectly fine using the online docs. I'll assume you'll be on a wintel
arch, based on your experience. When you install Postgresql on a Linux
box, you get all the docs installed as well. I don't know about the
windows install.

--
Until later, Geoffrey

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Fri, Jan 07, 2005 at 06:31:35AM -0800, Hong Ji wrote:

Hi
I am new to PostgreSQL and interested in using PostgreSQL in our
application.
But I have questions regarding what our users have to do to install the
software.

I can not find documentation on how to deploy application which uses
PostgreSQL.

Or does the user have to run separate setup (beside our application's setup
program) to just install PostgreSQL as server?

We bundle an installation of PostgreSQL in the same tarball as our
application (installed within our applications directory structure and
built to run on a different port by default, so that it doesn't clash
with a native postgresql, if any). As part of our install script we
run initdb, createuser etc., exactly as explained in the standard
postgresql install docs.

That works for us, as the application is usually running on a machine
that's mostly dedicated to it. More usually as a user I'd usually
prefer the option of using an already installed postgresql instance if
one were available.

Cheers,
Steve

On Fri, Jan 07, 2005 at 12:20:13PM +0100, Tino Wildenhain wrote:

Nevertheless you should be able to return 3 cursors you
define in your stored function and use them afterwards.

A function can also return SETOF RECORD. However, a query calling
such a function would need to provide a column definition list, so
the query must know in advance what record type the function will
return.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Tino,

Multiple recordsets means returning multiple setof results, not just one.
As an example in a SQL Server Stored Procedure you can have the following in
the same stored procedure:
create proc getdata as
select * from table1
select * from table2
go
and it will return 2 resultsets. This is not possible in postgresql today.

"Tino Wildenhain" <tino@wildenhain.de> wrote in message
news:1105096058.4978.62.camel@sabrina.peacock.de...

On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote:

I'm afraid this is still a problem.
From my knowledge, Postgres function is able to return a single

result-set