Re: feature request ctid cast / sql exception

From: Vladimír Houba ml(dot) <v(dot)houba(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: feature request ctid cast / sql exception
Date: 2021-04-18 06:50:37
Message-ID: CAP=jTS79cq265sF4RM+T98a_bxg80rxVzm=jQrhm0Y46oxDHrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This is a specific use case, I have a big table without a pk. Updates with
ctid are blazing fast even without an index. I dont need it.

The argument behind this is that users excpect this functionality, its not
just me. Search stackoverflow. They end up using various suboptimal
solutions as I described earlier. This is a very very simple functionality
so please consider it. Im also writing an opensource lib that would make
use of this. My users will be thankfull to you.

On Sat, Apr 17, 2021, 23:05 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Sat, Apr 17, 2021 at 12:58 PM Vladimír Houba ml. <v(dot)houba(at)gmail(dot)com>
> wrote:
>
>> I use ctid as a row identifier within a transaction in a Java application.
>>
>
> This doesn't present a very compelling argument since an actual user
> declared primary key is what is expected to be used as a row identifier.
> And as those are typically bigint if you follow this norm you get exactly
> what you say you need.
>
> David J.
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2021-04-18 11:23:33 Re: Bogus collation version recording in recordMultipleDependencies
Previous Message Pavel Stehule 2021-04-18 04:21:56 Re: proposal - log_full_scan