Thread: Re: 'bug' in the postgresql tutorial

Re: 'bug' in the postgresql tutorial

From
Thomas Lockhart
Date:
> I sent a mail about a 'bug' in the last tutorial of  Postgresql. Sent it
> to pgsql-docs@postgresql.org and no one told me...

Hmm. Sorry, I didn't see the post.

> ...perhaps am I the first one who finds an error in the Chapter 3, (3.3
> Foreign Keys) in the new tutorial?
> ...........................................................
> CREATE TABLE cities (
> name varchar(80) primary key,
> location point
> );
>
> CREATE TABLE weather (
> city varchar(80) references weather,
> temp_lo int,
> temp_hi int,
> prcp real,
> date date
> );
> ........................................................................
> shouldn't it say 'references cities'? ;-)

Yes, I'll make the change. Thanks for letting us know.

> Distribution-explanation in new tutorial seems more practical than the
> others before. Congratulations!

Glad you found it better. It looks like Peter E did the improvements...

                  - Thomas

Re: 'bug' in the postgresql tutorial

From
Tom Lane
Date:
Thomas Lockhart <lockhart@fourpalms.org> writes:
>> I sent a mail about a 'bug' in the last tutorial of  Postgresql. Sent it
>> to pgsql-docs@postgresql.org and no one told me...

> Hmm. Sorry, I didn't see the post.

I think Bruce already applied the patch.

            regards, tom lane