bug in tutorial docs
Just in case no one else has found it, in the tutorial docs on page
file:/usr/share/doc/packages/postgresql/html/tutorial-fk.html says:
CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);
<<<
and talks about the foreign key insert error. But that did not work when I
tried it. I believe the doc should say:
CREATE TABLE weather (
city varchar(80) references cities,
temp_lo int,
temp_hi int,
prcp real,
date date
);
<<<
The difference is the table referenced, cities not weather. That does allow
the example to work.
HTH,
Kevin Brannen
Yes, this has already been corrected. Thanks.
---------------------------------------------------------------------------
kbrannen@gte.net wrote:
Just in case no one else has found it, in the tutorial docs on page
file:/usr/share/doc/packages/postgresql/html/tutorial-fk.html says:CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);
<<<and talks about the foreign key insert error. But that did not work when I
tried it. I believe the doc should say:CREATE TABLE weather (
city varchar(80) references cities,
temp_lo int,
temp_hi int,
prcp real,
date date
);
<<<The difference is the table referenced, cities not weather. That does allow
the example to work.HTH,
Kevin Brannen---------------------------(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
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026