[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 .

Re: [GENERAL] Windows 2003 server installation issue

2010-08-14 Thread Scott Marlowe
On Sat, Aug 14, 2010 at 12:49 AM, Vikram Patil vpa...@actuate.com 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

[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

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Torsten Zühlsdorff
Tom Lane schrieb: =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= f...@meisterderspiele.de 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

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= f...@meisterderspiele.de 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

[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

[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

Re: [GENERAL] Delete Trigger

2010-08-14 Thread Tom Lane
Chris Berry chrisdberr...@googlemail.com 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 (...

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 with every

Re: [GENERAL] Compression on SSL links?

2010-08-14 Thread dennis jenkins
On Fri, Aug 13, 2010 at 10:56 AM, Joshua D. Drake j...@commandprompt.com 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

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

[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

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] 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,

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

2010-08-14 Thread Szymon Guz
2010/8/14 Stefan Wild wild...@yahoo.de 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,

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

2010-08-14 Thread Thom Brown
On 14 August 2010 22:46, Stefan Wild wild...@yahoo.de 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,              

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] InitDB: Bad system call

2010-08-14 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= f...@meisterderspiele.de 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