[GENERAL] The scope of sequence

2011-02-25 Thread Zhi-Qiang Lei
Dear All, I've got a composite key in a table. The keys are ID and owner ID. The type of the ID should be a serial, additionally I hope the ID to be increasable per owner ID. ( The ID will be increased with the different owner ID) Does anyone know how to implement it? Thanks in advance. Best

Re: [GENERAL] The scope of sequence

2011-02-25 Thread David Johnston
] On Behalf Of Zhi-Qiang Lei Sent: Friday, February 25, 2011 8:10 AM To: pgsql-general@postgresql.org Subject: [GENERAL] The scope of sequence Dear All, I've got a composite key in a table. The keys are ID and owner ID. The type of the ID should be a serial, additionally I hope the ID to be increasable