Re: blatantly a bug in the documentation

On Tue, Nov 25, 2008 at 8:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Dave Page" <dpage@pgadmin.org> 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 also have to assume that all the examples are non-destructive,
> and that no one ever extends an example in a destructive way.  This
> seems like a non-starter.  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

There's good precedent for that...SQL Server for example does something similar:
http://msdn.microsoft.com/en-us/library/aa276825(SQL.80).aspx

It's a good learning tool and would really raise the value of the documentation.

merlin