Re: [GENERAL] sequence's plpgsql

[Tim McAuley]

I see from a previous email on the list that someone was able to get 
decent debug out of the locks, i.e.


Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR:  deadlock detected
Aug 10 14:19:36 thunder postgres[18735]: [2-2] DETAIL:  Proc 18735 waits
for AccessExclusiveLock on relation 18028 of database 17140; blocked by
   

How can I get this?
   

This display is a new feature in 7.4.  Can you try your problem on a
7.4 beta release?
 

Ah, that would make sense.

Another question now. I am unable to compile Postgresql 7.4 beta 3 under 
cygwin (Windows 2K, using cgyipc 2).

I am getting the error:
"
creating information schema... ERROR:  end-of-copy marker does not match 
previous newline style
CONTEXT:  COPY FROM, line 361
"

Any ideas?

Thanks,

Tim



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend