Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLG7d-00DiBv-EZ for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Dec 2024 06:22:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tLG7a-00CvIg-GH for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Dec 2024 06:22:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLG7Z-00CvGe-Q5 for pgsql-hackers@lists.postgresql.org; Wed, 11 Dec 2024 06:22:55 +0000 Received: from mail-lj1-x22b.google.com ([2a00:1450:4864:20::22b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tLG7Y-002D5g-JB for pgsql-hackers@lists.postgresql.org; Wed, 11 Dec 2024 06:22:53 +0000 Received: by mail-lj1-x22b.google.com with SMTP id 38308e7fff4ca-2ffc76368c6so58706721fa.0 for ; Tue, 10 Dec 2024 22:22:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1733898171; x=1734502971; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ohRMO7zX1VRSqyUoXaQOVKmhXA1xxWUKF/nT6BbziQ0=; b=iq3ijZEhgiC9DNHwBLqjrOOcP5TKrI0vH0osH/T3bNF2hoVEQeApgWK1DHjbVk923T eOLJur51/sUgIIZP0ZIR5UnNdYu1SpuMWpQOuoz1v2UrJQ6BOMpemYKA81hVyvAmvq4e FdTsxy2p1hePEZcC+s394vlXCTsF9xDP2Jzfj3fyFxTfiPEmu0JZPT6twbXYBk80jB0M 6I3M02MaZcnhhBXX2jSLut4gq2ExzvMBj44pgMk61Qguqx5pJcliA1HMbUDNphS28rVX lMWjzUqXAiFJYD49KrMTuRUsDnyoNmm3iZNGdWju6MdTRlGf6WWO6vFtpDURyNCWz58B UZ3A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733898171; x=1734502971; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ohRMO7zX1VRSqyUoXaQOVKmhXA1xxWUKF/nT6BbziQ0=; b=F9AlQa5EOzYwXcdHl+nuobJxk4PDFs17/oqcWdv9mqwYplVXO+Zyl/evAps7YA7PXw u/Rzr1iuby9b2PsghC7hKx5U/5cmCnhnkjfBxTrdY5VJuTSukygz/MxCQaoiJZiIhrN9 WY8i6AveflaA12Mue+yEtWzUuTPWYdQuXwJAQRWkltG5ltVrfVnEAC3VUHbPkTLrbXTQ QRouA3OFkFkfhRxwBl/iDcau/tfkIEpZFqXxIzqyDaK/wz1Lf4JOb8YUT2vRGkuucSH4 ConOeRG2PpBMS+z3xSkxkjz3RuTYiCuMaWy/K09wSX1KqLugPRWmvjIFfkswktWVWUSZ pt9A== X-Forwarded-Encrypted: i=1; AJvYcCU2fS3DpqDRNdcMXrpDiqIPpPg+BH8pHilLqn0vRqPLt7uYH2poBVxAPcQG1csI8dUl/ejta+BLyvYx9Tvz@lists.postgresql.org X-Gm-Message-State: AOJu0YwzYhNgzOchzjrZ2RUeSHHuwnzbiyWpb9A/4HvxJ7YN2jcV5W10 sSwLNV36ffQeOSbp5SVMa/5ou6KByMWS4IDhd+JM4F71yuZsBiL1/3dTi0GzVZLXXj6ygol/bE7 o/NIR5g20EJO2vfFqr6YUjs33GBc= X-Gm-Gg: ASbGncvng622kfP4vaWXUMJHb/T+nmVkMqawA7inGwDvCjuNtuIDNrMB1KVQJlw7ODZ +w+7Rq9E5mvjTK0ymqP51XVDc5TLrq+ds X-Google-Smtp-Source: AGHT+IF5XGYGq/cswI13lpgVrmjbmCpFlCC4X/zcf34RJ7NLI8gH0lYm/72RKdCZT9W9o7deln+UMeRNTkNG6uHw3+M= X-Received: by 2002:a2e:a9a0:0:b0:302:34d6:f047 with SMTP id 38308e7fff4ca-30240c9fc4cmr4795631fa.5.1733898170488; Tue, 10 Dec 2024 22:22:50 -0800 (PST) MIME-Version: 1.0 References: <1898722.1732732780@sss.pgh.pa.us> <2007224.1732773174@sss.pgh.pa.us> <1075425.1732993688@sss.pgh.pa.us> <345c20e5-a6d7-477a-9598-982661bb5740@eisentraut.org> <1990479.1733256458@sss.pgh.pa.us> In-Reply-To: <1990479.1733256458@sss.pgh.pa.us> From: Kirill Reshke Date: Wed, 11 Dec 2024 11:22:39 +0500 Message-ID: Subject: Re: CREATE SCHEMA ... CREATE DOMAIN support To: Tom Lane Cc: Peter Eisentraut , jian he , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Looks like this thread does not move forward. So I'm posting my thoughts to bump it. On Wed, 4 Dec 2024 at 01:07, Tom Lane wrote: > I'm totally willing to throw that possibility overboard > permanently in order to expand the set of creatable object types > without introducing a ton of restrictions and weird behaviors. > What do you think? Im +1 on this, but can you please elaborate, which exact objects cannot be created now? What will be expanded after v2-0002-Dont_try-to-reoder....? > PS: if we were really excited about allowing circular FKs to be > made within CREATE SCHEMA, a possible though non-standard answer > would be to allow ALTER TABLE ADD CONSTRAINT as a . That's a nice feature to have by itself? -- Best regards, Kirill Reshke