Re: Be more clear what names can be used for tables with "CREATE TABLE"?

Поиск
Список
Период
Сортировка
От Daniel Westermann (DWE)
Тема Re: Be more clear what names can be used for tables with "CREATE TABLE"?
Дата
Msg-id ZR0P278MB09206B60820D51D555F82892D2899@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Be more clear what names can be used for tables with "CREATE TABLE"?  (Jürgen Purtz <juergen@purtz.de>)
Список 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 по дате отправления:

Предыдущее
От: Jürgen Purtz
Дата:
Сообщение: Re: Be more clear what names can be used for tables with "CREATE TABLE"?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Be more clear what names can be used for tables with "CREATE TABLE"?