This isn't all my problem... I was going through tutorials, and I typed in the example for inheritance. I had a typo that did not throw an error and I think it should.
i created the tables from the cities, capitals example and then tried to insert. test-db=# insert into capitals (name, population, state) values ('Trenton', '543565, 'New Jersey'); my typo is the extra single quote before the number. I received no error message, but of course there was no insert. I would have assumed that the trailing ';' would have terminated the insert and if there is an error, it should have said so. i am on mac osx 10.2.4 with PostgreSQL 7.3.2 on powerpc-apple-darwin6.4, compiled by GCC gcc (GCC) 3.1 20020420 (prerelease) Ted __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster