[GENERAL] How to use rollback in function with 'pgsql'?

2005-07-12 Thread Nee.mem()
pgsql-general: How to use rollback in function with 'pgsql'? Nee.Mem       2005-07-13 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

[GENERAL] Transaction Handling in pl/pgsql?

2005-07-12 Thread Nee.mem()
pgsql-general,    On 7/12/05, Craig Bryden postgresql ( at ) bryden ( dot ) co ( dot ) za wrote: Hi I am trying to get a better understanding of how transactions work in pl/pgsql functions. I found the following text in the help: It is important not to confuse the use of BEGIN/END

[GENERAL] can you tell me how to use rollback work in 'pgsql' function? and give me a exsample?

2005-07-13 Thread Nee.mem()
i see you wrote on this page http://archives.postgresql.org/pgsql-general/2005-07/msg00319.php test exsample: create or replace function test() returns void as ' begin delete from regiondata; rollback; end;

Fw: Re: [GENERAL] Windows version of PostgreSQL 8?

2005-07-13 Thread Nee.mem()
of broadcast)--- TIP 6: explain analyze is your friend = = = = = = = = = = = = = = = = = = = = 致 礼! Nee.mem(倪明) [EMAIL PROTECTED]   2005-07-13 ---(end of broadcast)--- TIP 1: if posting/reading