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.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vONwf-005V29-0j
	for pgsql-general@arkaria.postgresql.org;
	Wed, 26 Nov 2025 22:25:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vONwb-001wFg-0w
	for pgsql-general@arkaria.postgresql.org;
	Wed, 26 Nov 2025 22:25:01 +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.96)
	(envelope-from <christoph@fecra.de>)
	id 1vONwa-001wFY-2c
	for pgsql-general@lists.postgresql.org;
	Wed, 26 Nov 2025 22:25:01 +0000
Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <christoph@fecra.de>)
	id 1vONwY-001gBE-2M
	for pgsql-general@lists.postgresql.org;
	Wed, 26 Nov 2025 22:25:00 +0000
Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-b735b89501fso34888866b.0
        for <pgsql-general@lists.postgresql.org>; Wed, 26 Nov 2025 14:24:57 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=fecra-de.20230601.gappssmtp.com; s=20230601; t=1764195895; x=1764800695; darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:in-reply-to:references:mime-version
         :from:to:cc:subject:date:message-id:reply-to;
        bh=6aYamuhfDeXWy+Kv+2vsGPXnzqIbgfX+dnuksGMmWWg=;
        b=PyLbYtE3XjqeGOL1sNKB4o72V/dbKwJczw/raXveNs0Ub+eY9yr60ivULBDEZ+vxkC
         5xons5DB8Y/ju8LAIFmevChB140uzZCE+jOb5w3qHFaP1sI3pTCqU6gxkYvx8h85qSUC
         IZ+vZiRS1I2BH65W4YKv5EvIkHS6kTppS3ChwYIBIs9TSOqlgOeEPros56HWA76jOO3K
         xgkfbRFjo/hdP2qlRoLXAf1ZaYR5+X/VHZxIOrxeYnveluAw+APIScUqOw947tNaqQjt
         KW7PuC49xugEKEvL8HMbD2DpEYiMmJd99pPb1gwJ8AkOMoh/+IuIQyDfJ6m2aDI8IyLP
         iA7Q==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1764195895; x=1764800695;
        h=to:subject:message-id:date:from:in-reply-to:references:mime-version
         :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=6aYamuhfDeXWy+Kv+2vsGPXnzqIbgfX+dnuksGMmWWg=;
        b=IJIqOO7fsp+ebMH3/RqZNWIkbeRH4orLBZ4vd8lKUfGg4ugNTwaWLi7jpTkdzJpRNR
         VGZrGmkssfIUVUKNFXagNrT8LyY4gMFSLL6eccAZuW4iDrfygJXfVgO1oc2RyV3LvAe+
         w66OesTLDv9hJ/4mL1i9r1f3N2TI8mhbonuUw0bN9VoswP5jYNb5SRxsVzj3Jis+IehU
         7nMeyuiFokRgp4IKwZAZ7w7sEUNv9vQanEY/0Bb/BhMzKjhDWJwt8jbFHMWL5waifiv0
         Rb7uCjjW4HR/aB2sYpEUaHw+VN13bquZH6i7ZbeyEp/M89KNgRnCSEr0Ftju9IaE1+mH
         jRMg==
X-Gm-Message-State: AOJu0Yz65ZVLLuAz1kawJrv3V2mffEBpIiw5qs/tsDaXkvMlgqYkodAC
	ENSo4TEotlGo60R5f8JF5Baat9m923f+GatldcaLl0xm6AbB6v86EqpzKPUQ+bIsJdv31iE1rKX
	36eY195YZhyIbUgzjNdBIcGKdnzxOA4woAzE5npn2sfMFtmGJ+Sv7
X-Gm-Gg: ASbGncvzDOCuiu7dAP3Iwe/eVZnoofK8v2Bzqe/QXy4CODFAogaxARHl9AGEfkNbFD1
	OdTAulNNspfV6Bf8aQITc4uRX3iLM97k1tIIb4IPfX9vSMMCVzseeLXh1vaUSiwqtnq+RRpFMrp
	posQjXcIAIdCFINPQ/rp6FWJRcN2WYLYxHitoJICUAevcGnPeEyieZMPQZki+KBxfHqvpxKBgx0
	LrY6RYzjfgtEzgdU1wqOUgMFFhKEtXpbkGYG+629tnMQEZ8LOmmjJ5O7LZo1hBb4vBhwdU9Z6sn
	xxglEOGj0rl3vlQ2IZrRjEQMDZO5Tg==
X-Google-Smtp-Source: AGHT+IF0oAgnNJAISLmM/hV3k8aoDarOl7LxDth9UxZsmCefkhSRUobhlbJgSvXA97liWcwMlNQruLs3VIxS3Yk2/vo=
X-Received: by 2002:a17:906:81d8:b0:b76:d734:d459 with SMTP id
 a640c23a62f3a-b76d734d4c4mr483932666b.57.1764195895380; Wed, 26 Nov 2025
 14:24:55 -0800 (PST)
MIME-Version: 1.0
References: <CAEzggP_UOGwe5BA9s3iLY3R8LEi4QztA=2ka+vkRp-Wy64vXdQ@mail.gmail.com>
 <bbd73b96fbce29e0c1941253590f39ced1e79d4d.camel@janc.be> <CANzqJaCfSFh+hjL1EVa9tHA3gzHfnciWBhFBzz_naPj3a008kA@mail.gmail.com>
 <CAEzggP9b0AP9AM9yD+NpZU3fWRCfM4STV1D8SEkzUPoisKQrPg@mail.gmail.com>
In-Reply-To: <CAEzggP9b0AP9AM9yD+NpZU3fWRCfM4STV1D8SEkzUPoisKQrPg@mail.gmail.com>
From: Christoph Pieper <christoph@fecra.de>
Date: Wed, 26 Nov 2025 23:24:19 +0100
X-Gm-Features: AWmQ_bk-MhxG2XrJ_3trDTly95xosRvSQwc_mlQDsG6e-LNmD7lY04Rma7tF8pA
Message-ID: <CAEzggP9TjxdAGNHzjJJGcuGstT-9NzBm24SJc9UcmRQYnZVFDQ@mail.gmail.com>
Subject: Re: Schema design: user account deletion vs. keeping family tree data
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a89af3064486dd4b"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAEzggP9TjxdAGNHzjJJGcuGstT-9NzBm24SJc9UcmRQYnZVFDQ%40mail.gmail.com>
Precedence: bulk

--000000000000a89af3064486dd4b
Content-Type: text/plain; charset="UTF-8"

Thanks everybody!

And what do you think about Option A?
Especially the pedigree node approach beside the animal node?

--000000000000a89af3064486dd4b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Thanks everybody!<div><br></div><div>And =
what do you think about Option A?</div><div>Especially=C2=A0the pedigree no=
de approach beside the animal node?</div></div></div>

--000000000000a89af3064486dd4b--