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 1sQnBa-00BehX-Is for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 12:09:38 +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 1sQnBY-005MfB-Sk for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 12:09:36 +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 1sQnBY-005Mf2-EF for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 12:09:36 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQnBV-0011Su-Ce for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 12:09:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1720440571; x=1721045371; i=shammat@gmx.net; bh=HjSM7jxcv2FERDPmZYKkhKp9AV856KSxZ531y/tcMWY=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=MGlTrDHO3VgtimjUMJ3JNeDLagxHOCXRqg+YpWYnHG9AYrBBuHRgammt1L5myk1X JcyR5Jv6OailSi3Rtkk6Vi9rQHHx9S6lk0ur4VTzAK5Sr1Z8Qq7AGvnBPMu9pzwis xyTumYzTa0zFA/vh3vqu0T+zEGsjnit2H/8r6XLo5WObXyKTzslV6hbZ5H8X29GFC 6m3nmK3PZubWIWd1td2zewEepZtWaAa0ink3D4KJ09R5w4JAh9SpYYEM5+2T9JWD0 gAkdXCqOrfCBW1PlOj9leDiQ5VbqoFHyxYE3+dyr0dxj+nFLkGS/qxNe8qcB/2WDf Maz7U6bBSbPYDB8Dgw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.1.35.121] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MYNJq-1suzCi3avi-00XUVB for ; Mon, 08 Jul 2024 14:09:30 +0200 Message-ID: Date: Mon, 8 Jul 2024 14:09:30 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Trick to create alias/mirror table To: pgsql-sql@lists.postgresql.org References: Content-Language: de-DE From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:ilGkroZAfB6xzzXI85Y2Ze9efqzAkKS3fqKYLZ9nexqgb24Xpvk g9sQVLinLun9bZOyR4s0eTutsUxmdZ8nRdu4huCcBNDqv+JHlpvJSAWLebVIthZj64KcA8l l6h7N6zxjBT6R/iryAAG1jBmjYCv9J8sGB8MYh0fnIf47hdI8+r0YAlYqsJKdHPuBs1N/bp 8in352WdHYhDpx0hvsxrg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:3BBf6LOofF0=;k+KIGjfdG125FIIj6B/GlOBkI5X RES02+ClTiKcfRDqKSB0IlIYAjNMP8hegTFFsnPdgEs84gmyRb/RPSDvmyfanilR+wxn8Ctq9 v+gGW/JO7V4TZoX3Lx6lLltrcthy7hWnE5BDg9B9hLwe1LMV2tJF0cNovdBeJcY8L/Pfd1Sxn W44Oaj7mgviRsXdoT+rFDPGWLixGWMoQ5qDuSQgsG/ib87S0iH34RUy+d9rUOwBxlwimaNy7B RcgFDXfuxjUfEX0+KvroxHhk5Z9lQ64SDB+NgbBJSf7mgFdZYg2I8GH+zIxEtzlKuYRfkavVm ptAjMRg9+H5XOPOdVV00IzbT+siT38kpC9WWgHOCuxKvpW83Fh1gG1kNmArUfrK5ZoEBbtJja h1FkbyJrd7sIAsDg4JjeDpv3qdA+D8o+QxkxFvwl/UVnlv2VZTVIUXlkjInTeZ8A+gqS6qJPt 6KUrfk+NHn0Da/ls7oPOSZo920WYueiqJusI/COgee09reWHrlCr4QReZFLJkkV/fA7lAdrPv P9Wgm62kBWHvxftXsEDo1jL+DvVDciOOOugXWT7aneoRQdKdDzRz5mIzTm+XN67llEtlE4fyt RerCERQLmM2z26awy8NshnDU6lm9SirvpfZnSoB+Pgf8AJPvbhPejq7M7EPJJlc0x26Th6opJ DDdRg1n0XKuzSIvSUrZ68qb9rVyP4VB1ZwlQ9C3VV6LYZNZIviIYYiadKpDiEIMqH54B0YX+2 vEQ1AVcmJYX0Pc3ALGSKg/8KeuFgzY0EcUFS2WFHD3DqZLVHKX48RY4Q+QUrguxCo7e6ibe+s 0jAe9HJMCqNwLMfJqJFPWoyE2OlbOLimNsWOp+35PEvAU= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk intmail01 schrieb am 08.07.2024 um 13:27: > Hi, Looking for a trick to make something like an alias or a mirror > table. The alias can be updated. View is not suitable because it is > read only data. The alias is always linked to the original table. > When a modification occurred in the original table this will be > visible in all link tables. This sounds very much as if a view would solve that requirement. Views can be updated in Postgres. Either automatically if it's a "simple v= iew" or by providing a function that handles the DML.