[GENERAL] Postgres Disconnection problems

68030 slot busy. We could develop some kind of watchdog timer in the Daemon that handles the authorization but I was wondering if Postgres already have something similar built in. Any ideas ? Thanks /Otto Blomqvist ---(end of broadcast)---

[GENERAL] Problems with Set Returning Functions (SRFs)

ber1 from test)); ERROR: more than one row returned by a subquery used as an expression This is where I fail. Am I even on the right path here ? Writing the actual parsing function will be easy once I have a working concept. Any ideas ? Thanks a lot /Otto Blomqvist

[GENERAL] Setting all elements in an Bool[] array to the same value

Hello ! Is there any way to set all elements in a long boolean array (bool[]) to the same value ? update testbool set "all elements" = false;or so ? ;) Any ideas ? Thanks /Otto Blomqvist ---(end of broadcast)--- TIP 8: explain

[GENERAL] Custom C function shutdown-signaling

How do I signal a custom C function that the Postmaster wants to shut down ? I want to use "pg_ctl restart -mf" and not "pg_ctl restart -mi" because of data integrity concerns... Any ideas ? Thanks /Otto Blomqvist

Re: [GENERAL] Custom C function shutdown-signaling

Once again Tom comes threw and saves the day...! Thanks Tom ! /Otto Blomqvist "Tom Lane" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Otto Blomqvist" <[EMAIL PROTECTED]> writes: > > How do I signal a custom C function that t

[GENERAL] Adding miscadmin.h generates errors ?

After adding miscadmin.h to my source I get "some" errors, shown below. I'm sure its something simple like adding a flag or similar, but I'v spent hours on this now. Im running Fedora 3 and Postgres 8.0.3. GCC 3.4.3 20050227. Any ideas ? Thanks /Otto Blomqvist gcc -Wall -c

[GENERAL] Views + UNION ALL = Slow ?

data from multiple months so I created a view using Union all. But Using the view it takes 31 Seconds to complete the "same" query. I am obviously doing something wrong or using something the wrong way. Any Ideas ? /Otto Blomqvist test=# explain analyze select fid_2 from file_92_904 w

[GENERAL] Speed of pg_dump -l -s (List Schema) Variations

need to compare the schemes of about 20 tables and this takes a while... Anyone have any ideas ? I can't figure out why the newly created copy would be so much slower. Thanks /Otto Blomqvist ---(end of broadcast)--- TIP 6: Have you searched our

[GENERAL] pg_dump and pg_restore problems

s not exist" - message instead. But the table_25 is present in database1, it just seems like the dump does not see it, after a partial restore. Any ideas? Thanks /Otto Blomqvist ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Returning Errors from User Defined C-functions

n some Postgres log maybe ? I am not directly calling these functions, they are called from a Daemon, also written in C running on the same box. Any ideas ? Thanks a lot /Otto Blomqvist ---(end of broadcast)--- TIP 3: if posting/reading through Usen