[GENERAL] Running Total with a Set Maximum

you Paul Newman Disclaimer This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such

Re: [GENERAL] Triggers and Multiple Schemas.

Hi Michael, Haven't tried it yet .. but THANK YOU ! I will try it later today assuming it works it will say us a LOT of maintenance! Regards Paul Newman -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: 08 March 2006 23:48 To: Paul Newman Cc: Louis Gon

Re: [GENERAL] database/schema level triggers?

Hi, This is precisely what I'm after .. could you possibly give me an example ? Kind Regards Paul Newman -Original Message- From: Jim Nasby [mailto:[EMAIL PROTECTED] Sent: 08 March 2006 22:18 To: Michael Glaesemann Cc: Tomi NA; pgsql-general Subject: Re: [GENERAL] database/schema

Re: [GENERAL] Triggers and Multiple Schemas.

are doing this is to have resource and connection pooling (therefore scalability) for many of our clients who run our system. So how can I get the schema name of the calling table trigger and use it in the form of set Search_path at the beginning of the function ? Regards Paul Newman

[GENERAL] Triggers and Multiple Schemas.

for us to achieve this ?   Regards   Paul Newman

[GENERAL] Anyone know of a Schema Comparer

EMS comparer and few others but all seem to compare one entire db with another.   Regards   Paul Newman

[GENERAL] What to use for GUIDS ?

column type ?? What is going to give us the best performance (with 8.1) ?   Thank You   Paul Newman

[GENERAL] triggers using the correct schema ..

search_path = “schema_x”; in the front of each trigger … but we use a script to generate these schemas so means doing a search and replace for each creation that we do. Is there a CURRENT SCHEMA type of command such that we could do …. Set search_path = CURRENT SCHEMA ?   Thanks Paul Newman

[GENERAL] guids / bytea and index use ?

to store guids ? We don’t have any experience in recompiling the postgres source code etc.   Thanks   Paul Newman

[GENERAL] Inserting a record into another table ... inside a schema

update the base table in schema “MySchema” the trigger tries to insert/update a record in the public schema and not the “Current” schema (ie the schema of the original table). Is there a system variable for “Current Schema” ? …. If not what is the best way to achieve this ?   Thanks Paul Newman

[GENERAL] New to Schemas - Good for Multi Company in one DB ?

against each schema ?   I would realy appreciate someones help with this asap …..   Thanks   Paul Newman (Development Director – Tripoint Ltd)