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 1rPpYJ-00EUVT-Bn for pgsql-general@arkaria.postgresql.org; Tue, 16 Jan 2024 19:56:51 +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 1rPpYH-0078Kk-3a for pgsql-general@arkaria.postgresql.org; Tue, 16 Jan 2024 19:56:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPpYG-0078Kc-Mv for pgsql-general@lists.postgresql.org; Tue, 16 Jan 2024 19:56:48 +0000 Received: from mail-ot1-x32b.google.com ([2607:f8b0:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPpYE-002AiF-4b for pgsql-general@lists.postgresql.org; Tue, 16 Jan 2024 19:56:47 +0000 Received: by mail-ot1-x32b.google.com with SMTP id 46e09a7af769-6e0a64d94d1so2022223a34.3 for ; Tue, 16 Jan 2024 11:56:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705435004; x=1706039804; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=6L4FfdOMxgXCRJHxoaUDLBAscSItUwwimpnlQOLxoBg=; b=Wv2sKsLAilM95dB7+exmlHzH56eYeO0MhRgQh7E37yPYbjCv6vM9KRfjW7iElMCGfV IHWApvdRyVWsRtSSS1DmeGlAddnYqwmEshh/c+9240QcAbTv7mqbppECcr5JQ59ynVX9 i+k7Uj5bvvzMjkrs5NQmrHAYcwI/Hh+1QXyw2Q2J6Ky2xO0rBfPJdJP87w0ruEhIR49e gMPn0cikJ4fAEnJtnoO2PV29FSzXEe7FlQyKYvDRmU1yUPn0QwH4PPB59PAedTM0NkNv H42AX1ISWsV/IDpOGA0VDalhcSTfa8vdqPULBhj98MCMc7NiSrZbTgyzGbePTP5cr2gf aT3w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705435004; x=1706039804; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=6L4FfdOMxgXCRJHxoaUDLBAscSItUwwimpnlQOLxoBg=; b=lMY363gIAeezrPz628DTL5Jh1gl7OqAzTm3R7ExuWhqMBnQhYF3pWYvKPXPgpPxdIc 5ZI9riHmJPzLKakmnWVROunVwK4RH/QjMSfMIi8n/MTJOwbmwmkpu2bL3/p6sBUgo3nW 7l4c9FaZ/cDGLtQ2dN2nKkaPfbP1Hgxy5EDE+h1y4IthhhzqfZ0PqOjnjnVvzwdnVS+d u9HTkD3fpNLDT++VSAL6r/PM4LRbrwozEVO3DhHmPnX34wdcxSom4ShZPKXziDjPE7sg WLTUfkQ3hjk7qit/xDMQkrho9eKNwlhryqzg097HdD+RWwHBQACrB9/oFehRB8mu2mFr dDBQ== X-Gm-Message-State: AOJu0YzThafBuBCA5mM79qPlUlYCg2Y+M42muFQbQMgzV7RzQf8MfGY9 4FN2z/161Tppcwun5ZuqcBlKrPa4UU5E X-Google-Smtp-Source: AGHT+IGkiIDpQOGNrhAqsvc2deRk53oawX0ZMo/R6dpX+Gz0FPbY5ycLsSG+JpkyjbTfP9EzEvwOig== X-Received: by 2002:a05:6870:b023:b0:206:b172:2a2f with SMTP id y35-20020a056870b02300b00206b1722a2fmr9488305oae.54.1705435004245; Tue, 16 Jan 2024 11:56:44 -0800 (PST) Received: from [192.168.2.16] (070-113-014-216.res.spectrum.com. [70.113.14.216]) by smtp.gmail.com with ESMTPSA id qb12-20020a056871e78c00b0020807d8d26esm1564840oac.27.2024.01.16.11.56.43 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 Jan 2024 11:56:43 -0800 (PST) Message-ID: <7f3c5e17-7f5c-4c50-b94e-7a1713fb6ccd@gmail.com> Date: Tue, 16 Jan 2024 13:56:41 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Add support for data change delta tables Content-Language: en-US To: Pavel Stehule , PavelTurk Cc: pgsql-general@lists.postgresql.org References: <4f12dcdb-6d17-22a9-14e7-c006c97f5fab@gmail.com> <24408e7c-6103-eec0-8048-594b15a5e7af@gmail.com> <8bb25b38-f6e9-b828-114a-631447674b9d@gmail.com> From: Jim Nasby In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/15/24 4:40 AM, Pavel Stehule wrote: > PostgreSQL is not a project where somebody says, you will do this, and > you will do this, in this and this priority. There are a lot of nice > features from standard - SQL standard is big, but a) you have to have > funds to pay the developers, b) you have to have developers with free > time who want to do free work. Sure, you can write a proposal, but > without a) money or b) your hard work is not a big possibility so your > proposal will be implemented in the next few years. With the patch the > situation is different. Then developers can see, so it is possible to > implement, and how much code (and work) needs it. And in this scenario, the big thing that a patch provides is clarity on what you're actually trying to accomplish. Your original ask is frankly as clear as mud to me - I have no clue what the syntax you showed is supposed to be doing. If you were to ask about something concrete in plain English (vs some unspecified SQL syntax) then you'd be much more likely to at least get some kind of response about your idea. It's certainly possible to convince people on -hackers to work on something that you'd like to see done, but the base prerequisite for that is you have to communicate what you're actually looking for. -- Jim Nasby, Data Architect, Austin TX