Re: A question about sequences and backup/restore cycles

2019-10-22 Thread Stan Brown
Oh it is the one we are working on. One of my team members brought up this issue from a job where we worked on a vendor designed one. I am convince we do not have an issue now. Thanks for your expertise. On Tue, Oct 22, 2019 at 4:42 PM Adrian Klaver wrote: > On 10/22/19 1:35 PM, stan wrote:

Re: A question about sequences and backup/restore cycles

2019-10-22 Thread Adrian Klaver
On 10/22/19 1:35 PM, stan wrote: On Tue, Oct 22, 2019 at 12:48:41PM -0700, Adrian Klaver wrote: On 10/22/19 10:48 AM, stan wrote: Please reply to list also: Ccing list. Sorry if my description was not clear. No, we do not mix test, and production data. Let me try to clarify the question. L

Re: A question about sequences and backup/restore cycles

2019-10-22 Thread stan
On Tue, Oct 22, 2019 at 12:48:41PM -0700, Adrian Klaver wrote: > On 10/22/19 10:48 AM, stan wrote: > Please reply to list also: > Ccing list. > > > > > > Sorry if my description was not clear. > > > > No, we do not mix test, and production data. Let me try to clarify the > > question. Looking

Re: A question about sequences and backup/restore cycles

2019-10-22 Thread Adrian Klaver
On 10/22/19 10:48 AM, stan wrote: Please reply to list also: Ccing list. Sorry if my description was not clear. No, we do not mix test, and production data. Let me try to clarify the question. Looking at a pg_dump, I see the following: CREATE SEQUENCE public.customer_key_serial START

Re: A question about sequences and backup/restore cycles

2019-10-21 Thread Adrian Klaver
On 10/21/19 5:13 PM, stan wrote: I typically design a system with primary keys defined, like this: CREATE TABLE employee ( employee_key integer DEFAULT nextval('employee_key_serial') PRIMARY KEY , I use scripts to build the database structures and load the data. I am

A question about sequences and backup/restore cycles

2019-10-21 Thread stan
I typically design a system with primary keys defined, like this: CREATE TABLE employee ( employee_key integer DEFAULT nextval('employee_key_serial') PRIMARY KEY , I use scripts to build the database structures and load the data. I am careful to get the dependencies i