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
On Wed, Aug 16, 2006 at 05:01:09PM +0530, Penchalaiah P. wrote:
> If again I pass correct values to that function that values can see in
> view data with increment value of sequence
>
>
> Any one can tell me how to stop that sequence value when ever I was
> passing wrong values to that function..
Hi good evening every one………
I have a problem with sequence ..
I created one sequence with the name of famaseq..
I am using this sequence in my function..
This is the function
Create or replace function getFamanewcase1(in_cda_no
varchar,in_dak_id varchar,in_name_of_beneficia
