Re: [HACKERS] postgres_fdw and defaults

2016-11-15 Thread Andrew Dunstan
On 11/15/2016 10:49 AM, Tom Lane wrote: Andrew Dunstan writes: I know we've discussed this before, but I have just had the unpleasant experience of trying to get around the difficulty of inserting into a foreign table with a serial field, surely a common enough scenario that we should try to

Re: [HACKERS] postgres_fdw and defaults

2016-11-15 Thread Tom Lane
Andrew Dunstan writes: > I know we've discussed this before, but I have just had the unpleasant > experience of trying to get around the difficulty of inserting into a > foreign table with a serial field, surely a common enough scenario that > we should try to deal with it better. The solution

[HACKERS] postgres_fdw and defaults

2016-11-15 Thread Andrew Dunstan
I know we've discussed this before, but I have just had the unpleasant experience of trying to get around the difficulty of inserting into a foreign table with a serial field, surely a common enough scenario that we should try to deal with it better. The solution of using a local sequence rea