Jeff Janes writes:
> On Sat, Nov 23, 2019 at 4:47 PM Tom Lane wrote:
>> Note that you pay a fairly substantial performance penalty for deferring
>> the check, which is why it isn't the default, even though the SQL spec
>> says it ought to be.
> Do you know what the worst case scenario is for the
On Sat, Nov 23, 2019 at 4:47 PM Tom Lane wrote:
> Note that you pay a fairly substantial performance penalty for deferring
> the check, which is why it isn't the default, even though the SQL spec
> says it ought to be.
>
Do you know what the worst case scenario is for the performance of
deferri
Blake McBride writes:
> I am using PostgreSQL 10.10. I am having trouble incrementing a column for
> reasons I can't see. It's probably some basic SQL thing. Your help is
> appreciated.
> create table my_table (
> listid char(36) not null,
> seq smallint
On 11/23/19 3:28 PM, Blake McBride wrote:
Greetings,
I am using PostgreSQL 10.10. I am having trouble incrementing a column
for reasons I can't see. It's probably some basic SQL thing. Your help
is appreciated.
create table my_table (
listid char(36) not null,
seq sm
Greetings,
I am using PostgreSQL 10.10. I am having trouble incrementing a column for
reasons I can't see. It's probably some basic SQL thing. Your help is
appreciated.
create table my_table (
listid char(36) not null,
seq smallint not null,
item varchar(4096),
p
