Received: from hostbank.net (root@[210.124.35.3]) by hub.org (8.9.2/8.9.1) with ESMTP id VAA94328 for ; Sun, 7 Mar 1999 21:23:30 -0500 (EST) (envelope-from randy@hostbank.net) Received: from ns (koreamap [210.124.35.2]) by hostbank.net (8.9.3/8.9.3/Debian/GNU) with SMTP id LAA02611 for ; Mon, 8 Mar 1999 11:29:31 +0900 Message-ID: <000101be690a$e53aad90$02237cd2@ns.hostbank.net> From: "Weon-sun Lee" To: "[LIST] PostgreSQL-SQL" Subject: Help: insert inheritance class Date: Mon, 8 Mar 1999 11:25:12 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="euc-kr" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Hi there, I'm create two classes. I'm sucess insert data into super class. I want know how do I insert inherits class. Thanx. First class CREATE SEQUENCE auth_user_rowid; CREATE TABLE auth_user ( "_rowid" int4, "uid" text, "username" text, "password" text, "perms" text ); INSERT INTO "auth_user" VALUES(nextval('auth_user_rowid'), 'aciefd90453092jfdaks','1022','Members'); this query is sucess.... CREATE TABLE members ( "stat" text, "address" text, "telephone" text, "pcsphone" text, "homepage" text, "email" text, "comment" text, "changed" text) INHERITS( auth_user ); How do I insert data to members table ?