Hi,
Does anyone know of anywhere to get Suse 10.1 RPMs of recent (8.2 and
8.3) versions of postgres?
The postgres website only has fredora and redhat ones listed, and using
rpmfind.net I can only find 8.0.13 ones for 10.0.
Thanks
Chris Coleman
Chris Coleman
not
capable of running from a CREATE CONSTRAINT TRIGGER command?
When the trigger is set up as a normal per row trigger then it executes
without any problems.
Many thanks
Chris
Chris Coleman
Programmer
Information Systems
Room PKL1 Phone 369
cheaper than trying to determine the data types by
querying the pg_catalog tables, and much cleaner assuming it is free
from any pitfalls...
Thanks again,
Chris
-Original Message-
From: Stuart Cooper [mailto:[EMAIL PROTECTED]
Sent: 14 March 2007 22:25
To: Chris Coleman
Cc: pgsql-general
on this, quote as
necessary.
Does anyone have any better suggestions of how to approach this problem?
Many thanks
Chris
Chris Coleman
Programmer
Information Systems
Room PKL1 Phone 369
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Th
Hi,
I'm no postgres guru and am not sure if this is the accepted way or not,
but:
CREATE OR REPLACE FUNCTION explode_array(in_array anyarray)
RETURNS SETOF anyelement AS
$BODY$
SELECT ($1)[s] FROM generate_series(1, array_upper($1, 1)) AS s;
$BODY$
LANGUAGE 'sql' IMMUTABLE;
ALTER FUNCTION e
ad against the wall for a good few hours now. I may be
slow to reply as I'm away tomorrow (Fri) but will respond to any answers
ASAP on Monday morning.
Many thanks,
Chris Coleman
//
// HOST logfile
//
@400045dd8f172d3b9cdc 2007-02-22 12:39:41
Hi,
I have done the below command and restarted the server and built my
triggers with the -g command using gcc, but I cannot seem to find any
core files nor any reference to where postgres may place them. Where
would they normally appear?
Cheers
Chris
Probably the easiest thing to do is make s
INFO line is prited directly beore the return statement at
the end of the first trigger.
Any information or ideas would be greatly appreciated.
Many Thanks
Chris Coleman
The code for the triggers is below:
(I have removed most of the app specific code from the triggers - but
the resutls are
ds
then it will have made some changes to one of my tables, however if
the after one fails some how (elog(ERROR, "")? then I would like to
rollback the changes of the before one as well as any made by the
after one too.
Is this possible?
Many thanks
Chris Coleman.