Re: [BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-17 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > This looks a lot like bug #2829 (excep that one is Windows), as I > mentioned here: > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00461.php > Haven't looked into the actual code, though, but Tom had a suggestion in > the original bug, but AF

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Bruce Momjian
Tom Lane wrote: > Well, let's be clear: this is entirely the fault of the inet type not > accepting what we now know to be RFC-compliant address specifications. > So we ought to put fixing that on the TODO list. It's not happening > for 8.3 though, let alone in existing release branches, so we'd b

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Thu, May 17, 2007 at 02:39:55PM -0400, Tom Lane wrote: >> It seems the correct solution here is to extend the inet type to support >> RFC4007 "zone_id" strings. Yech. Not going to happen as a bug fix, >> but we should probably put it on the TODO li

Re: [HACKERS] [BUGS] Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

2007-05-17 Thread Bruce Momjian
Added to TODO: --- Alvaro Herrera wrote: > Bruce Momjian wrote: > > > > Is there a TODO here? > > Yes, I think so: > > * Implement the SQL standard mechanism whereby REVOKE ROLE only revokes > the privilege as granted b

Re: [BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-17 Thread Bruce Momjian
Added to TODO: * Fix problem with excessive logging during SSL disconnection http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php --- Peter Koc

Re: [HACKERS] [BUGS] Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

2007-05-17 Thread Alvaro Herrera
Bruce Momjian wrote: > > Is there a TODO here? Yes, I think so: * Implement the SQL standard mechanism whereby REVOKE ROLE only revokes the privilege as granted by the invoking role, and not those granted by other roles -- Alvaro Herrerahttp://www.CommandPr

Re: [HACKERS] [BUGS] Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

2007-05-17 Thread Bruce Momjian
Is there a TODO here? --- Russell Smith wrote: > Alvaro Herrera wrote: > > Russell Smith wrote: > > > >> Alvaro Herrera wrote: > >> > >>> Alvaro Herrera wrote: > >>> > >>> > >>> > 2. decide that the sta

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Christian Kratzer <[EMAIL PROTECTED]> writes: > It's not that simple though. The ipv6 stack will propably not allow > users to build sockets from addresses in link local scope from a > specific interface to a server bound to a global address, ::1, or > scoped to any other interface. After all li

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Christian Kratzer <[EMAIL PROTECTED]> writes: > On Thu, 17 May 2007, Tom Lane wrote: >> As a temporary workaround, should we hack the server to suppress any >> %-foo found in the result of getnameinfo()? > Not sure what that would buy us. Mostly, it would buy us not having pg_stat_activity fail c

Re: [BUGS] BUG #3288: Select command giving error

2007-05-17 Thread Magnus Hagander
Srinivas wrote: > The following bug has been logged online: > > Bug reference: 3288 > Logged by: Srinivas > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2 > Operating system: Win XP > Description:Select command giving error > Details: > > Hi, We are using

Re: [BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-17 Thread Magnus Hagander
This looks a lot like bug #2829 (excep that one is Windows), as I mentioned here: http://archives.postgresql.org/pgsql-hackers/2007-05/msg00461.php Haven't looked into the actual code, though, but Tom had a suggestion in the original bug, but AFAIK nobody has done that yet (at least not me.:) //M

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Tom Lane wrote: It seems the correct solution here is to extend the inet type to support RFC4007 "zone_id" strings. Yech. Not going to happen as a bug fix, but we should probably put it on the TODO list. propably yes. But we should bear in mind that addresses of dif

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Thu, May 17, 2007 at 02:39:55PM -0400, Tom Lane wrote: > It seems the correct solution here is to extend the inet type to support > RFC4007 "zone_id" strings. Yech. Not going to happen as a bug fix, > but we should probably put it on the TODO list. > > As a temporary workaround, should we hac

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Andrew Sullivan wrote: On Thu, May 17, 2007 at 07:29:47PM +0200, Christian Kratzer wrote: supporting scoped addresses could have their uses but then again theres nothing stopping you to bind multiple global ipv6 addresses to your loopback interface which would work fin

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Thu, May 17, 2007 at 06:42:39PM +0200, Christian Kratzer wrote: >> of a specific interface. This is why bsd based oprating systems append >> %ifname to the address so that they know which Interface this address > Oh, I forgot about that wart in RF

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Thu, May 17, 2007 at 07:29:47PM +0200, Christian Kratzer wrote: > supporting scoped addresses could have their uses but then again > theres nothing stopping you to bind multiple global ipv6 addresses > to your loopback interface which would work fine for disconnected > setups and it might be a b

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Andrew Sullivan wrote: On Thu, May 17, 2007 at 06:42:39PM +0200, Christian Kratzer wrote: of a specific interface. This is why bsd based oprating systems append %ifname to the address so that they know which Interface this address Oh, I forgot about that wart in RFC4

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Christian Kratzer
Hi, On Thu, 17 May 2007, Tom Lane wrote: Andrew Sullivan <[EMAIL PROTECTED]> writes: On Mon, May 14, 2007 at 08:32:21PM -0600, Brian Hirt wrote: I have postgresql installed on a mac, and I'm connecting from another mac on the network using ip6. When I try to select out of pg_stat_activity

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Thu, May 17, 2007 at 06:42:39PM +0200, Christian Kratzer wrote: > of a specific interface. This is why bsd based oprating systems append > %ifname to the address so that they know which Interface this address Oh, I forgot about that wart in RFC4007. Thanks for the cluestick. > There is prop

Re: [BUGS] ON DELETE CASCADE with multiple paths

2007-05-17 Thread Stephan Szabo
On Thu, 17 May 2007, Tom Lane wrote: > Max Khon <[EMAIL PROTECTED]> writes: > > "delete from foo" fails: > > > ERROR: update or delete on table "bar" violates foreign key constraint > > "foobar_fk0" on table "foobar" > > SQL state: 23503 > > Detail: Key (bar_id)=(1) is still referenced from table

Re: [BUGS] BUG #3266: SSL broken pipes kill the machine and fill the disk

2007-05-17 Thread Bruce Momjian
I didn't see any comment on this. Seems like a problem. --- Peter Koczan wrote: > > The following bug has been logged online: > > Bug reference: 3266 > Logged by: Peter Koczan > Email address: [EMAIL PR

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Mon, May 14, 2007 at 08:32:21PM -0600, Brian Hirt wrote: >> I have postgresql installed on a mac, and I'm connecting from another >> mac on the network using ip6. When I try to select out of >> pg_stat_activity i get this error. I suspect the

Re: [BUGS] strange problem with ip6

2007-05-17 Thread Andrew Sullivan
On Mon, May 14, 2007 at 08:32:21PM -0600, Brian Hirt wrote: > I have postgresql installed on a mac, and I'm connecting from another > mac on the network using ip6. When I try to select out of > pg_stat_activity i get this error. I suspect the %en0 has something > to do with the problem, b

Re: [BUGS] ON DELETE CASCADE with multiple paths

2007-05-17 Thread Tom Lane
Max Khon <[EMAIL PROTECTED]> writes: > "delete from foo" fails: > ERROR: update or delete on table "bar" violates foreign key constraint > "foobar_fk0" on table "foobar" > SQL state: 23503 > Detail: Key (bar_id)=(1) is still referenced from table "foobar". > Context: SQL statement "DELETE FROM ONL

[BUGS] ON DELETE CASCADE with multiple paths

2007-05-17 Thread Max Khon
Hi! Suppose the following schema: create table foo(foo_id integer primary key); create table bar(bar_id integer primary key, foo_id integer, constraint bar_fk0 foreign key (foo_id) references foo(foo_id) on delete cascade); create table foobar(foobar_id serial primary key, foo_id integer,

Re: [BUGS] BUG #3289: SIN(PI()) expected to return 0, but returns garbage

2007-05-17 Thread Heikki Linnakangas
Daniel Kastenholz wrote: Type in SELECT SIN(PI()) Expected output: 0 Actual output: * Windows, using 8.2.4: garbage (-2.2..) * Linux, using 8.1: garbage (1.22...) -- Comments: SIN(3.1414) and SIN(3.1417) come close to 0 and work on both platforms. SIN(3.1415) and SIN(3.1416) prod

[BUGS] BUG #3289: SIN(PI()) expected to return 0, but returns garbage

2007-05-17 Thread Daniel Kastenholz
The following bug has been logged online: Bug reference: 3289 Logged by: Daniel Kastenholz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1, 8.2.4 Operating system: Linux, Windows Description:SIN(PI()) expected to return 0, but returns garbage Details: Troub

[BUGS] BUG #3286: psqlodbc not able to connect

2007-05-17 Thread Aravind C
The following bug has been logged online: Bug reference: 3286 Logged by: Aravind C Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP on VMWare Description:psqlodbc not able to connect Details: My Host os is Windows XP with Postg

[BUGS] BUG #3287: I cann't instal postgres sql in windows vista

2007-05-17 Thread Siva
The following bug has been logged online: Bug reference: 3287 Logged by: Siva Email address: [EMAIL PROTECTED] PostgreSQL version: postgresql-8.1 Operating system: Windows vista Description:I cann't instal postgres sql in windows vista Details: Dear All, I cann'

[BUGS] BUG #3288: Select command giving error

2007-05-17 Thread Srinivas
The following bug has been logged online: Bug reference: 3288 Logged by: Srinivas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Win XP Description:Select command giving error Details: Hi, We are using PGOleDB drivers with ASP.Net C# code

[BUGS] PGCLUSTER -- ERROR

2007-05-17 Thread Alex Lima Silva
Hi, I´m trying to install pgcluster 1.7 on Aix 5.3 and I´m having problems, when I run "./configure --enable-thread-safety" I receive the msg bellow and when a try to do make make install I got a error about libpg Could someone help me please ? Thanks in advance checking for sys/s