Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert into VIEW using RULE. Not possible to use nextval()? - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Insert into VIEW using RULE. Not possible to use nextval()?
Date
Msg-id 662419.466.qm@web31804.mail.mud.yahoo.com
Whole thread Raw
In response to Insert into VIEW using RULE. Not possible to use nextval()?  ("Collin Peters" <cadiolis@gmail.com>)
Responses Re: Insert into VIEW using RULE. Not possible to use nextval()?
List pgsql-sql
Tree view 
--- Collin Peters <cadiolis@gmail.com> wrote:

> I am having the same problem that is documented elsewhere in the
> archives.  Namely when you have a INSERT RULE on a VIEW the nextval()
> function doesn't behave properly (or it doesn't behave how I'd like it
> to).
> 
> http://archives.postgresql.org/pgsql-sql/2003-07/msg00333.php
> 

Is your problem that you can't insert more than one record at a time into your INSERTable VIEW?

pgsql-sql by date:

Previous
From: "Collin Peters"
Date:
Subject: Insert into VIEW using RULE. Not possible to use nextval()?
Next
From: "Collin Peters"
Date:
Subject: Re: Insert into VIEW using RULE. Not possible to use nextval()?