From: | Sandeep Joshi <sjoshi(at)Zambeel(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>, Sandeep Joshi <sjoshi(at)Zambeel(dot)com>, Alfred Perlstein <bright(at)wintelcom(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Trigger question |
Date: | 2000-12-19 00:12:32 |
Message-ID: | 3A3EA7F0.A6A6B86C@zambeel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
When I start my postmaster with "-i" option I get following error while trying
to connect to other
databae.
FATAL: StreamServerPort: bind() failed: Address already in use
Is another postmaster already running on that port?
If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
/work/posgresql/bin/postmaster: cannot create UNIX stream port
any hints, remarks?
I understand what I am trying to do is POSSIBLE but has anybody really tried it?
regards,
Sandeep
>
>
> Hi,
> I reduced my trigger to do following :
>
> (Trigger gets invoked for Table1 in Db1)
>
> 1. conn=PQconnectdb ( db2 )
> 2. PQexec(conn,"begin") <--- FAILS
> 3. PQfinish(conn)
>
> I get failure in step (2) with following message in 'postmaster.log'
>
> ERROR: begin
> pq_recvbuf: unexpected EOF on client connection
>
> I don't know what does this means. If anybody is interested I can mail the ".c"
> file.
>
> Is support for trigger better in 7.1 ? where do I get the 7.1?
>
> regards,
> sandeep
From | Date | Subject | |
---|---|---|---|
Next Message | Tulio Oliveira | 2000-12-19 00:58:38 | src/Makefile.global |
Previous Message | Tom Lane | 2000-12-18 23:31:05 | Re: Re: a "huge" table with small rows and culumns |