Re: Be more clear what names can be used for tables with "CREATE TABLE"? - Mailing list pgsql-docs

From Daniel Westermann (DWE)
Subject Re: Be more clear what names can be used for tables with "CREATE TABLE"?
Date
Msg-id ZR0P278MB09206B60820D51D555F82892D2899@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Be more clear what names can be used for tables with "CREATE TABLE"?  (Jürgen Purtz <juergen@purtz.de>)
List pgsql-docs
>a) Don't forget: constraint, function, procedure, trigger.

Functions don't count:

postgres=# create function f() returns int as $$ select 1; $$ language sql;
CREATE FUNCTION
postgres=# create table f ( a int );
CREATE TABLE

Procedures and constraints don't count:
postgres=# create procedure p() as $$ declare a int; begin a = 1; end; $$ language plpgsql;
CREATE PROCEDURE
postgres=# create table p ( a int );
CREATE TABLE
postgres=# alter table p add constraint c check ( a > 1 );
ALTER TABLE
postgres=# create table c ( a int );
CREATE TABLE

>b) The hint applies to each of such objects: CREATE [TABLE|VIEW|FUNCTION|...]. To avoid such redundancy we could
extendand clarify the definition of 'SQL object / local object / global object' within the glossary and refer to it. 

+1

Regards
Daniel




pgsql-docs by date:

Previous
From: Jürgen Purtz
Date:
Subject: Re: Be more clear what names can be used for tables with "CREATE TABLE"?
Next
From: Laurenz Albe
Date:
Subject: Re: Be more clear what names can be used for tables with "CREATE TABLE"?