Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHYHK-00038F-0l for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 23:20:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHYHI-0003ha-Ci for pgsql-general@arkaria.postgresql.org; Thu, 06 Jul 2023 23:20:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHYHG-0003hR-Na for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 23:20:48 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qHYHC-002RA4-3O for pgsql-general@lists.postgresql.org; Thu, 06 Jul 2023 23:20:45 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 9E2A55C0196; Thu, 6 Jul 2023 19:20:38 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 06 Jul 2023 19:20:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1688685638; x=1688772038; bh=ZGoWLh2EpBaInpSlkfL3sRxQ6lNL9SQGE+Q LzQHihXo=; b=gSug5+6mr2F0G5PspAVnVV7dvT8KODXUE/R5eVI158dZlNll5gX Q4XRI0sEPyv88b3bVpdX3jF6oFNWJkDYoKo/OzdW3tdeL+KqB4i/irkkK9AVbJ6A wKVrANCDcMJnAaruw+IXqvdSBckeA43nnevzyudJy5LMnTxRUC/fIBVdCVH+UbWp EZw7MJqRHwb+0V0CXAog2/z2DUPa5z+Ma2I3K2qxH+MiQ6DeZGNlxG14l8XOahfN YHRckV43LjrLA2Bo64AtL8Oy1kqKdtPX1BJOEFOp8RMdriuHPdBbZuTZYakaPLau HqXYh/NiYBTnNAgzG8wIU4WpV6mdUvD3O7Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1688685638; x= 1688772038; bh=ZGoWLh2EpBaInpSlkfL3sRxQ6lNL9SQGE+QLzQHihXo=; b=h hLiOlZEO3ugACFRIaoiMyjMCMQlftO/If/DIPZZTGjkQouOxfE28K1YJtfMHv7+/ XCfC0j9Q6OFwT0kpM8iIaU+QInjy2PupQyKnrvG3VtKLVvJdBec4b/ZAe797TMN3 K58EoxyfJ9cmvO4P47X6utQ/EuhSv/9BGrKkDhBWSUGdanHitsTN5g7s+awfCB3N /tVVnrAj7eG0jep5Jn0orRbdrw+O5Uh3JJWbX9x5a+p2329g3m4/WghF6hhvHULm 2GpCPmvcvaHEDkVD2BlOIbF49Zi6flBGj0CuSAZhUyOsvjpDw6Ug5MXJKY9XcqzJ +tIUXcaa7h6193iL3s44Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrvddtgddulecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfhfhfgjtgfgsehtkeertddtfeejnecuhfhrohhmpeetughrihgr nhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh eqnecuggftrfgrthhtvghrnhepudfgueelgeevfffhgeeljeehhfettdegieelgefgheef ffefveegjedtueetffdtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 6 Jul 2023 19:20:37 -0400 (EDT) Message-ID: <86ffb8e8-c847-e1ab-5984-fd3548c53c90@aklaver.com> Date: Thu, 6 Jul 2023 16:20:36 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: [bug]? insert returning composite type fails Content-Language: en-US To: Lorusso Domenico , pgsql-general@lists.postgresql.org References: From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/6/23 14:52, Lorusso Domenico wrote: > Hello guys, > In my db (version 15) I've defined a composite type with some domains > > CREATE DOMAIN my_feat.audit_record_jsonb_domain >     AS jsonb >     NOT NULL; > > ALTER DOMAIN my_feat.audit_record_jsonb_domain OWNER TO postgres; > > CREATE DOMAIN my_feat.boolean_true_domain >     AS boolean >     DEFAULT true >     NOT NULL; > > ALTER DOMAIN my_feat.boolean_true_domain OWNER TO postgres; > CREATE TYPE my_feat.bitemporal_record AS > ( > user_ts_range tstzrange, > db_ts_range tstzrange, > has_future_record timestamp with time zone, > audit_record my_feat.audit_record_jsonb_domain, > is_valid my_feat.boolean_true_domain > ); > > ALTER TYPE my_feat.bitemporal_record >     OWNER TO postgres; > So I've a table like that: > CREATE TABLE IF NOT EXISTS my_feat.try_bt_info > ( >     id bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 > START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ), >     bt_info my_feat.bitemporal_record, >     CONSTRAINT try_bt_info_pk PRIMARY KEY (id) > ) Seems a long way around to arrive at: CREATE TABLE IF NOT EXISTS my_feat.try_bt_info ( id bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ) PRIMARY KEY, user_ts_range tstzrange, db_ts_range tstzrange, has_future_record timestamp with time zone, is_valid boolean NOT NULL 't' ); > -- > Domenico L. > > per stupire mezz'ora basta un libro di storia, > io cercai di imparare la Treccani a memoria... [F.d.A.] -- Adrian Klaver adrian.klaver@aklaver.com