Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Glen Barber
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 8/15/10 1:32 AM, Tom Lane wrote: > > Well, this seems to be clear proof for what everyone suspected all > along: your kernel is rejecting SysV-shared-memory calls. I'm too tired > to go check that that shmctl() is the first such syscall during the

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > Core was generated by `postgres'. > Program terminated with signal 12, Bad system call. > Reading symbols from /lib/libm.so.5...done. > Loaded symbols for /lib/libm.so.5 > Reading symbols from /lib/libc.so.7...done. > Loaded symbols for /lib/libc.so

Re: [GENERAL] Wrong "ORDER BY" on a numeric value result

2010-08-14 Thread hubert depesz lubaczewski
On Sat, Aug 14, 2010 at 09:46:37PM +, Stefan Wild wrote: > Hello guys, > > I have following sorting problem and need your help. When executing this > SELECT statement: > > "SELECT d.id, d.name, > d.description, ts.name, d.opentimestamp,

Re: [GENERAL] Wrong "ORDER BY" on a numeric value result

2010-08-14 Thread Thom Brown
On 14 August 2010 22:46, Stefan Wild wrote: > Hello guys, > > I have following sorting problem and need your help. When executing this > SELECT statement: > > "SELECT                  d.id,                  d.name,                 > d.description,         ts.name,               d.opentimestamp,  

Re: [GENERAL] Wrong "ORDER BY" on a numeric value result

2010-08-14 Thread Szymon Guz
2010/8/14 Stefan Wild > Hello guys, > > I have following sorting problem and need your help. When executing this > SELECT statement: > > "SELECT d.id, d.name, > d.description, ts.name, d.opentimestamp, > d.initialvalue,d.plmoney,

[GENERAL] Wrong "ORDER BY" on a numeric value result

2010-08-14 Thread Stefan Wild
Hello guys, I have following sorting problem and need your help. When executing this SELECT statement: "SELECT d.id, d.name, d.description, ts.name, d.opentimestamp, d.initialvalue,d.plmoney, d.per

Re: [GENERAL] undefined symbol: PQconnectdbParams

2010-08-14 Thread Jeff Davis
On Sat, 2010-08-14 at 23:18 +0300, Sim Zacks wrote: > > I compiled postgresql beta 4 on a users account and installed it with a > different port into my home directory (~/pg9) > > This was recommended by my web host because they refused to give me > plpythonu access on a shared server. (perfectly

[GENERAL] undefined symbol: PQconnectdbParams

2010-08-14 Thread Sim Zacks
I compiled postgresql beta 4 on a users account and installed it with a different port into my home directory (~/pg9) This was recommended by my web host because they refused to give me plpythonu access on a shared server. (perfectly understandable from their perspective) I can get into psql u

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Torsten Zühlsdorff
Tom Lane schrieb: Hm... /path/to/postgres? Not initdb? Yes; it's postgres that is failing, not initdb. Ok. But regardless what i use, it looks like: #0 0x000800bb166c in ?? () #1 0x005b158f in ?? () ... I believe that is not very helpful, is it? Nope, it's not. Could you

Re: [GENERAL] Compression on SSL links?

2010-08-14 Thread dennis jenkins
On Fri, Aug 13, 2010 at 10:56 AM, Joshua D. Drake wrote: > On Fri, 2010-08-13 at 11:38 -0400, Tom Lane wrote: >> >> I don't really see that.  The case where it's sensible to use >> compression on the connection is where you're pushing data across >> a WAN.  That's also pretty much exactly the sit

Re: [GENERAL] Windows 2003 server installation issue

2010-08-14 Thread Joshua D. Drake
On Fri, 2010-08-13 at 23:49 -0700, Vikram Patil wrote: > Hello Folks, > > > >I am facing an issue starting postgresql using windows service when > my user belongs to Administrator group. > > > >I applied patch from following thread to 8.4.1 source code and it > seems to be working w

Re: [GENERAL] Delete Trigger

2010-08-14 Thread Tom Lane
Chris Berry writes: > When I update, insert or delete to one table, I need a trigger to delete and > possibly insert into another table. The trigger I have works for insert and > update, but returns an error when I do a delete. There's no "NEW" row in a delete trigger (... and the error message s

[GENERAL] heap-only tuples, and constraints

2010-08-14 Thread maxxe...@gmail.com
Hi, Question about heap-only tuples, and constraint checking. Does this statement (UPDATE user SET email='newChangedVal', password='existingVal') requires updating an index on user.password? Or more generally, if an UPDATE includes an explicit but unchanged value for an index column, does postgre

[GENERAL] Delete Trigger

2010-08-14 Thread Chris Berry
When I update, insert or delete to one table, I need a trigger to delete and possibly insert into another table. The trigger I have works for insert and update, but returns an error when I do a delete. The is no explicit link between the tables, so I can't do 'DELETE CASCADE' or anything like that

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > Hm... /path/to/postgres? Not initdb? Yes; it's postgres that is failing, not initdb. > But regardless what i use, it looks > like: > #0 0x000800bb166c in ?? () > #1 0x005b158f in ?? () > ... > I believe that is not very helpful, is

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Torsten Zühlsdorff
Tom Lane schrieb: =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: It's the same like before, but this time with core-file! :) I don't know why, but now there is one. You can find it here: http://www.dddbl.de/postgres.core (2,4 MB) That's good, but the core file is pretty much useless to anyon

[GENERAL] .psqlrc and custom functions (mysql-like)

2010-08-14 Thread Sandeep Srinivasa
hi, As part of a product we are building, we are using postgres as our database. But most of our developers have a (loud) mysql background. I want to potentially provide "aliases" for a few commonly used mysql functions. I see that the .psqlrc could potentially be the place where you could defi

Re: [GENERAL] Windows 2003 server installation issue

2010-08-14 Thread Scott Marlowe
On Sat, Aug 14, 2010 at 12:49 AM, Vikram Patil wrote: > Hello Folks, > > > >    I am facing an issue starting postgresql using windows service when my > user belongs to Administrator group. > > > >    I applied patch from following thread to 8.4.1 source code and it seems > to be working with ever

[GENERAL] Windows 2003 server installation issue

2010-08-14 Thread Vikram Patil
Hello Folks, I am facing an issue starting postgresql using windows service when my user belongs to Administrator group. I applied patch from following thread to 8.4.1 source code and it seems to be working with every windows operating system except Windows 2003 . http://archives.post