Hi,
Section 3.3, tutorial-fk.html
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
);
You have written 'references weather' instead of 'references cities'.
---------------------------------------------------------------------
On postgreSQL 7.1.3:
Line 9 refers to 'advanced' instead of 'syscat' in syscat.py
1 >>> import syscat
2
3 __________________________________________________________________
4 MODULE SYSCAT.PY : PARSES SOME POSTGRESQL SYSTEM CATALOGS
5
6 This module is designed for being imported from python prompt
7
8 In order to run the samples included here, first create a connection
9 using : cnx = advanced.DB(...)
10
11 The "..." should be replaced with whatever arguments you need to open
an
12 existing database. Usually all you need is the name of the database
and,
13 in fact, if it is the same as your login name, you can leave it
empty.
14
15 then start the demo with: syscat.demo(cnx)
16
17 Some results may be empty, depending on your base status."
I find the same error in func
Bye
Stephane.
PS: PostgreSQL is great, thank you for your job !
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
