Trigger question
От | Sandeep Joshi |
---|---|
Тема | Trigger question |
Дата | |
Msg-id | 3A3EA7F0.A6A6B86C@zambeel.com обсуждение исходный текст |
Ответ на | Re: question (Sandeep Joshi <sjoshi@Zambeel.com>) |
Список | 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
В списке pgsql-general по дате отправления: