system tables - Mailing list pgsql-hackers

From Timothy H. Keitt
Subject system tables
Date
Msg-id 396B8797.8499C330@nceas.ucsb.edu
Whole thread Raw
List pgsql-hackers
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit
 

test=# create table pg_test (x int);
ERROR:  Illegal class name 'pg_test'The 'pg_' name prefix is reserved for system catalogs
test=# 

Yuck! :-)

Perhaps a new relkind could be added to pg_class; say "R" for system
tables?

T.

-- 
Timothy H. Keitt
National Center for Ecological Analysis and Synthesis
735 State Street, Suite 300, Santa Barbara, CA 93101
Phone: 805-892-2519, FAX: 805-892-2510
http://www.nceas.ucsb.edu/~keitt/


pgsql-hackers by date:

Previous
From: "Stephan Szabo"
Date:
Subject: Re: Foreign key bugs + other problems
Next
From: Tom Lane
Date:
Subject: Re: Templates