Re: [HACKERS] blatantly a bug in the documentation

2008-11-27 Thread Simon Riggs
On Tue, 2008-11-25 at 08:23 -0500, Tom Lane wrote: Dave Page [EMAIL PROTECTED] writes: I'm in favour of including it by default (at initdb), so it's there for new users to play with on any fresh install - however, there is only a point to that if all the documentation examples are based on

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Dave Page
On Tue, Nov 25, 2008 at 1:42 AM, Robert Treat [EMAIL PROTECTED] wrote: We actually have such a database on pgfoundry already (http://pgfoundry.org/frs/download.php/1719/pagila-0.10.1.zip), which i think devrim may have packaged into an rpm; it wouldn't hurt to add it to the win32 installer,

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Stephen R. van den Berg
Dave Page wrote: On Tue, Nov 25, 2008 at 1:42 AM, Robert Treat [EMAIL PROTECTED] wrote: We actually have such a database on pgfoundry already (http://pgfoundry.org/frs/download.php/1719/pagila-0.10.1.zip), which i think devrim may have packaged into an rpm; it wouldn't hurt to add it to the

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Brendan Jurd
On Tue, Nov 25, 2008 at 7:31 PM, Dave Page [EMAIL PROTECTED] wrote: I'm in favour of including it by default (at initdb), so it's there for new users to play with on any fresh install ... Could we perhaps punt on the issue of whether to install the sampledb by default. It could be controlled

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Tom Lane
Dave Page [EMAIL PROTECTED] writes: I'm in favour of including it by default (at initdb), so it's there for new users to play with on any fresh install - however, there is only a point to that if all the documentation examples are based on that database to allow copy-paste-play. You would

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Dave Page
On Tue, Nov 25, 2008 at 1:23 PM, Tom Lane [EMAIL PROTECTED] wrote: Dave Page [EMAIL PROTECTED] writes: I'm in favour of including it by default (at initdb), so it's there for new users to play with on any fresh install - however, there is only a point to that if all the documentation examples

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Merlin Moncure
On Tue, Nov 25, 2008 at 8:23 AM, Tom Lane [EMAIL PROTECTED] wrote: Dave Page [EMAIL PROTECTED] writes: I'm in favour of including it by default (at initdb), so it's there for new users to play with on any fresh install - however, there is only a point to that if all the documentation examples

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Andrew Dunstan
Tom Lane wrote: Better to provide the sample database in a form in which it can be easily dropped/reloaded. I'm envisioning that there's a source file in $sharedir and we tell people createdb example psql -f $sharedir/example.sql example This

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Ron Mayer
Stephen R. van den Berg wrote: ... it would be orders of magnitude more difficult for a novice to create the sample database from contrib or anywhere else. It seems to me that *this* is the more serious problem that we should fix instead. If, from the psql command prompt I could type: psql=#

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Dimitri Fontaine
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le 25 nov. 08 à 20:29, Ron Mayer a écrit : psql=# install module sampledb; Downloading sampledb from pgfoundry... Installing sampledb Connecting to sampledb sampledb=# This could be part of an installer for PostgreSQL extensions. See

Re: [HACKERS] blatantly a bug in the documentation

2008-11-25 Thread Tom Lane
Dimitri Fontaine [EMAIL PROTECTED] writes: What do you dear readers think about the extension vocabulary? +1 ... we should stay away from package unless we are going to implement an Oracle-compatible facility. Which I don't particularly wish to do, but we should leave it open for the future.

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Merlin Moncure
On Mon, Nov 24, 2008 at 6:02 AM, A. Kretschmer [EMAIL PROTECTED] wrote: I hope this is the right place to report a bug/issue in the official documentation... In http://www.postgresql.org/docs/current/interactive/plpgsql-control-structures.html there is an example for a function,

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread A. Kretschmer
am Mon, dem 24.11.2008, um 7:24:47 -0500 mailte Merlin Moncure folgendes: On Mon, Nov 24, 2008 at 6:02 AM, A. Kretschmer [EMAIL PROTECTED] wrote: I hope this is the right place to report a bug/issue in the official documentation... In

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Alvaro Herrera
A. Kretschmer wrote: Okay, it is an argument. On the other side, it was a question today in the irc-channel (#postgresql) today, someone asked, why his funktion don't work. I think, such examples should not contain such code. It is not apparent that this function are not available. Perhaps

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Andrew Dunstan
Dave Page wrote: On Mon, Nov 24, 2008 at 1:38 PM, Alvaro Herrera [EMAIL PROTECTED] wrote: A. Kretschmer wrote: Okay, it is an argument. On the other side, it was a question today in the irc-channel (#postgresql) today, someone asked, why his funktion don't work. I think, such

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread A. Kretschmer
am Mon, dem 24.11.2008, um 13:47:54 + mailte Dave Page folgendes: On Mon, Nov 24, 2008 at 1:38 PM, Alvaro Herrera [EMAIL PROTECTED] wrote: A. Kretschmer wrote: Okay, it is an argument. On the other side, it was a question today in the irc-channel (#postgresql) today, someone asked,

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Dave Page
On Mon, Nov 24, 2008 at 1:53 PM, Andrew Dunstan [EMAIL PROTECTED] wrote: It might also be useful to create such a database at initdb time so newbies have something interesting to look at right away. No, there is no need to clutter every installation in the world with such a database. You

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Magnus Hagander
Dave Page wrote: On Mon, Nov 24, 2008 at 1:53 PM, Andrew Dunstan [EMAIL PROTECTED] wrote: It might also be useful to create such a database at initdb time so newbies have something interesting to look at right away. No, there is no need to clutter every installation in the world with such a

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Dave Page wrote: It might also be useful to create such a database at initdb time so newbies have something interesting to look at right away. No, there is no need to clutter every installation in the world with such a database. You could make it an

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Dave Page
On Mon, Nov 24, 2008 at 2:02 PM, Tom Lane [EMAIL PROTECTED] wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Dave Page wrote: It might also be useful to create such a database at initdb time so newbies have something interesting to look at right away. No, there is no need to clutter every

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Dave Page
On Mon, Nov 24, 2008 at 2:01 PM, Magnus Hagander [EMAIL PROTECTED] wrote: Dave Page wrote: That would defeat the point. Not that I have any great feelings either way, but fwiw, Microsoft and Oracle both create a sample database iirc. Last I checked, MS did it optionally only, no? Yes, but

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Tom Lane
Dave Page [EMAIL PROTECTED] writes: On Mon, Nov 24, 2008 at 1:53 PM, Andrew Dunstan [EMAIL PROTECTED] wrote: No, there is no need to clutter every installation in the world with such a database. You could make it an addon module, or a pgfoundry project. That would defeat the point. By that

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Dave Page
On Mon, Nov 24, 2008 at 2:14 PM, Tom Lane [EMAIL PROTECTED] wrote: Dave Page [EMAIL PROTECTED] writes: On Mon, Nov 24, 2008 at 1:53 PM, Andrew Dunstan [EMAIL PROTECTED] wrote: No, there is no need to clutter every installation in the world with such a database. You could make it an addon

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread A. Kretschmer
am Mon, dem 24.11.2008, um 9:02:37 -0500 mailte Tom Lane folgendes: Andrew Dunstan [EMAIL PROTECTED] writes: Dave Page wrote: It might also be useful to create such a database at initdb time so newbies have something interesting to look at right away. No, there is no need to clutter

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Merlin Moncure
On Mon, Nov 24, 2008 at 9:02 AM, Tom Lane [EMAIL PROTECTED] wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Dave Page wrote: It might also be useful to create such a database at initdb time so newbies have something interesting to look at right away. No, there is no need to clutter every

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Dave Page
On Mon, Nov 24, 2008 at 1:38 PM, Alvaro Herrera [EMAIL PROTECTED] wrote: A. Kretschmer wrote: Okay, it is an argument. On the other side, it was a question today in the irc-channel (#postgresql) today, someone asked, why his funktion don't work. I think, such examples should not contain such

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Peter Eisentraut
On Monday 24 November 2008 16:07:49 Dave Page wrote: That's the point of having a sample database ready to play with. The docs needn't have clutter, but the user can try out any of the examples without needing to setup anything first. It's a simple usability tweak that can help ease the

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Robert Haas
Clutter is the problem. The cs_log functions in the example do not serve any purpose that is helpful to describe a for loop. They serve no real purpose...why not 'raise notice' or just remove them? It should be clear to distinguish from real and non-real elements. +1 for RAISE NOTICE.

Re: [HACKERS] blatantly a bug in the documentation

2008-11-24 Thread Robert Treat
On Monday 24 November 2008 09:10:29 Dave Page wrote: On Mon, Nov 24, 2008 at 2:01 PM, Magnus Hagander [EMAIL PROTECTED] wrote: Dave Page wrote: That would defeat the point. Not that I have any great feelings either way, but fwiw, Microsoft and Oracle both create a sample database iirc.