[GENERAL] determine database and tables from deadlock

2011-05-30 Thread Machiel Richards
Hi Everyone Some of our databases have been experiencing a sudden spike in deadlocks being detected. as far as our knowledge is concerned, there have not been any new code taken live and no changes from what are aware off. The databases are running postgresql 8.1 From the log

[GENERAL] Postgresql database procedures?

2010-08-04 Thread Machiel Richards
Good day all I am looking for some info / resources where I can learn how to write database procedures, functions,etc? I am a total newbie to this and will need to learn from scratch Would appreciate the help a lot Machiel

Re: [GENERAL] Data dumps to files - best methods?

2010-07-26 Thread Machiel Richards
on their side, still trying to understand why though... Is there a method of outputting / dumping the data into .xml format as part of the scripts / crons/ db processes? Machiel Richards MySQL DBA Email: machi...@rdc.co.za Tel: 0861 732 732 RDC_Logo From: pgsql

Re: [GENERAL] Data dumps to files - best methods?

2010-07-23 Thread Machiel Richards
Thank you very much, I think this will help a lot. Will ask for more details once I receive the full specs,etc... Machiel Richards MySQL DBA Email: machi...@rdc.co.za Tel: 0861 732 732 RDC_Logo From: Ralf Schuchardt [mailto:r...@gmx.de] Sent: 23 July 2010 01:37 PM To

[GENERAL] Data dumps to files - best methods?

2010-07-23 Thread Machiel Richards
Good day all As I am fairly new to postgresql I am trying to find some more info regarding options to dump specific data to files. Let me give you guys some idea on what I mean by this Currently there is a java/perl process that runs and creates datadumps for clien

[GENERAL] Variables in SQL scripts

2010-06-10 Thread Machiel Richards
Good day all I have posted a query on the Postgresql novice mailing list, however I think it might be more suitable here. Please see my request and information below: I am looking for some more suggestions here on ways to use variables in sql scr