Help: insert inheritance class

From: "Weon-sun Lee" <randy(at)hostbank(dot)net>
To: "[LIST] PostgreSQL-SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Help: insert inheritance class
Date: 1999-03-08 02:25:12
Message-ID: 000101be690a$e53aad90$02237cd2@ns.hostbank.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 ?

Browse pgsql-sql by date

  From Date Subject
Next Message Remigiusz Sokolowski 1999-03-08 07:29:45 Re: [SQL] rules
Previous Message Manuel Lemos 1999-03-08 01:28:59 PostgreSQL EndTransactionBlock and not inprogress/abort state