Re: FOREIGN TABLE and IDENTITY columns

2024-10-15 Thread Peter Eisentraut
On 08.10.24 18:40, Ashutosh Bapat wrote: On Tue, Oct 8, 2024 at 7:57 PM Julien Rouhaud wrote: I was looking at the CREATE FOREIGN TABLE documentation to see if IDENTITY columns were supported, and according to the doc they're not: only GENERATED ALWAYS AS ( expr ) STORED is supported. However,

Re: FOREIGN TABLE and IDENTITY columns

2024-10-09 Thread Julien Rouhaud
On Wed, 9 Oct 2024, 21:22 Ashutosh Bapat, wrote: > On Wed, Oct 9, 2024 at 4:22 AM Julien Rouhaud wrote: > > > > On Wed, Oct 9, 2024 at 12:40 AM Ashutosh Bapat > > wrote: > > > > > > On Tue, Oct 8, 2024 at 7:57 PM Julien Rouhaud > wrote: > > > > > > > > > > The rows inserted/udpated on the fore

Re: FOREIGN TABLE and IDENTITY columns

2024-10-09 Thread Ashutosh Bapat
On Wed, Oct 9, 2024 at 4:22 AM Julien Rouhaud wrote: > > On Wed, Oct 9, 2024 at 12:40 AM Ashutosh Bapat > wrote: > > > > On Tue, Oct 8, 2024 at 7:57 PM Julien Rouhaud wrote: > > > > > > Hi, > > > > > > I was looking at the CREATE FOREIGN TABLE documentation to see if IDENTITY > > > columns were

Re: FOREIGN TABLE and IDENTITY columns

2024-10-08 Thread Julien Rouhaud
On Wed, Oct 9, 2024 at 12:40 AM Ashutosh Bapat wrote: > > On Tue, Oct 8, 2024 at 7:57 PM Julien Rouhaud wrote: > > > > Hi, > > > > I was looking at the CREATE FOREIGN TABLE documentation to see if IDENTITY > > columns were supported, and according to the doc they're not: only GENERATED > > ALWAYS

Re: FOREIGN TABLE and IDENTITY columns

2024-10-08 Thread Ashutosh Bapat
On Tue, Oct 8, 2024 at 7:57 PM Julien Rouhaud wrote: > > Hi, > > I was looking at the CREATE FOREIGN TABLE documentation to see if IDENTITY > columns were supported, and according to the doc they're not: only GENERATED > ALWAYS AS ( expr ) STORED is supported. > > However, a quick test shows that

FOREIGN TABLE and IDENTITY columns

2024-10-08 Thread Julien Rouhaud
Hi, I was looking at the CREATE FOREIGN TABLE documentation to see if IDENTITY columns were supported, and according to the doc they're not: only GENERATED ALWAYS AS ( expr ) STORED is supported. However, a quick test shows that this is supported (same as serial datatype), and apparently behaves