Trigger/Sequence headache

Поиск
Список
Период
Сортировка
От Foster, Stephen
Тема Trigger/Sequence headache
Дата
Msg-id 000801c63023$8e0af830$2101a8c0@cfgod
обсуждение исходный текст
Ответы Re: Trigger/Sequence headache
Список pgsql-sql

This is going to be one of those stupid problems of mine.  I have an insert trigger setup to verify that duplicate or repeating information isn’t storage in the table.  If trigger function finds the information as a duplicate it returns a NULL and the information isn’t added; that works.  The problem I’m having is that it is incrementing the sequence counter even when the data isn’t added.  Is this something that I have to live with or should I be returning something other than a NULL?

 

I have a function to re-sequence the table and reset the sequence counter in another application.  Normal for that application because of the constant adding and deleting.  So if there isn’t another answer then I can write a version of that for this application and run it weekly/monthly depending on need and use.  It just drives me nuts with large holes in the table.

 

Thanks

 

Lee Foster/

В списке pgsql-sql по дате отправления: