From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
---|---|
To: | Jürgen Purtz <juergen(at)purtz(dot)de>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Be more clear what names can be used for tables with "CREATE TABLE"? |
Date: | 2021-10-31 19:48:15 |
Message-ID: | ZR0P278MB09206B60820D51D555F82892D2899@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 extend and clarify the definition of 'SQL object / local object / global object' within the glossary and refer to it.
+1
Regards
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2021-11-01 04:39:43 | Re: Be more clear what names can be used for tables with "CREATE TABLE"? |
Previous Message | Jürgen Purtz | 2021-10-30 15:27:02 | Re: Be more clear what names can be used for tables with "CREATE TABLE"? |