Postgres Pro
Downloads
Home   >   mailing lists

call analyze from stored procedure in C - Mailing list pgsql-novice

From Ulli Mueckstein
Subject call analyze from stored procedure in C
Date
Msg-id Pine.LNX.4.44.0304031329250.10673-100000@mescalin.tbi.univie.ac.at
Whole thread Raw
Responses ERROR: More than one tuple returned by a subselect used as an expression.  ("Mel Jamero" <mel@gmanmi.tv>)
List pgsql-novice
Tree view 
Hi everybody!

I have to insert a lot of data (more than 1.000.000 rows) in various
tables. I use stored procedures in C to insert the data. It is necessary
to run ANALYZE after inserting a some thousand rows into a table. Can
someone tell me how to call ANALYZE
(or analyze_rel(Oid relid, VacuumStmt *vacstmt))
from a C stored procedure ? Any help would be appreciated.

Thanks

Ulli Mueckstein

--

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: errors using COPY from MySQL data
Next
From: "Mel Jamero"
Date:
Subject: ERROR: More than one tuple returned by a subselect used as an expression.