Received: from front1.netvisao.pt ([213.228.128.56]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0DLqFB67399 for ; Sun, 13 Jan 2002 16:52:15 -0500 (EST) (envelope-from pocm@rnl.ist.utl.pt) Received: (qmail 18818 invoked from network); 13 Jan 2002 21:51:18 -0000 Received: from unknown (HELO localhost.localdomain) (217.129.243.231) by front1.netvisao.pt with SMTP; 13 Jan 2002 21:51:18 -0000 To: pgsql-sql@postgresql.org Subject: pg with different sql? From: pocm@rnl.ist.utl.pt (Paulo J. Matos) Date: 13 Jan 2002 22:04:16 +0000 Message-ID: <87y9j1j4bj.fsf@localhost.localdomain> Lines: 43 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200201/113 X-Sequence-Number: 6202 Hi all, I'm new to postgres and I'm doing a database project for a subject at college in postgres. I've studied databases using DataBases Management Systems by Ramakrishnan. I've done some create tables and at psql interactive prompt I've done: \i proj.sql (where proj.sql is the filename with the CREATE TABLEs) AFAIK, SQL is standard and should be the same for all DBMSs. For example: CREATE TABLE socio ( id integer SERIAL PRIMARY KEY, nome varchar, alcunha string, data_filiacao date) CREATE TABLE paga_cota ( ano integer, mes integer, valor integer, id integer, PRIMARY KEY(id,ano,mes), FOREIGN KEY(id) REFERENCES(socio)) After this I get an error around CREATE (of the 2nd table). I just can't imagine what it might be. I'd appreciate your help. TIA, My best regards, -- Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt Instituto Superior Tecnico - Lisbon Software & Computer Engineering - A.I. - > http://www.rnl.ist.utl.pt/~pocm --- Yes, God had a deadline... So, He wrote it all in Lisp!