From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Be more clear what names can be used for tables with "CREATE TABLE"?
Thread-Topic: Be more clear what names can be used for tables with "CREATE
 TABLE"?
Thread-Index: AQHXzXxZ+UK3EUNBtU69P0HR9gEnYA==
Date: Sat, 30 Oct 2021 11:08:15 +0000
Message-ID: 
 <ZR0P278MB0920D0946509233459AF0DEFD2889@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
suggested_attachment_session_id: f974de49-9f54-e0da-2413-de5678c1f799
authentication-results: lists.postgresql.org; dkim=none (message not signed)
 header.d=none;lists.postgresql.org; dmarc=none action=none
 header.from=dbi-services.com;
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: c77a2644-58f8-4caf-70e3-08d99b95925b
x-ms-traffictypediagnostic: ZRAP278MB0771:
x-microsoft-antispam-prvs: 
 <ZRAP278MB07715B9A191A690BAB105D24D2889@ZRAP278MB0771.CHEP278.PROD.OUTLOOK.COM>
x-ms-oob-tlc-oobclassifiers: OLM:9508;
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 psF+p2yQkFWmy99ygjeHA7XyzvbHb0js/bkdBxCgH+de1kiuRDk9f8NVFPfXnLaQLSn+EIFr6kOJL9HI5qqWYr6pWVJ7m0ZVA9k2j+3FWRvVuvgjXZ+8mFuJEyyXuFMZCgvRWESzTuOIL+Il9fw6SVegK0r0W393uPj8tpqhquWH9rJQlfzABt+i+8ycTnyRXKCDv95A1G904fhX/iKs/dI2kPxSi/eVM2uqSEm3phop1pQPHlNxtnEtB7Kwl9H8Z66mjywLvQ3pzjpSPKB8FLRglY62ozh5nS3GRneKWLvvLKnPPVvsQxzH3L60b0B13MlcFFBxv0BAeu3lQ/vKxHqaf8mnCmnks0ZmEiepF1WJtAXLrRHellOTrpq35cBNHbwT+KnKElKxnZKH+2kRegtsXOfcsAEXPzJDH9VGzeNE6BFS7bav0NbDdVqbwEfoC68tqN4BZydgAe8dixI2eHke2t/nvYkhZtIV5MKQFHhGQfqCVwlamwdbjnGkF5187z/vNM5bIlqdKR6W6cqOKIU8vsEnIKXc/1oaG6uB2PpbFth9ajHMwMst0yB1SH9R6Whbf51/AFokhjds5lSZMRBiloeDXMMhZKXq+wQsY0ITy7YpPg2jLyuDJcg8h9rWKkduOI1B/pTNl6bLn1XkhZdnOSjy48HMIGE2mWdpcegWZOFgWUOYAjTbiYd5oQZsB3trXVCRiIVW+uYAlFEQ82onzM8N+1pHcVgnFbx/4vs=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(39840400004)(366004)(376002)(396003)(136003)(346002)(66946007)(55016002)(66556008)(64756008)(66476007)(316002)(66446008)(122000001)(9686003)(2906002)(186003)(38100700002)(71200400001)(76116006)(508600001)(8676002)(86362001)(38070700005)(7696005)(5660300002)(52536014)(6916009)(33656002)(8936002)(6506007)(138483002);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 2
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?ntG4PzXa8E4xnQwI8TKpg7LFIwPwcKrAyyVSPsMQxzgRlCo3sN73CtR+BW?=
 =?iso-8859-1?Q?PqvnuwokT3WhQbLv79EMjdkcRsqnVimASr1Ww8zLFRMmWT7MShgBqa4TnC?=
 =?iso-8859-1?Q?peUN96XzCHliyhqMeMeXOsVjyUd/UmES90ai+VB+DVZV+iI91neQ8Jt0PU?=
 =?iso-8859-1?Q?ucwRL3X5tpk6KcYgzQvGXxq16iGXekCFDkFULfbEnHHg5v377AjrV26Bis?=
 =?iso-8859-1?Q?dpGBYVaNon/LZE7rBJafgIyw6VfaEbfPSKGaPnacxTXY9XfAkHOPsLD6vD?=
 =?iso-8859-1?Q?IlvhRm0fvgOR6XaZhP77VNGpCsBfnXxz3VxybiAlioXaxz8vNvFOXYjUpv?=
 =?iso-8859-1?Q?PjifGqp8c9SBQvxYN9W+G+OFgZWbAOvAjhwy+nDPXQ1Z3qGIWkq4jBLdL6?=
 =?iso-8859-1?Q?WXpLt1+49anrZHi7EFo5NN6eicL3QUxDKHnXSBdXYBEAdz0xWpJVo9htni?=
 =?iso-8859-1?Q?5mPpmGM+vyAHizaNFsbClIeIl8bVa+3U9iI/67CVR7qqbcC0eshlgqJH3b?=
 =?iso-8859-1?Q?he57fMT4lhRXbDV95Py/gjZsubJI58zUV/vHUf0CZgRfKbopXKca+Yng+A?=
 =?iso-8859-1?Q?tbbUCeBp2/ZkEb245TPCtPl+bWR5n+tfyCMptFRQY6QW90AC5chEala6AQ?=
 =?iso-8859-1?Q?SR9qEH3BgdeLmx/8/Xk8OWc2C9pbqsn6qvrDVsFm39AtepAAxW0WIJLMsw?=
 =?iso-8859-1?Q?fXkCA9qJ4hk/aIkjaauZDEnr7ssz5y45PhV9h0aMjT4eTV5Eu1nRqImsp1?=
 =?iso-8859-1?Q?soCobXa+xo8KqV971supl60BsgcBJJYnyOsz1sufpIk9OgOpINes+8zZfk?=
 =?iso-8859-1?Q?lo10yImNAeWiKI3+UgEPoU4FNSeQDDXHIWP6l30d6g4xEmPC2U24oiovQd?=
 =?iso-8859-1?Q?7046PhsN1P8NzSsWTuCfbm5KmTedGIqY9V2wF4mJs7TUroltGhQ1hQy+0E?=
 =?iso-8859-1?Q?Oik7insdhqlgYmaYdn5LX6jcCQgCZ1+CfNQgkgjSABXiGQNThcRrnxbilt?=
 =?iso-8859-1?Q?4OU5nWqHhngd+vOW+zY0FCvZggNva3QIe3WmrmWav06zpU761/fuF9cFxX?=
 =?iso-8859-1?Q?1UcYpIwt8iVem/9DNaZ9njY9sc0q7KzmvBjudmPV42KPEa48y/UE6eomCh?=
 =?iso-8859-1?Q?ymcx85F8+n2YuYIVEaPxsnOeOFzN8YLIGAl5GPfTgqnLV6RaRiyxj9XKlf?=
 =?iso-8859-1?Q?FfiEOJTRb46mxX46fdSVmc30sYp+SFydS5UGZz0s4WF8j4FL2r11QbzZax?=
 =?iso-8859-1?Q?utQwa/nAYomtm9a2cBMhFaIWQbhx8jtY1rPGyPXM/x0JLUN54bnOSV4NKn?=
 =?iso-8859-1?Q?kn1JDqkIIyu7HED0qswml321rzV7adZqPGfp0puOxuHL70N4BChZSHEWqT?=
 =?iso-8859-1?Q?mdFbpe2KjE+fPpJ9cc5eC7ezNqG5nAVxyG+NrSgEsy4LR8K7JuShRYiNSB?=
 =?iso-8859-1?Q?tdTUqyxvTp5IEuV+fiAFEej2KBP2yGyviWEi6VgXjfDNx6CaDS4i/PgdE9?=
 =?iso-8859-1?Q?61DW5vKLNp6qoOUaJvdDZZRxdEWGombk0vp0GkgId+1c2smV0Ptwq56iAc?=
 =?iso-8859-1?Q?+EjeLm1IpPiILwvkKkQTejbtVbt+gZYvvX7qRSj+mq3c99OI0R6+xlpP3W?=
 =?iso-8859-1?Q?OkkIhFXgrG4E/nzXZJWhqjf8C9rOHYvoqqt3/+JkoC/sa+cHDQ7L+r0PUv?=
 =?iso-8859-1?Q?GX3FJdzS8kLt4z/eYcHB0v019WQcjqO6ehgbE1/Aw6slravu0iY0gfVaM/?=
 =?iso-8859-1?Q?72JTap4/vDRynGRcNYn/xsQpzGr9rviMJLdTyd0glX/RVxzHHP/tdYoqg5?=
 =?iso-8859-1?Q?BwPaaz28wRoxuBRSFBGUd95vYGuTmpK03ZzbAofY3+7x983ldgoQ/Uf5Wr?=
 =?iso-8859-1?Q?yD?=
x-ms-exchange-antispam-messagedata-1: 441H6JvMdrabLg==
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: dbi-services.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 c77a2644-58f8-4caf-70e3-08d99b95925b
X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Oct 2021 11:08:15.7205
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b9c70613-b1ea-47b7-9fdd-e6f3a67ce75c
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 0TlO8g1xHwe0+wC+WRfsxqJsh1Qf0j/iXKMoMgnlZbcBwIUs1Q9a4HUAhQ8MMhrLNFN5JhtnryT4EEU77oE3Aop6yB5Iv7Mz8r/A/HsPiCJNW/tYEaTOfsVuxgwQBuyz
X-MS-Exchange-Transport-CrossTenantHeadersStamped: ZRAP278MB0771
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/ZR0P278MB0920D0946509233459AF0DEFD2889%40ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

HI all,=0A=
=0A=
in the documentation for CREATE TABLE we have this sentence:=0A=
=0A=
"The name of the table must be distinct from the name of any other table, s=
equence, index, view, or foreign table in the same schema."=0A=
=0A=
At least materialized views are missing:=0A=
=0A=
postgres=3D# create materialized view t as select 1;=0A=
SELECT 1=0A=
postgres=3D# create table t ( a int );=0A=
ERROR:  relation "t" already exists=0A=
postgres=3D# drop materialized view t;=0A=
DROP MATERIALIZED VIEW=0A=
=0A=
Domains are also missing:=0A=
=0A=
postgres=3D# create domain t as int;=0A=
CREATE DOMAIN=0A=
postgres=3D# create table t ( a int );=0A=
ERROR:  type "t" already exists=0A=
HINT:  A relation has an associated type of the same name, so you must use =
a name that doesn't conflict with any existing type.=0A=
postgres=3D# drop domain t;=0A=
DROP DOMAIN=0A=
=0A=
... but that maybe is covered by the next paragraph?=0A=
=0A=
"CREATE TABLE also automatically creates a data type that represents the co=
mposite type corresponding to one row of the table. Therefore, tables canno=
t have the same name as any existing data type in the same schema."=0A=
=0A=
Regards=0A=
Daniel=