Help: insert inheritance class - Mailing list pgsql-sql

From Weon-sun Lee
Subject Help: insert inheritance class
Date
Msg-id 000101be690a$e53aad90$02237cd2@ns.hostbank.net
Whole thread Raw
List 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 ?




pgsql-sql by date:

Previous
From: Zalman Stern
Date:
Subject: "typedef" in Pstgresql?
Next
From: "Manuel Lemos"
Date:
Subject: PostgreSQL EndTransactionBlock and not inprogress/abort state