Re: [BUGS] Postgres 7.4.6 hang in async_notify

2005-04-25 Thread Tom Lane
[EMAIL PROTECTED] writes: > We have seen this twice. The first time, it was on a 32 bit Fedora > Core 3 system during a `postgres stop`. The stop hung because one of > the processes was in async_notify and refused to get out. We were > unable to do further debugging because the db was in shutdow

Re: [BUGS] Postgres 7.4.6 hang in async_notify

2005-04-25 Thread pgsql-bugs
In message <[EMAIL PROTECTED]>, Alvaro Herrera writes: On Mon, Apr 25, 2005 at 03:42:35PM -0400, [EMAIL PROTECTED] wrote: > The way the notify gets called is a bit convoluted. Our C program > performs an insert in table T. Some triggers run doing all sorts of > stuff in the

Re: [BUGS] Postgres 7.4.6 hang in async_notify

2005-04-25 Thread Alvaro Herrera
On Mon, Apr 25, 2005 at 03:42:35PM -0400, [EMAIL PROTECTED] wrote: > The way the notify gets called is a bit convoluted. Our C program > performs an insert in table T. Some triggers run doing all sorts of > stuff in the background involving changes to other tables. Under some > circumstances, a

[BUGS] Postgres 7.4.6 hang in async_notify

2005-04-25 Thread pgsql-bugs
We have seen this twice. The first time, it was on a 32 bit Fedora Core 3 system during a `postgres stop`. The stop hung because one of the processes was in async_notify and refused to get out. We were unable to do further debugging because the db was in shutdown. We were forced to kill -9 the

Re: [BUGS] BUG #1624: connect uses properties before URL

2005-04-25 Thread Kris Jurka
On Mon, 25 Apr 2005, Tom Donovan wrote: > Bug reference: 1624 > Logged by: Tom Donovan > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8-0-311 > Description:connect uses properties before URL > Details: > > The JDBC DriverManager calls connect() in all loade

Re: [BUGS] BUG #1623: COPY and unicode

2005-04-25 Thread Bruce Momjian
Diarmaid Foley wrote: > > The following bug has been logged online: > > Bug reference: 1623 > Logged by: Diarmaid Foley > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.1 > Operating system: Windows XP professional > Description:COPY and unicode > Details:

[BUGS] BUG #1624: connect uses properties before URL

2005-04-25 Thread Tom Donovan
The following bug has been logged online: Bug reference: 1624 Logged by: Tom Donovan Email address: [EMAIL PROTECTED] PostgreSQL version: 8-0-311 Operating system: Windows 2000 Description:connect uses properties before URL Details: The JDBC DriverManager calls conn

[BUGS] BUG #1623: COPY and unicode

2005-04-25 Thread Diarmaid Foley
The following bug has been logged online: Bug reference: 1623 Logged by: Diarmaid Foley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows XP professional Description:COPY and unicode Details: The COPY command for loading data does

Re: [BUGS] BUG #1610: rewrite rule and sequence

2005-04-25 Thread Olleg Samoylov
Richard Huxton wrote: Hmm - perhaps the documentation needs expanding. Certainly, if your view references functions you need to make sure permissions are set correctly on those. How about changes along the lines of: Ch 33.4, para 2 "... Relations that are used due to rules get checked against th