[GENERAL] Using composite types within PLPGSQL Function

, version of PostgreSQL is 8.4 under Debian. Thanks Graeme -- Graeme Hinchliffe Senior Systems Designer, Zen Internet T: 0845 058 9000 F: 0845 058 9005 W: zen.co.uk BT have increased their monthly phone line rental to ?15.45 per month. Our remains at ?11.22. Switch now : http://www.zen.co.uk

[GENERAL] Massive slowdown when LIMIT applied

ase)Now, if I do the following:SELECT username,acctstarttime FROM radacct WHERE username='user' ORDER BY acctstarttime LIMIT 50;I have to wait a very long time, IE instead of 2-3 seconds.. can be as slow as 10+ minutes.this seems very odd to me, any ideas?Thanks in advance.-Graem

[GENERAL] Inserting a record data type into a table

table. Thanks -- - Graeme Hinchliffe (BSc) Core Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main : 0845 058 9000 Fax : 0845 058 9005 signature.asc Description: This is a digitally signed message part

Re: [GENERAL] string is sometimes null ?

t in just var1var3 ? Many thanks for your help -- ----- Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main : 0845 058 9000 Fax : 0845 058 9005 ---(end of broadcast)--- TIP 3: i

[GENERAL] string is sometimes null ?

e of the variables were null that it would have complained about a malformed SQL query but this is saying the string is NULL! any ideas help much appreciated, thanks. -- - Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main

[GENERAL] tg_relation doesn't seem to have the attribute names!

relation of the table. please help. thanks -- - Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main : 0845 058 9000 Fax : 0845 058 9005 ---(end of broadcast)--- TIP 8: e

Re: [GENERAL] detecting a dead db not seeming to work

On Thu, 2004-08-26 at 15:57, Tom Lane wrote: > Graeme Hinchliffe <[EMAIL PROTECTED]> writes: > > However one of the tests I performed was to kill -9 the postmaster > > process to see how it would handle that (assuming the same behaviour). > > However nothing h

[GENERAL] detecting a dead db not seeming to work

ing on? or suggestions? Thanks -- ----- Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main : 0845 058 9000 Fax : 0845 058 9005 ---(end of broadcast)--- TIP 1: subscribe and u

[GENERAL] Catching server shutdown in C

there a way that I can catch a server shutdown/connection loss cleanly? I did a quick search of the mailling list but didn't see anything. Thanks for your help -- ----- Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main

[GENERAL] pl/pgsql trigger table attributes

less hacky and ikky solution than this if possible. Anyone got any suggestions? Thanks Graeme Hinchliffe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster