determine the curval() of a view

Поиск
Список
Период
Сортировка
От John
Тема determine the curval() of a view
Дата
Msg-id 201003020735.42499.johnf@jfcomputer.com
обсуждение исходный текст
Список pgsql-sql
Hi,

I am working with a view that has a "_INSERT" rule.  I'm wondering if there is 
a way to determine what the curval() of the PK (serial type) after an insert 
occurs.  

Given the name of the view I'd like to determine the sequence associated with 
the view's PK.  Actually, I wonder if it is even possible to determine the PK 
from the view name.  I'm guessing that it might be possible because the view 
must be associated with a table/s.  And they will have PK's.

Any hints will be very helpful.


Johnf


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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: kind of RULE on SELECT depending on existence of a WHERE condition
Следующее
От: Louis-David Mitterrand
Дата:
Сообщение: check constraint on multiple tables?