Re: [GENERAL] flock user defined function

2004-06-22 Thread Chris Goughnour
Thanks. Yeah, I figured that out after Martijn's response. I'm just returning the file descriptor from lockFile, passing it to unlockFile and closing the descriptor there. It works fine now. Thanks for edifying a clueless novice such as myself. :-) > Chris Goughnour <[EMAIL PR

[GENERAL] flock user defined function

2004-06-22 Thread Chris Goughnour
call unlockfile from the first psql process, the second process still blocks. The lockfile call from the second psql proccess doesn't return until I kill the first psql process. Any suggestions? Thanks in advance. Chris Goughnour PG_FUNCTION_INFO_V1(lockFile); Datum lockFile(PG_FUNCTION_ARGS){