determine the curval() of a view - Mailing list pgsql-sql

From John
Subject determine the curval() of a view
Date
Msg-id 201003020735.42499.johnf@jfcomputer.com
Whole thread Raw
List 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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: kind of RULE on SELECT depending on existence of a WHERE condition
Next
From: Louis-David Mitterrand
Date:
Subject: check constraint on multiple tables?