serial and partitioned table

2023-10-17 Thread Ashutosh Bapat
Hi All, #create table tpart (a serial primary key, src varchar) partition by range(a); CREATE TABLE #create table t_p4 (a int primary key, src varchar); CREATE TABLE To appease the gods of surprises I need to add a NOT NULL constraint. See [1]. #alter table t_p4 alter column a set not null; ALTER T

Re: serial and partitioned table

2023-11-13 Thread Peter Eisentraut
On 17.10.23 09:25, Ashutosh Bapat wrote: #create table tpart (a serial primary key, src varchar) partition by range(a); CREATE TABLE #create table t_p4 (a int primary key, src varchar); CREATE TABLE To appease the gods of surprises I need to add a NOT NULL constraint. See [1]. #alter table t_p4 a

Re: serial and partitioned table

2023-11-16 Thread Ashutosh Bapat
On Mon, Nov 13, 2023 at 3:39 PM Peter Eisentraut wrote: > > On 17.10.23 09:25, Ashutosh Bapat wrote: > > #create table tpart (a serial primary key, src varchar) partition by > > range(a); > > CREATE TABLE > > #create table t_p4 (a int primary key, src varchar); > > CREATE TABLE > > To appease the