[BUGS] strange problem with ip6

2007-05-14 Thread Brian Hirt
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, but I'm no IP6 expert. load=# select * from pg_stat_activity ; ERRO

Re: [BUGS] postgresql locks up over the net

2007-05-14 Thread Tom Lane
"Peter T. Breuer" <[EMAIL PROTECTED]> writes: > When talking across a net connection, the 8.1.8-1 client eventually hangs > waiting for a reply to a query that the 7.4.7-6 server misses: What platforms are the client and server running on? What sort of networking junk is in between? Are there an

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

2007-05-14 Thread Alvaro Herrera
Alvaro Herrera wrote: > 2. decide that the standard is braindead and just omit dumping the >grantor when it's no longer available, but don't remove >pg_auth_members.grantor > > Which do people feel should be implemented? I can do whatever we > decide; if no one has a strong opinion on th

[BUGS] postgresql locks up over the net

2007-05-14 Thread Peter T. Breuer
When talking across a net connection, the 8.1.8-1 client eventually hangs waiting for a reply to a query that the 7.4.7-6 server misses: CLIENT: 1) send(3, "Q\0\0\0009SELECT key FROM records WHE"..., 58, 0) = 58 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 poll([{fd=3, events=POLLIN|POLLER

Re: [BUGS] BUG #3279: insert or update

2007-05-14 Thread Stefan Kaltenbrunner
[EMAIL PROTECTED] wrote: > The following bug has been logged online: > > Bug reference: 3279 > Logged by: > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: macosx > Description:insert or update > Details: > > I sort of want to begin th

Re: [BUGS] BUG #3278: PSQLException when using setBinaryStream via JDBC

2007-05-14 Thread Kris Jurka
On Mon, 14 May 2007, jeffrey zhao wrote: The following bug has been logged online: Bug reference: 3278 When I run the following program, I got an exception as following: ps.setBinaryStream(2, fis, file.length()); org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4Prepa

[BUGS] BUG #3279: insert or update

2007-05-14 Thread
The following bug has been logged online: Bug reference: 3279 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: macosx Description:insert or update Details: I sort of want to begin this with 'Hey, a--h---e.' I've got my code work

[BUGS] BUG #3278: PSQLException when using setBinaryStream via JDBC

2007-05-14 Thread jeffrey zhao
The following bug has been logged online: Bug reference: 3278 Logged by: jeffrey zhao Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4-1 Operating system: Windows XP Description:PSQLException when using setBinaryStream via JDBC Details: When I run the foll

Re: [BUGS] INSTALL appnote for Solaris 10...

2007-05-14 Thread Bruce Momjian
Feel free to submit a diff against the current Solaris FAQ. --- Zdenek Kotala wrote: > John R Pierce wrote: > > I just built a version of postgres 8.2.4 on Solaris 10 x86 ... a few > > things that could be mentioned in INST

Re: [BUGS] BUG #3276: unique index/unique constraint

2007-05-14 Thread Tom Lane
"michael" <[EMAIL PROTECTED]> writes: > with regards to unique rows, i think we should deviate from the sql > standard. That's not happening. > or if this isn't possible, we should at least document this in > postgresql's unique index/unique constraint's gotchas, make more obvious. It is docume

RE : Re: [BUGS] BUG #3271: PREPARE/EXCUTE don't work

2007-05-14 Thread Laurent FAILLIE
Hi Heikki, --- Heikki Linnakangas <[EMAIL PROTECTED]> a écrit : > > www=> PREPARE authn_dbd_1 (varchar) AS select mdp > from mariage.comptes where > > nom = '$1'; > > That $1 should be without the quotes, like this: > > PREPARE authn_dbd_1 (varchar) AS select mdp from > mariage.comptes where >

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Klint Gore
On Mon, 14 May 2007 09:44:05 +0100, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > Nilay Ceter wrote: > > The command line: > > > > select seri_no, ad as baslik, kull_ref as Kullanıcı_Referansi, sorumlu > > from onay,dokuman where p_id='yonetici' and onay.dokuman_id=dokuman.seri_no > > and onay

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Magnus Hagander
On Mon, May 14, 2007 at 09:44:05AM +0100, Heikki Linnakangas wrote: > Nilay Ceter wrote: > >The command line: > > > >select seri_no, ad as baslik, kull_ref as Kullanıcı_Referansi, > >sorumlu > >from onay,dokuman where p_id='yonetici' and onay.dokuman_id=dokuman.seri_no > >and onay_durum.seri_no=

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Heikki Linnakangas
Nilay Ceter wrote: The command line: select seri_no, ad as baslik, kull_ref as Kullanıcı_Referansi, sorumlu from onay,dokuman where p_id='yonetici' and onay.dokuman_id=dokuman.seri_no and onay_durum.seri_no=seri_no and onay_durum.p_id='yonetici' and (dokuman.durum=1 or dokuman.durum=2 or dokum

[BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Nilay Ceter
The following bug has been logged online: Bug reference: 3277 Logged by: Nilay Ceter Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: windows Description:error occurs between different versions Details: We are developing a network based a

[BUGS] BUG #3276: unique index/unique constraint

2007-05-14 Thread michael
The following bug has been logged online: Bug reference: 3276 Logged by: michael Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: winxp Description:unique index/unique constraint Details: from postgresql irc, one says: the docs say: "Whe