Re: [GENERAL] SLEEP in posgresql

2007-10-10 Thread Michal Taborsky - Internet Mall
Jasbinder Singh Bali napsal(a): Instead of that, I re-engineered my while loop in the stored procedure as follows. ... I was wondering how to implement the SLEEP functionality here. Hello. I can't comment the function itself, but I want to bring something else to your attention. Note, that

Re: [GENERAL] Storing files in postgres db

2006-12-04 Thread Michal Taborsky - Internet Mall
Hello Tam Wei, tam wei wrote: I am intending to store the files inside the postgres DB using the type text (all the files will be pre-encode into base64. The reason for not using the type bytea as I encountered some undesired format(the original file alignment can't be preserved) while

[GENERAL] LOCK ... NOWAIT throws error

2006-11-29 Thread Michal Taborsky - Internet Mall
Hello. We started using, in one of our applications, the LOCK ... NOWAIT functionality. It works as it's supposed to, but there is one, albeit tiny, annoyance about it. When the LOCK cannot be immediately obtained, this statement logs an ERROR message. But in this case, I think it is not