Re: [GENERAL] SERIAL error

2004-11-27 Thread mstory
My mistake, in the future i will consult the FAQ first, though i'm a bit surprised i missed it in the documentation. Much thanks for the help. By generic uses i guess i meant the uses one might have for creating a sequence as an independant object in the database, and not the sequence in a table,

Re: [GENERAL] SERIAL error

2004-11-27 Thread Joseph Healy
Hi, On Sat, Nov 27, 2004 at 10:45:54PM -0600, [EMAIL PROTECTED] wrote: > > I'm using v. 7.4.2, and am encountering a problem with serial types. On an > insert into a table that results in failure for any number of reasone (mostly > violation of contraints) I've found that the Sequence for the co

Re: [GENERAL] SERIAL error

2004-11-27 Thread Stephan Szabo
On Sat, 27 Nov 2004 [EMAIL PROTECTED] wrote: > > I'm using v. 7.4.2, and am encountering a problem with serial types. On an > insert into a table that results in failure for any number of reasone (mostly > violation of contraints) I've found that the Sequence for the column of type > serial will

Re: [GENERAL] SERIAL error

2004-11-27 Thread Michael Fuhr
On Sat, Nov 27, 2004 at 10:45:54PM -0600, [EMAIL PROTECTED] wrote: > > I'm using v. 7.4.2, and am encountering a problem with serial types. On an > insert into a table that results in failure for any number of reasone (mostly > violation of contraints) I've found that the Sequence for the column

Re: [GENERAL] SERIAL error

2004-11-27 Thread Mike Mascari
[EMAIL PROTECTED] wrote: I'm using v. 7.4.2, and am encountering a problem with serial types. On an insert into a table that results in failure for any number of reasone (mostly violation of contraints) I've found that the Sequence for the column of type serial will still bump the value up once. T

[GENERAL] SERIAL error

2004-11-27 Thread mstory
I'm using v. 7.4.2, and am encountering a problem with serial types. On an insert into a table that results in failure for any number of reasone (mostly violation of contraints) I've found that the Sequence for the column of type serial will still bump the value up once. This can be seen when en