Re: [GENERAL] 8.3 libpq.dll not working on some versions of windows
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, dependency walker reports this: Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module. I have all the required files in the same dir as my exe I did this test on the latest version of wine (libpq.dll always worked in wine before), and I was getting the exact same behavior on the PCs at work. WINE is not a good test for this I know, but all I have at the moment. I will have to try this on the PCs at work(on Monday) that are having the issue. I know one of them is a really old XP (6 years) that was just recently updated to SP3. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Vacuum Full is *hideously* slow!
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 ANALYZE, which give me this: How long it takes to cluster depends on how many rows there are in the table and how ordered they are. How long a VACUUM FULL takes depends on how big the tables is and how many gaps there are to fill. If you have a big table (in actual space) but it only has a few rows (it's very bloated) a cluter will will all the time. --- INFO: links: found 5427 removable, 8876599 nonremovable row versions in 483102 pages DETAIL: 96 dead row versions cannot be removed yet. There were 2135991 unused item pointers. 235 pages contain useful free space. --- This table looks fine. Only 235 pages have useful free space. The 483102 pages just means the table is 483102*8K = 3.9GB in size. I imagine you max_fsm_pages is somewhat larger than 235 pages. If yo uwant proper estimates for max_fsm_pages you should vacuum the entire DB, then it'll tell you. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature
Re: [GENERAL] Database access over the Internet...
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 outbound for her so she ONLY gets it from the original sender. You did not understand the problem My Mailbox which I use for my business is bombed by over 50.000 spams per day and I do already heavy filtering. I have to read my mail while I am @work which mean, MOBILE using my cellphone connected to my Laptop. Since I read the List ove another channel AND already filtering my own threads (and convert it into a form which is much smaller then E-Mails) to get rid of the rest from the list since I am subscribed to over 120 mailinglists and need less then 3% from it... So, peoples now sending me PMs does not help, since it DoS my system and make it harder for me to work since I have to walk through this messages I do not need because I have it already seen. Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 +49/177/935194750, rue de Soultz MSN LinuxMichi +33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com) signature.pgp Description: Digital signature
Re: [GENERAL] Database access over the Internet...
signature.pgp Description: Digital signature
[GENERAL] disable/enable trigger and transaction
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] LDAP
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=domain, dc=com, dc=tr I want to search with attribute and filter query like this ldap://hostname:port/base_dn?attributes?scope?filter how can I use this in pg_hba.conf ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Database access over the Internet...
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 same CC list as her email server. Well, it does, and it then drops the message outbound for her so she ONLY gets it from the original sender. You did not understand the problem My Mailbox which I use for my business is bombed by over 50.000 spams per day and I do already heavy filtering. I have to read my mail while I am @work which mean, MOBILE using my cellphone connected to my Laptop. These two requirements seem at odds. If you read your email on laptop connected via cell phones then you don't need to be anywhere except somewhere that has cell phone coverage. Since I read the List ove another channel AND already filtering my own threads (and convert it into a form which is much smaller then E-Mails) to get rid of the rest from the list since I am subscribed to over 120 mailinglists and need less then 3% from it... So, what other method is this? I still don't understand the problem. In your haste to send out an email explaining it to me, you've failed to really explain it. If you send the eliminatecc command to the mailing list server it won't send you an email. Are you saying you read this list some other way than a subscription to the mailing list? Because you said quite clearly in your first message you WERE subscribed to this list. So, are you subscribed through another account? Read through USENET? If you are subscribed via this account, and are getting an email from the user and the list, eliminatecc will work. Otherwise, no. So, peoples now sending me PMs does not help, since it DoS my system and make it harder for me to work since I have to walk through this messages I do not need because I have it already seen. WHERE have you already seen them. I'm still not understanding. If you're gonna subscribe to a list, do so with an email account that can handle being sent emails. One that breaks from the relatively low traffic generated by a conversation on this list can't be even a small percentage of the real spam it must already get. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] LDAP
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 this type query; cn=username, dc=domain, dc=com, dc=tr I want to search with attribute and filter query like this ldap://hostname:port/base_dn?attributes?scope?filter how can I use this in pg_hba.conf ? The LDAP authentication method does not support filtering. It's something we'd like to add, but I don't know of anybody actively working on it. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Database access over the Internet...
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. Well, it does, and it then drops the message outbound for her so she ONLY gets it from the original sender. You did not understand the problem My Mailbox which I use for my business is bombed by over 50.000 spams per day and I do already heavy filtering. I have to read my mail while I am @work which mean, MOBILE using my cellphone connected to my Laptop. Since I read the List ove another channel AND already filtering my own threads (and convert it into a form which is much smaller then E- Mails) to get rid of the rest from the list since I am subscribed to over 120 mailinglists and need less then 3% from it... So, peoples now sending me PMs does not help, since it DoS my system and make it harder for me to work since I have to walk through this messages I do not need because I have it already seen. Well, go away then. If you are too cheap to receive emails in answer to your questions, stop asking questions. This is not a support channel you should consider using until you learn enough courtesy and basic competence with email to interact in public. Cheers, Steve Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ # Debian GNU/Linux Consultant # Michelle Konzack Apt. 917 ICQ #328449886 +49/177/935194750, rue de Soultz MSN LinuxMichi +33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] aggregates and case statements
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 effortandattainment.effort=2 THEN 2 WHEN effortandattainment.effort=1 THEN 3 END from effortandattainment group by case Regards Garry
[GENERAL] avoid replace of column with variable in pgsql function
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, bar || '-bar'); SELECT foo INTO id FROM t2 WHERE value = bar; END $BODY$ LANGUAGE 'plpgsql'; In the INSERT statemet the id column is replaced with $2, which is not what I want. Quoting the colum name does not help. And I dont want to rename the output variable nor the column of the table. Is this possible? Regards, Gerhard signature.asc Description: Digital signature
Re: [GENERAL] avoid replace of column with variable in pgsql function
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 using RENAME: CREATE FUNCTION insert_foo(IN bar integer, OUT id integer) AS $BODY$ declare rename id to _id; BEGIN INSERT INTO t1 (id, value) VALUES (bar, bar || '-bar'); SELECT id INTO _id FROM ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general