Re: [GENERAL] 8.3 libpq.dll not working on some versions of windows

2008-11-16 Thread Tony Caduto
Glyn Astill wrote: Pretty sure I've used most 8.3.x versions here on both sp2 and 3. How have you chacked you have all the dependencies? (I like depends.exe) http://www.dependencywalker.com/ hmm, the problem seems to be that MSVCR71.DLL has a problem with some versions of Kernel32.DLL,

Re: [GENERAL] Vacuum Full is *hideously* slow!

2008-11-16 Thread Martijn van Oosterhout
On Sun, Nov 16, 2008 at 06:05:40AM +0800, Phoenix Kiula wrote: > How long should cluster take on a db that's about 5.5GB in size? Is it > worth doing on a production db? The db is running fast now anyway, so > the only reason I am even thinking about this is because of the > results of a VACUUM ANA

Re: [GENERAL] Database access over the Internet...

2008-11-16 Thread Michelle Konzack
Am 2008-11-15 09:53:15, schrieb Scott Marlowe: > What's mess up is that the solution given the user DOES work. She > just refuses to try it, because she assumes that the mailing list > server doesn't see the exact same CC list as her email server. Well, > it does, and it then drops the message ou

Re: [GENERAL] Database access over the Internet...

2008-11-16 Thread Michelle Konzack
signature.pgp Description: Digital signature

[GENERAL] disable/enable trigger and transaction

2008-11-16 Thread Peter Billen
Hi all, Is the instruction 'ALTER TABLE x ENABLE/DISABLE TRIGGER y' part of the current transaction? That is, say that there are two ongoing transactions, T1 and T2. Is the trigger y still enabled in transaction T2 if it's disabled in transaction T1? Thanks in advance. Kind regards, Peter

[GENERAL] LDAP

2008-11-16 Thread Taha Ozket
Hi, I am using ldap for client authentication. I add a line to pg_hba.conf like this host allall192.168.1.104 255.255.255.0ldap "ldap://ldapserver:389/dc=domain,dc=com,dc=tr;;,sn=;?sub?(objectclass=*)" but It doesnt work. I dont want to use this type query; cn=username, dc=domai

Re: [GENERAL] Database access over the Internet...

2008-11-16 Thread Scott Marlowe
On Sun, Nov 16, 2008 at 3:41 AM, Michelle Konzack <[EMAIL PROTECTED]> wrote: > Am 2008-11-15 09:53:15, schrieb Scott Marlowe: >> What's mess up is that the solution given the user DOES work. She >> just refuses to try it, because she assumes that the mailing list >> server doesn't see the exact sa

Re: [GENERAL] LDAP

2008-11-16 Thread Magnus Hagander
Taha Ozket wrote: > Hi, > > I am using ldap for client authentication. I add a line to pg_hba.conf like > this > > host allall192.168.1.104 255.255.255.0ldap > "ldap://ldapserver:389/dc=domain,dc=com,dc=tr;;,sn=;?sub?(objectclass=*)" > > but It doesnt work. I dont want to use th

Re: [GENERAL] Database access over the Internet...

2008-11-16 Thread Steve Atkins
On Nov 16, 2008, at 2:41 AM, Michelle Konzack wrote: Am 2008-11-15 09:53:15, schrieb Scott Marlowe: What's mess up is that the solution given the user DOES work. She just refuses to try it, because she assumes that the mailing list server doesn't see the exact same CC list as her email server

[GENERAL] aggregates and case statements

2008-11-16 Thread Garry Saddington
Is there a way to make the following statement return the total of all effort. At the moment it gives a list of sum vs case. select sum(effort), CASE WHEN effortandattainment.effort=5 THEN -3 WHEN effortandattainment.effort=4 THEN -2 WHEN effortandattainment.effort=3 THEN 1 WHEN effortandattain

[GENERAL] avoid replace of column with variable in pgsql function

2008-11-16 Thread Gerhard Heift
Hello, I have a function with an out variable in which I have an INSERT statement with the same name as column. Is it possible to avoid the replacement? Its something like this: CREATE FUNCTION insert_foo(IN bar integer, OUT id integer) AS $BODY$ BEGIN INSERT INTO t1 (id, value) VALUES (bar, b

Re: [GENERAL] avoid replace of column with variable in pgsql function

2008-11-16 Thread Tom Lane
Gerhard Heift <[EMAIL PROTECTED]> writes: > I have a function with an out variable in which I have an INSERT > statement with the same name as column. Is it possible to avoid the > replacement? No, but you could rename the variable. If you don't want to change the externally exposed name, try usi