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 ar
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 futu
-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
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=#
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 is
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 documentati
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 documentati
"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 wo
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 control
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
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
> instal
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
> 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.
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 lea
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 cont
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 cl
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
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 i
"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.
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?
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 cl
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 mak
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
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
> datab
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, so
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 examp
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.
Perhap
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
> > http://www.postgresql.org/docs/curre
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, cs_re
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, cs_refresh_mviews(), chapter 38.6.4.
Within this function there are a "PERFORM cs_log('Ref
30 matches
Mail list logo
