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 по дате отправления:

Предыдущее
От: Tulio Oliveira
Дата:
Сообщение: Trigger running with "postgres" superuser permissions
Следующее
От: Tulio Oliveira
Дата:
Сообщение: src/Makefile.global