Re: sequence's plpgsql - Mailing list pgsql-general

From Tim McAuley
Subject Re: sequence's plpgsql
Date
Msg-id 3F74467E.5080303@tcd.ie
Whole thread Raw
In response to Re: sequence's plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>>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



pgsql-general by date:

Previous
From: Curtis Stanford
Date:
Subject: Re: Good way to insert/update when you're not sure of duplicates?
Next
From: Ron Johnson
Date:
Subject: Re: populate table with large csv file