Re: Best practice for naming temp table trigger functions

Поиск
Список
Период
Сортировка
От Sebastien Flaesch
Тема Re: Best practice for naming temp table trigger functions
Дата
Msg-id DBAP191MB12891233EFFBA6A4CC30E420B0099@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Best practice for naming temp table trigger functions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Best practice for naming temp table trigger functions  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
Список pgsql-sql

Would it make sense (seems possible!) to create the trigger function in the pg_my_temp_schema() schema ?

create function pg_temp_4.TT1_SRL() returns trigger ...

Same question for sequences... (used in my triggers)

Background: All this stuff is to mimic Informix-style SERIALs.

If PostgreSQL native serial would have options to behave like Informix serial, we would not need triggers on our tables.

With Informix serial/bigserial:
  • INSERT with zero value specified for serial column generates a new serial value from underlying sequence.
  • INSERT with non-zero value specified for serial column sets that value and automatically increments the underlying sequence.
Seb

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

Предыдущее
От: "Voillequin, Jean-Marc"
Дата:
Сообщение: RE: unique index with several columns
Следующее
От: Sebastien Flaesch
Дата:
Сообщение: Re: Best practice for naming temp table trigger functions