On Wed, Jan 25, 2012 at 09:42:05AM -0430, Francisco Calderón wrote:
> Hello,
>
> I am having a situation with postgresql 8.3, i have two tables, ta and tb,
> with a relation "one tb has many ta" and... well, i will let the SQL talk
> for me ;)
>
> ---SQL---
> CREATE TABLE tb
> (
>
Hello,
This is a normal behaviour of the sequence. In case of rollback, a sequence
is never decremented. Read the note at the end of this page for more info :
http://www.postgresql.org/docs/8.1/static/functions-sequence.html
Regards,
Brice
2012/1/25 Francisco Calderón
> Hello,
>
> I am having
Hello,
I am having a situation with postgresql 8.3, i have two tables, ta and tb,
with a relation "one tb has many ta" and... well, i will let the SQL talk
for me ;)
---SQL---
CREATE TABLE tb
(
id serial NOT NULL,
descripcion character varying(200) NOT NULL,
CONSTRAINT tb_pk
