Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup

2006-05-15 Thread Ruslan A Dautkhanov
Hello ! Tom Lane wrote: Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: Server rebooted occasionally after power failure. And I have stale postmaster.pid file, so postmaster didn't start with error bill postgres[600]: [1-1] FATAL: file "postmaster.pid" already exists

Re: [BUGS] BUG #2436: cannot --enable-thread-safety on -lpthread host

2006-05-15 Thread Tom Lane
Paul Forgey <[EMAIL PROTECTED]> writes: > As given in my OS info, this isn't FC4. The configure script fails > to enable threading in Debian Sarge. The point is that the configure script clearly does test for -lpthread, so whatever problem you're having, you've not described it correctly.

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Jim C. Nasby
On Mon, May 15, 2006 at 02:20:51PM -0500, Larry Rosenman wrote: > > Yeah, but what's the ${command} ? > > > > If it's pg_ctl then all he's missing is the recent change to check > > getppid. If it's execing postmaster directly then maybe we need > > another theory. > > It's pg_ctl > > comman

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Larry Rosenman
Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: >> Except that the shell that's running su would be root, not pgsql, at >> least in the case of FreeBSD. The guts of the current port's rc.d >> file are: > >> su -l ${postgresql_user} -c "exec ${command} ${command_args} >> ${rc_arg}" >

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Except that the shell that's running su would be root, not pgsql, at > least in the case of FreeBSD. The guts of the current port's rc.d file > are: > su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" Yeah, but what's the ${comma

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Jim C. Nasby
On Mon, May 15, 2006 at 09:23:33AM -0400, Tom Lane wrote: > We've fixed this in recent releases by having the postmaster also check > for a match to its parent process ID (getppid). The care in the start > script comes because this only works for one level up. Therefore, you > can't "su -c pg_ctl

Re: [BUGS] BUG #2437: Rules for COPY

2006-05-15 Thread Jim C. Nasby
On Mon, May 15, 2006 at 09:50:57AM -0400, Tom Lane wrote: > "Anton Fedorov" <[EMAIL PROTECTED]> writes: > > Looks like COPY bypass rules 'ON INSERT INSTEAD'. > > That's the documented behavior. We're unlikely to change it because > it'd slow COPY down substantially, which'd negate its main use of

Re: [BUGS] BUG #2431: Error:SELECT query has no destination for result data

2006-05-15 Thread Jim C. Nasby
On Thu, May 11, 2006 at 05:29:02AM +, bhavani wrote: > > The following bug has been logged online: > > Bug reference: 2431 > Logged by: bhavani > Email address: [EMAIL PROTECTED] > PostgreSQL version: postgresql 8.10 > Operating system: windowsxp > Description:Err

Re: [BUGS] BUG #2428: ERROR: out of memory, running INSERT SELECT

2006-05-15 Thread Jim C. Nasby
On Fri, May 12, 2006 at 08:04:20AM +0100, Simon Riggs wrote: > On Thu, 2006-05-11 at 20:14 -0400, Tom Lane wrote: > > Casey Duncan <[EMAIL PROTECTED]> writes: > > > On May 11, 2006, at 4:42 AM, Simon Riggs wrote: > > >> As your database is defined, this SQL statement will return > > >> approximatel

Re: [BUGS] BUG #2437: Rules for COPY

2006-05-15 Thread Tom Lane
"Anton Fedorov" <[EMAIL PROTECTED]> writes: > Looks like COPY bypass rules 'ON INSERT INSTEAD'. That's the documented behavior. We're unlikely to change it because it'd slow COPY down substantially, which'd negate its main use of being a bulk data loading mechanism. regar

Re: [BUGS] BUG #2436: cannot --enable-thread-safety on -lpthread host

2006-05-15 Thread Tom Lane
"Paul Forgey" <[EMAIL PROTECTED]> writes: > Linux supplies -lpthread. The configure script seems to only look for > -lpthreads and then give up. Say again? I get this configure trace on Fedora 4: checking for the pthreads library -lpthreads... no checking whether pthreads work without any flags

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Tom Lane
Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > Server rebooted occasionally after power failure. > And I have stale postmaster.pid file, so postmaster didn't start with error > bill postgres[600]: [1-1] FATAL: file "postmaster.pid" already exists You probably need a newer postgres version

Re: [BUGS] BUG #2439: pgAdmin III v1.4.1 fails to compile with GCC 4.1.0

2006-05-15 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jason Kankiewicz > Sent: 14 May 2006 17:08 > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #2439: pgAdmin III v1.4.1 fails to > compile with GCC 4.1.0 > > > The following bug has been logged

[BUGS] BUG #2438: error connect with odbc

2006-05-15 Thread MATTASOGLIO DENIS
The following bug has been logged online: Bug reference: 2438 Logged by: MATTASOGLIO DENIS Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: WINDOWS XP Description:error connect with odbc Details: Hello world i work with powerbuilder odbc a

[BUGS] BUG #2437: Rules for COPY

2006-05-15 Thread Anton Fedorov
The following bug has been logged online: Bug reference: 2437 Logged by: Anton Fedorov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3-3 Operating system: debian linux Description:Rules for COPY Details: Looks like COPY bypass rules 'ON INSERT INSTEAD'. I

[BUGS] BUG #2436: cannot --enable-thread-safety on -lpthread host

2006-05-15 Thread Paul Forgey
The following bug has been logged online: Bug reference: 2436 Logged by: Paul Forgey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Debian stable (sarge) Description:cannot --enable-thread-safety on -lpthread host Details: Linux supplie

[BUGS] BUG #2439: pgAdmin III v1.4.1 fails to compile with GCC 4.1.0

2006-05-15 Thread Jason Kankiewicz
The following bug has been logged online: Bug reference: 2439 Logged by: Jason Kankiewicz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Gentoo Linux ~amd64 Description:pgAdmin III v1.4.1 fails to compile with GCC 4.1.0 Details: "emerge =

Re: [BUGS] SIGSEGV happens over once a day

2006-05-15 Thread Tomasz Ostrowski
On Thu, 11 May 2006, Richard Yen wrote: > I'm experiencing signal 11 (segmentation fault) failures on the > master node of a 3-node Slony-I cluster. In the past week, we've > averaged a little more than one segfault per day (11 times in the > past 10, including today). Any ideas what's goi

[BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Ruslan A Dautkhanov
Hello ! Server rebooted occasionally after power failure. And I have stale postmaster.pid file, so postmaster didn't start with error bill postgres[600]: [1-1] FATAL: file "postmaster.pid" already exists I think startup script and/or pg_ctl have to be written to check if that process really