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 1p1XNz-0002sx-7h for pgsql-general@arkaria.postgresql.org; Sat, 03 Dec 2022 18:37:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1XNw-0007jV-Lw for pgsql-general@arkaria.postgresql.org; Sat, 03 Dec 2022 18:37:12 +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 1p1XNw-0007jL-5I for pgsql-general@lists.postgresql.org; Sat, 03 Dec 2022 18:37:12 +0000 Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p1XNp-0005Z8-EC for pgsql-general@lists.postgresql.org; Sat, 03 Dec 2022 18:37:10 +0000 Received: by mail-io1-xd2f.google.com with SMTP id n63so603686iod.7 for ; Sat, 03 Dec 2022 10:37:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=vRigZY2TqcbpohbbWvdH1JUnDClDggxZxiuau3VJqWU=; b=WxufmnnKmP94JBFh1cnoA9XAAgp/iCtNASI+mTv6uyqfNZlP2LnhW3SVFtvUDMWQyG oHxbdySJ6JNteJwDxhcRc1RwRUUfjnuyAMbuozgJdoOY/y1EjkOmp1o6plR0+0SDzRWv 59t/MNTZZPohLCFPBkhHz7rSqMHMmdmX9jdaUSMY0Kbac+/66F3cbfWX9GFFS0Ky9J5k ptD2wG5LUySL4PB2Kche3X8E1dX8yRGKugy+2/sghJ/2ZNJfzNsOOXj2E3zh5sEJf8B8 lPhQUES4ZT10TNVR8rqVEZzZVrYKFOly2ekFvLL3CU62Soi/dmodTXeOTJ9eZtAL32d0 WHag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references: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=vRigZY2TqcbpohbbWvdH1JUnDClDggxZxiuau3VJqWU=; b=m57bre2NoE74gd35Xn0UA9UDVvVywkEL+WS6NvHvJfSQHASfrQdM9yXXPgMs1ZpLse /giz5EBGUzSbRreOO5t+QXQFfwF1jasT8aGYGOy+u8PNKiKUQFy6YUn72nJzjI2ywP/w 8eJMFddiAVwUZ+fpQbwDOoksJkPYmYmIPyddcNkYrOjxXPMrOKbP2J2al0+ZWY7N4kxR 4/Di28h02zFFmRKu0SH3emTzoXiEmYesNAhm39t2Ac4noqlqZ/luG/NZmREhU+wUv5Hx wWlKRe6n1aUAnro9PRqA4AAtgHmso7lUA+ExZ8SCt/3KvaD4PYjc5dBy6nhLBnUJliDo Cvvw== X-Gm-Message-State: ANoB5plJyxz4vsxszTHESOxMDRG3+PNk9mX8cOVz8wQVGTm/J6mqv+vr vRXpPIa6VByTRgNIOKqkimS/7FsyXTw= X-Google-Smtp-Source: AA0mqf4a1f4Zglms7IrfoaLG1rAbQ3PXcIxDfvfcFfQiRMZxRgn0cMK8fs5y0OxYpwEnpUIiP/Mm0w== X-Received: by 2002:a02:942a:0:b0:373:d769:bc14 with SMTP id a39-20020a02942a000000b00373d769bc14mr28069738jai.264.1670092624191; Sat, 03 Dec 2022 10:37:04 -0800 (PST) Received: from [192.168.254.71] (h244.184.30.69.dynamic.ip.windstream.net. [69.30.184.244]) by smtp.gmail.com with ESMTPSA id n25-20020a027119000000b0034c12270863sm3996909jac.80.2022.12.03.10.37.03 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 03 Dec 2022 10:37:03 -0800 (PST) Content-Type: multipart/alternative; boundary="------------gmq4nTkiBlU0TZ5FBcHvm0Es" Message-ID: Date: Sat, 3 Dec 2022 12:37:02 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.0.2 Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <23DE96C56DFC404096553A22DDC5093B@MARTIJNWS> <1579912.1669908194@sss.pgh.pa.us> <20221202150511.z3m53dlcxyja3cc4@hjp.at> From: Brad White In-Reply-To: <20221202150511.z3m53dlcxyja3cc4@hjp.at> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------gmq4nTkiBlU0TZ5FBcHvm0Es Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 12/2/2022 9:05 AM, Peter J. Holzer wrote: > I don't know how reproducable that tokenization process is. Can you just > do it again and compere the results? Right. You can compare passwords, even though you don't store the original. You might be able to run your virgin copy through the tokenization and compare the results. -- Quote Signature I talk with clients, find out where their pain points are, and solve those. On-call IT Management for small companies and non-profits. SCP, Inc. bwhite@inebraska.com 402-601-7990 Quote of the Day    There is a huge difference between fathering a child and being a father.    One produces a child. The other produces an adult.     -- John Eldredge --------------gmq4nTkiBlU0TZ5FBcHvm0Es Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 12/2/2022 9:05 AM, Peter J. Holzer wrote:
I don't know how reproducable that tokenization process is. Can you just
do it again and compere the results?
Right.
You can compare passwords, even though you don't store the original.
You might be able to run your virgin copy through the tokenization and compare the results.
--
Quote Signature I talk with clients, find out where their pain points are, and solve those.
On-call IT Management for small companies and non-profits.
SCP, Inc.
bwhite@inebraska.com
402-601-7990


Quote of the Day
   There is a huge difference between fathering a child and being a father.
   One produces a child. The other produces an adult.
    -- John Eldredge
--------------gmq4nTkiBlU0TZ5FBcHvm0Es--