Karl O. Pinc wrote: > > On 04/19/2007 08:41:55 AM, Karl O. Pinc wrote: > > >I would like to submit a patch so that the > >COPY statement can import data into a view. > > >2) Allocate memory for char* and construct an > >'INSERT ...' statement corresponding > >to the COPY command that inserts into the view. > >(Just how much memory should be allocated? > >Is there a standard buffer pre-alocated somewhere or a > >standard buffer size?) > > I'll use a StringInfo. > > And I forgot, the final step is to add regression > tests. One for view with an INSERT rule and one > to catch the error for a view without an INSERT rule.
I'm not sure the plan is OK as stated. You wouldn't want to force to parse the query again for each row. Rather, create a prepared statement (already parsed, because you obtain it from the parsetree stored in the INSERT rule) to pass to the executor. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match