[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

[GENERAL] Triggers and Multiple Schemas.

to achieve this ? Regards Paul Newman

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

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 level

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 Gonzales

[GENERAL] Anyone know of a Schema Comparer

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

[GENERAL] What to use for GUIDS ?

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

[GENERAL] guids / bytea and index use ?

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

[GENERAL] triggers using the correct schema ..

= 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] 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 ?

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