Re: [SQL] SQL state 58P01 triggered by a database script execution

teger, OUT level integer, OUT fastroot integer, OUT fastlevel integer) RETURNS record AS '$libdir/pageinspect', 'bt_metap' LANGUAGE c STRICT; " Can I comment those lines to remove the error ? 2009/12/9 A. Kretschmer > In response to aymen marouani : > &

[SQL] SQL state 58P01 triggered by a database script execution

Hi, I have a database under Postgres v8.3 and I generated its backups script using PGAdmin III. I executed the same script under Postgres v8.2 in order to create the same database but I get the following error " ERROR: could not access file "$libdir/pageinspect": No such file or directory SQL s

Re: [SQL] Profiling tool for postgres under win32

tion about profiling because of a slow simple query "SELECT i FROM Item i" which takes 4s to execute. Cordially and best regards. 2009/11/26 Craig Ringer > On 26/11/2009 5:48 PM, aymen marouani wrote: > > Hi, > > I'm using the Postgres database system version 8.3

[SQL] How to start the "auto_explain" module

Hi, In order to profile my Postgres queries, I used the "auto_explain.lo g_min_duration (integer)". How can I load the auto_explain module ? Thanks in advance.

[SQL] Profiling tool for postgres under win32

Hi, I'm using the Postgres database system version 8.3 for a J2EE application. I'd like to profile and monitor in "real time" the status of my queries because I notice some slow loading. Can anyone tell how to get a "good" profiling tool for the Postgres database system ? Thanks in advance.

[SQL] Question

Hi for all, What is the possible sources of the SQLState 55000 "OBJECT NOT IN PREREQUISITE STATE" ? The error 55000 was triggered when I executed the following query : "select currval('"BatchTreatment_batch_treatment_id_seq"');" Thanks in advance. Cordially.

[SQL] Question

Hi for all, What is the possible sources of the SQLState 55000 "OBJECT NOT IN PREREQUISITE STATE" ? The error 55000 was triggered when I executed the following query : "select currval('"BatchTreatment_batch_treatment_id_seq"');" Thanks in advance. Cordially.