Tom Lane wrote:
Michael Akinde writes:
Tom Lane wrote:
In the past we've seen this type of thing caused by multithreaded
client programs in which more than one thread tried to use the same
PGconn object without adequate interlocking.
Our application is single-threaded,
Tom Lane wrote:
Michael Akinde writes:
Anyway - the situation now is that just the loading process is hanging
on the server, with an in transaction. But it is definitely the
loading program that is hanging, not the Postgres server.
What the stack traces seem to show is that both
Tom Lane wrote:
Hmm, can you attach to the stuck backend and the vacuum worker process
with gdb and get stack traces from them? The pg_locks view does not
indicate any locking problem, but I'm wondering if there could be a
deadlock at the LWLock level.
My reply seems to have been lost in the eth
Hej,
I killed the test about an hour ago to eliminate the free space stuff as
an issue. I've started the process up again, so if (when) the test hangs
again, I'll try to get the stack trace.
Regards,
Michael Akinde
Tom Lane wrote:
Michael Akinde writes:
We have been runn
n the production systems, so I assume that this is not the problem here
either (will fix it for future test runs, though).
Regards,
Michael Akinde
begin:vcard
fn:Michael Akinde
n:Akinde;Michael
org:Meteorologisk Institutt, Norge;IT
adr;quoted-printable:;;Gaustadall=C3=A9en 30D;Oslo;;0313;Norge
Thanks, though that was an error caused by my attempt to copy-paste some
readable example of code from the source file.
Matching the correct _out functions in the DirectFunctionCall fixed the
segmentation fault problems I was seeing.
Regards,
Michael A.
Tom Lane wrote:
Michael Akinde
Martijn van Oosterhout wrote:
On Wed, Dec 19, 2007 at 04:40:38PM +0100, Michael Akinde wrote:
As I understand it, I should be able to do something like (assuming
"time" is the attribute name):
bool isNull;
HeapTupleHeader t = DatumGetHeapTupleHeader(row);
Hi,
I need to extract a text string representation of a timestamp from a
user-defined row type; e.g., from the composite type ('1980-01-01
12:00:00', 'Random Comment'), I'd like to extract the C string
1980-01-01 12:00:00 in my user-defined C function.
As I understand it, I should be able to
