Re: [GENERAL] invalid byte sequence for encoding
Daniel Schuchardt wrote:
but look here:
X=# UPDATE art SET ak_auftxt= '*', ak_auftxt_rtf=
'{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0
Arial;}}\r\n\\viewkind4\\uc1\\pard\\lang1031\\fs20 *
\r\n\\par }\r\n\0' WHERE ak_nr='TEST';
WARNING: nonstandard use of \\ in a string literal at character 47
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR: invalid byte sequence for encoding SQL_ASCII: 0x00
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
client_encoding.
=# SELECT version();
version
-
PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit
##
=# UPDATE art SET ak_auftxt= '*', ak_auftxt_rtf=
'{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0
Arial;}}\r\n\\viewkind4\\uc1\\pard\\lang1031\\fs20 *\
r\n\\par }\r\n\0' WHERE ak_nr='TEST';
UPDATE 1
=# SELECT version();
version
--
PostgreSQL 8.1.11 on i486-pc-linux-gnu, compiled by GCC cc
(GCC) 4.1.2
20061115
(prerelease) (Debian 4.1.1-21)
(1 row)
PostgreSQL's encoding checks have become more airtight over the
versions, so it is no surprise that buggy behaviour in 8.1
has changed by 8.4.
The zero character at the end of your string has been wrong all
along, only the old version does not complain.
You probably never noticed the string truncation because the
zero character is the last one.
You'll need to fix your program so that it does not emit trailing
zero characters.
Yours,
Laurenz Albe
--
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] hardware information
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- htop is really nice too. http://htop.sourceforge.net/ (disclaimer - I did not write it) I like atop better -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] pgadmin is changing pgpass.conf
Hi All, I have been having a few problems with my password file recently, causing my scheduled pg_dump to fail. The problem is that the pgpass.conf file keeps changing. Eventually I narrowed it down to using pgadmin. Every time I start pgadmin, it changes the contents of my pgpass file, even though I do not store my password in pgadmin. This only seems to have become a problem since installing 8.4 and associated version of pgadmin. Is this the desired behaviour or is it a bug? Howard Cole www.selestial.com -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: ek...@addisonsearch.com To: mgai...@hotmail.com; g...@seespotcode.net CC: dmag...@gmail.com; pgsql-general@postgresql.org Date: Wed, 16 Sep 2009 06:11:05 -0500 Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin, no reason to take the discussion off line. Your statements were false. Nobody here appreciates someone who blogs to add controversy. As always I'm taking the high road. If anyone wants to hear more, please write and I will respond to you individually. - Original Message - From: Martin Gainty mgai...@hotmail.com To: g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; Ed Koch; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tue Sep 15 21:39:38 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? how many PBJ did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. CC: dmag...@gmail.com; ek...@addisonsearch.com; pgsql-general@postgresql.org From: g...@seespotcode.net To: mgai...@hotmail.com Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Date: Tue, 15 Sep 2009 22:17:58 -0400 On Sep 15, 2009, at 20:48 , Martin Gainty wrote: NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals are a min of 50$/per While you should always take into account taxes and cost of living (and these things can be high in NYC), at least a couple of your figures are quite exaggerated: taxi fares are fixed at $2.50 + $0.40/ (quarter mile or 60 seconds)[1] and I've had many filling meals at restaurants in Manhattan for much less that $30. Michael Glaesemann grzm seespotcode net [1]http://www.nyc.gov/html/tlc/html/passenger/taxicab_rate.shtml -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Hotmail: Powerful Free email with security by Microsoft. Get it now. http://clk.atdmt.com/GBL/go/171222986/direct/01/ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a
Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
Martin Gainty wrote: lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty I've been ignoring this until now, but as a list member I have to say it is very embarrassing to see this kind of thread on a list as respectable as PostgreSQL General. Threatening lawsuits over a disagreement on the cost of living somewhere? Seriously now, grow up. This whole discussion has nothing to do with PostgreSQL and should go off list, or better still, just go away. Madi -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
in the US anyone making false statements about anyone is subject to a libel lawsuit if you want to change that law i suggest you become a lawyer Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Wed, 16 Sep 2009 08:37:13 -0400 From: li...@alteeve.com To: mgai...@hotmail.com CC: ek...@addisonsearch.com; g...@seespotcode.net; dmag...@gmail.com; pgsql-general@postgresql.org Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin Gainty wrote: lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty I've been ignoring this until now, but as a list member I have to say it is very embarrassing to see this kind of thread on a list as respectable as PostgreSQL General. Threatening lawsuits over a disagreement on the cost of living somewhere? Seriously now, grow up. This whole discussion has nothing to do with PostgreSQL and should go off list, or better still, just go away. Madi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general _ Hotmail: Free, trusted and rich email service. http://clk.atdmt.com/GBL/go/171222984/direct/01/
[GENERAL] Current state of XML capabilities in PostgreSQL?
Hello,
I'm looking for the current state of XML capabilities in PostgreSQL and I'm
coming up with a lot of confusing links and a bit short on documentation.
I first read that there used to be an xml2 contrib module for Postgres that
provided a lot of functions to read/write and simultaneously validating XML,
and searching and returning columns with XML based upon XPath expressions,
etc... But I read that the capability was going to be moved into the
Postgres baseline (this was 8.3-ish?). Currently, all I've ended up finding
is the lone official document page on the XML data type (
http://www.postgresql.org/docs/current/static/datatype-xml.html), XML
functions and operators (
http://www.postgresql.org/docs/current/interactive/functions-xml.html), and
the XML Support Pg wiki page (http://wiki.postgresql.org/wiki/XML_Support).
I just plan on storing already-made XML in a column, then be able to search
on it using where clauses with XPath expressions (e.g. select
tv_show,xpath('/station/times', xml_data) from table_with_xml where
xpath('/name', xml_data)='Captain Kangaroo'). I do understand there is an
xpath() function to return data, so that's solved for.
I'm looking for the functionality that I mentioned above that allowed more
comprehensive XML operations but I'm just not finding any documentation for
it, if it exists.
I have 8.4.0 now, but can go to .1 if there have been great strides made
since .0 was released.
If anyone can help me out, I would be greatly appreciated.
Thanks,
Nate
Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
As someone who lives in NYC and has for a good 15 years now, your numbers are way off. While rent here is quite expensive, not everyone is stupid and plunks down $2500 for a studio (it can be done in nice buildings). Most people pay maybe $1500 for a decent studio (less if you want not-so-nice), $2500 for a good 1br, etc. If youre willing to commute from the outer boroughs, NJ or upstate (from 30 to 60 min by train) rents can be substantially lower. NYC is not for everyone, but many people love it here. I certainly do. Its not for those who just want a 9-5 job and a quiet life, but if you want opportunity and action NYC is it. God, I sound like an advert. Cheers, Rob From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Martin Gainty Sent: Wednesday, September 16, 2009 8:24 AM To: ek...@addisonsearch.com; g...@seespotcode.net Cc: dmag...@gmail.com; pgsql-general@postgresql.org Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: ek...@addisonsearch.com To: mgai...@hotmail.com; g...@seespotcode.net CC: dmag...@gmail.com; pgsql-general@postgresql.org Date: Wed, 16 Sep 2009 06:11:05 -0500 Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin, no reason to take the discussion off line. Your statements were false. Nobody here appreciates someone who blogs to add controversy. As always I'm taking the high road. If anyone wants to hear more, please write and I will respond to you individually. - Original Message - From: Martin Gainty mgai...@hotmail.com To: g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; Ed Koch; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tue Sep 15 21:39:38 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? how many PBJ did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. CC: dmag...@gmail.com; ek...@addisonsearch.com; pgsql-general@postgresql.org From: g...@seespotcode.net To: mgai...@hotmail.com Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Date: Tue, 15 Sep 2009 22:17:58 -0400 On Sep 15, 2009, at 20:48 , Martin Gainty wrote: NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals are a min of 50$/per While you should always take into account taxes and cost of living (and these things can be high in NYC), at least a couple of your figures are quite exaggerated: taxi fares are fixed at $2.50 + $0.40/ (quarter mile or 60 seconds)[1] and I've had many filling meals at restaurants in Manhattan for much less that $30. Michael Glaesemann grzm seespotcode net
[GENERAL] Default listing on -Fc files
Is there a way to tell to which table a DEFAULT rule belongs to? Example: Have multiple files with serial. The sequence is setup as a default. Because all tables have the same structure the DEFAULT lines on a file pg_dumped with -Fc look the same. The lines look like DEFAULT public id user DEFAULT public id user DEFAULT publid id user They have different IDs, but I don't know how to tell to which table they belong so when I do restores of selected tables I would be able to restore the proper defaults. -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
If anyone wants to have a MEANINGFUL conversation please respond to me off line - Gaitly needs attention apparently.. - Original Message - From: Martin Gainty mgai...@hotmail.com To: li...@alteeve.com li...@alteeve.com Cc: Ed Koch; g...@seespotcode.net g...@seespotcode.net; dmag...@gmail.com dmag...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wed Sep 16 07:43:22 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? in the US anyone making false statements about anyone is subject to a libel lawsuit if you want to change that law i suggest you become a lawyer Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Wed, 16 Sep 2009 08:37:13 -0400 From: li...@alteeve.com To: mgai...@hotmail.com CC: ek...@addisonsearch.com; g...@seespotcode.net; dmag...@gmail.com; pgsql-general@postgresql.org Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin Gainty wrote: lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty I've been ignoring this until now, but as a list member I have to say it is very embarrassing to see this kind of thread on a list as respectable as PostgreSQL General. Threatening lawsuits over a disagreement on the cost of living somewhere? Seriously now, grow up. This whole discussion has nothing to do with PostgreSQL and should go off list, or better still, just go away. Madi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Hotmail: Free, trusted and rich email service. Get it now. http://clk.atdmt.com/GBL/go/171222984/direct/01/ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. Should you wish to be excluded from any future mailings, please send an email to unsubscr...@addisonsearch.com with the word unsubscribe in the subject. If verification is required please request a hard-copy version. Addison Search, 222 S. Riverside PLZ, STE 1710, Chicago, IL, www.addisonsearch.com -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
I second that. Why would such a thing be written? - Original Message - From: Madison Kelly li...@alteeve.com To: Martin Gainty mgai...@hotmail.com Cc: Ed Koch; g...@seespotcode.net g...@seespotcode.net; dmag...@gmail.com dmag...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wed Sep 16 07:37:13 2009 Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin Gainty wrote: lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty I've been ignoring this until now, but as a list member I have to say it is very embarrassing to see this kind of thread on a list as respectable as PostgreSQL General. Threatening lawsuits over a disagreement on the cost of living somewhere? Seriously now, grow up. This whole discussion has nothing to do with PostgreSQL and should go off list, or better still, just go away. Madi This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. Should you wish to be excluded from any future mailings, please send an email to unsubscr...@addisonsearch.com with the word unsubscribe in the subject. If verification is required please request a hard-copy version. Addison Search, 222 S. Riverside PLZ, STE 1710, Chicago, IL, www.addisonsearch.com -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
How are you even IN the group when nobody here agrees with you Obviously you have nothing better to do, get a Hobby Gainty - Original Message - From: Martin Gainty mgai...@hotmail.com To: Ed Koch; g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wed Sep 16 07:24:28 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: ek...@addisonsearch.com To: mgai...@hotmail.com; g...@seespotcode.net CC: dmag...@gmail.com; pgsql-general@postgresql.org Date: Wed, 16 Sep 2009 06:11:05 -0500 Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin, no reason to take the discussion off line. Your statements were false. Nobody here appreciates someone who blogs to add controversy. As always I'm taking the high road. If anyone wants to hear more, please write and I will respond to you individually. - Original Message - From: Martin Gainty mgai...@hotmail.com To: g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; Ed Koch; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tue Sep 15 21:39:38 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? how many PBJ did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. CC: dmag...@gmail.com; ek...@addisonsearch.com; pgsql-general@postgresql.org From: g...@seespotcode.net To: mgai...@hotmail.com Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Date: Tue, 15 Sep 2009 22:17:58 -0400 On Sep 15, 2009, at 20:48 , Martin Gainty wrote: NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals are a min of 50$/per While you should always take into account taxes and cost of living (and these things can be high in NYC), at least a couple of your figures are quite exaggerated: taxi fares are fixed at $2.50 + $0.40/ (quarter mile or 60 seconds)[1] and I've had many filling meals at restaurants in Manhattan for much less that $30. Michael Glaesemann grzm seespotcode net [1]http://www.nyc.gov/html/tlc/html/passenger/taxicab_rate.shtml -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Hotmail: Powerful Free email with security by Microsoft. Get it now. http://clk.atdmt.com/GBL/go/171222986/direct/01/ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify
Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
Martin, no reason to take the discussion off line. Your statements were false. Nobody here appreciates someone who blogs to add controversy. As always I'm taking the high road. If anyone wants to hear more, please write and I will respond to you individually. - Original Message - From: Martin Gainty mgai...@hotmail.com To: g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; Ed Koch; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tue Sep 15 21:39:38 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? how many PBJ did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. CC: dmag...@gmail.com; ek...@addisonsearch.com; pgsql-general@postgresql.org From: g...@seespotcode.net To: mgai...@hotmail.com Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Date: Tue, 15 Sep 2009 22:17:58 -0400 On Sep 15, 2009, at 20:48 , Martin Gainty wrote: NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals are a min of 50$/per While you should always take into account taxes and cost of living (and these things can be high in NYC), at least a couple of your figures are quite exaggerated: taxi fares are fixed at $2.50 + $0.40/ (quarter mile or 60 seconds)[1] and I've had many filling meals at restaurants in Manhattan for much less that $30. Michael Glaesemann grzm seespotcode net [1]http://www.nyc.gov/html/tlc/html/passenger/taxicab_rate.shtml -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Hotmail: Powerful Free email with security by Microsoft. Get it now. http://clk.atdmt.com/GBL/go/171222986/direct/01/ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. Should you wish to be excluded from any future mailings, please send an email to unsubscr...@addisonsearch.com with the word unsubscribe in the subject. If verification is required please request a hard-copy version. Addison Search, 222 S. Riverside PLZ, STE 1710, Chicago, IL, www.addisonsearch.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] psql exit code, bug ?
http://gj.pastebin.com/f119e67bc Looks like psql loves to report on errors, only when -c is used, otherwise return code is always 0... I tested 8.3 and cvs-head, both have the same issue. Is that the 'by design' (bug/feature) ? -- GJ -- 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] psql exit code, bug ?
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes: Looks like psql loves to report on errors, only when -c is used, otherwise return code is always 0... The documentation seems perfectly clear on this point: psql returns 0 to the shell if it finished normally, 1 if a fatal error of its own (out of memory, file not found) occurs, 2 if the connection to the server went bad and the session was not interactive, and 3 if an error occurred in a script and the variable ON_ERROR_STOP was set. 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
Re: [GENERAL] psql exit code, bug ?
2009/9/16 Tom Lane t...@sss.pgh.pa.us: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes: Looks like psql loves to report on errors, only when -c is used, otherwise return code is always 0... The documentation seems perfectly clear on this point: psql returns 0 to the shell if it finished normally, 1 if a fatal error of its own (out of memory, file not found) occurs, 2 if the connection to the server went bad and the session was not interactive, and 3 if an error occurred in a script and the variable ON_ERROR_STOP was set. Well, but what you are looking for from - say - script, that calls psql to perform single action - is a meaningful exit code. That would specify whether SQL code returned any errors or not. This clearly shows, that you can rely only on -c, but others - appear to be inconsistent. (behave different, depending on how you feed the input to psql). -- GJ -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
Ed Koch wrote: How are you even IN the group when nobody here agrees with you Obviously you have nothing better to do, get a Hobby Gainty Ed, please, posts like this aren't helping. We're all adults here, can we all please start acting like one? Madi -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
All right children. Recess is over, get back to work. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ed Koch Sent: Wednesday, September 16, 2009 8:27 AM To: 'mgai...@hotmail.com'; 'g...@seespotcode.net' Cc: 'dmag...@gmail.com'; 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? How are you even IN the group when nobody here agrees with you Obviously you have nothing better to do, get a Hobby Gainty - Original Message - From: Martin Gainty mgai...@hotmail.com To: Ed Koch; g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wed Sep 16 07:24:28 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: ek...@addisonsearch.com To: mgai...@hotmail.com; g...@seespotcode.net CC: dmag...@gmail.com; pgsql-general@postgresql.org Date: Wed, 16 Sep 2009 06:11:05 -0500 Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin, no reason to take the discussion off line. Your statements were false. Nobody here appreciates someone who blogs to add controversy. As always I'm taking the high road. If anyone wants to hear more, please write and I will respond to you individually. - Original Message - From: Martin Gainty mgai...@hotmail.com To: g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; Ed Koch; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tue Sep 15 21:39:38 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? how many PBJ did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. CC: dmag...@gmail.com; ek...@addisonsearch.com; pgsql-general@postgresql.org From: g...@seespotcode.net To: mgai...@hotmail.com Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Date: Tue, 15 Sep 2009 22:17:58 -0400 On Sep 15, 2009, at 20:48 , Martin Gainty wrote: NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay any of your bills keep in mind that a studio *starts* at 2500/month this doesnt include parking which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals are a min of 50$/per While you should always take into account taxes and cost of living (and these things can be high in NYC), at least a couple of your figures are quite exaggerated: taxi fares are fixed at $2.50 + $0.40/ (quarter mile or 60 seconds)[1] and I've had many filling meals at restaurants in Manhattan for much less that $30. Michael Glaesemann grzm seespotcode net [1]http://www.nyc.gov/html/tlc/html/passenger/taxicab_rate.shtml -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
Re: [GENERAL] Current state of XML capabilities in PostgreSQL?
Nathan Widmyer wrote:
I just plan on storing already-made XML in a column, then be able to
search on it using where clauses with XPath expressions (e.g. select
tv_show,xpath('/station/times', xml_data) from table_with_xml where
xpath('/name', xml_data)='Captain Kangaroo'). I do understand there
is an xpath() function to return data, so that's solved for.
why would you store data thats wrapped in two copies of its fieldname
along with other punctuation?wouldn't it make more sense to
decompose your XML source into proper tables so proper indexes and
relational sql queries can be made? otherwise, every query turns
into a massive sequential scan and parsing operation.
--
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] Current state of XML capabilities in PostgreSQL?
On Wed, Sep 16, 2009 at 5:24 PM, John R Pierce pie...@hogranch.com wrote: why would you store data thats wrapped in two copies of its fieldname along with other punctuation? wouldn't it make more sense to decompose your XML source into proper tables so proper indexes and relational sql queries can be made? otherwise, every query turns into a massive sequential scan and parsing operation. you can always have index on xpath() ... and than use same expression in WHERE, and postgresql will use index. -- GJ -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
Amen! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Date: Wed, 16 Sep 2009 09:58:41 -0400 From: jhoo...@jcvi.org To: ek...@addisonsearch.com; mgai...@hotmail.com; g...@seespotcode.net CC: dmag...@gmail.com; pgsql-general@postgresql.org All right children. Recess is over, get back to work. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ed Koch Sent: Wednesday, September 16, 2009 8:27 AM To: 'mgai...@hotmail.com'; 'g...@seespotcode.net' Cc: 'dmag...@gmail.com'; 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? How are you even IN the group when nobody here agrees with you Obviously you have nothing better to do, get a Hobby Gainty - Original Message - From: Martin Gainty mgai...@hotmail.com To: Ed Koch; g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Wed Sep 16 07:24:28 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? lets assume you never take a cab anywhere and you pack enough PBJ for a week so we dont have to argue with Ed Koch anyone that has lived in NY knows you need 2500/month for any decent studio apt Also you need first,last and security to get the apt Making false statements to this group will get you a lawsuit .. Bye Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: ek...@addisonsearch.com To: mgai...@hotmail.com; g...@seespotcode.net CC: dmag...@gmail.com; pgsql-general@postgresql.org Date: Wed, 16 Sep 2009 06:11:05 -0500 Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? Martin, no reason to take the discussion off line. Your statements were false. Nobody here appreciates someone who blogs to add controversy. As always I'm taking the high road. If anyone wants to hear more, please write and I will respond to you individually. - Original Message - From: Martin Gainty mgai...@hotmail.com To: g...@seespotcode.net g...@seespotcode.net Cc: dmag...@gmail.com dmag...@gmail.com; Ed Koch; pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Tue Sep 15 21:39:38 2009 Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas? how many PBJ did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder
Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
On Wed, Sep 16, 2009 at 12:54:07PM -0400, Martin Gainty wrote: Amen! Martin, *please* stop responding publicly to this thread you idiotic child. You're digging yourself further and further into a mess, and making yourself look horribly unprofessional at the same time. That and ignoring several well known guidelines on this list; no top posting, and no html email. Yes Ed's been doing the same, but at least he's being professional now and has elevated himself above your childish taunts. Your last, gratuitous, message resulted in about 90MB of email being sent out (25KB message * 3653 subscribers) and wasting all their time wondering whether they should or shouldn't send a complaining email. All because your silly little ego dictated the need to say amen. Wait a day or two to calm down, read back through what was said and then come to a sensible decision. A public apology would probably save a bit of face, but I'd wait a bit for that as well. -- Sam http://samason.me.uk/ -- 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] I need a Postgres Admin $130K + 20K in NYC Any Ideas?
[ crap, that wasn't supposed to go to the list ] On Wed, Sep 16, 2009 at 06:30:46PM +0100, Sam Mason wrote: Martin, *please* stop responding publicly to this thread I'm feeling very embarrassed now! -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Unicode normalization
Has somebody integrated Unicode normalization into Postgres? if not, I would have to implement my own function by using this CPAN module: http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ . I need a function which removes all diacritics (1) and transforms some characters to a more compatible form (2) to get a better index on strings. Best, Andi 1) à,ä, ... = a 2) ø = o, ƒ = f, ª = a -- 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] pgadmin is changing pgpass.conf
On 16/09/2009 10:55, Howard Cole wrote: Hi All, I have been having a few problems with my password file recently, causing my scheduled pg_dump to fail. The problem is that the pgpass.conf file keeps changing. Eventually I narrowed it down to using pgadmin. Every time I start pgadmin, it changes the contents of my pgpass file, even though I do not store my password in pgadmin. This only seems to have become a problem since installing 8.4 and associated version of pgadmin. Is this the desired behaviour or is it a bug? It's the desired behaviour, and is described in the pgAdmin docs. As I remember there was also a discussion (on the pgadmin-support list I think) when this feature was added, on the merits or otherwise of storing passwords in plain text on disk. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- 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] Unicode normalization
On Wed, Sep 16, 2009 at 07:20:21PM +0200, Andreas Kalsch wrote: Has somebody integrated Unicode normalization into Postgres? if not, I would have to implement my own function by using this CPAN module: http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ . I need a function which removes all diacritics (1) and transforms some characters to a more compatible form (2) to get a better index on strings. Best, Andi 1) à,ä, ... = a 2) ø = o, ƒ = f, ª = a You mean something like this? http://wiki.postgresql.org/wiki/Strip_accents_from_strings%2C_and_output_in_lowercase Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- 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] Unicode normalization
No,
I need a solution which is as generic as possible. I use UTF-8 encoded
unicode strings on all levels. This is what I have done so far:
1) Writing a separate Python command line script for testing - works as
expected:
#!/usr/bin/python
import sys
import unicodedata
str = sys.argv[1].decode('UTF-8')
str = unicodedata.normalize('NFKD', str)
str = ''.join(c for c in str if unicodedata.combining(c) == 0)
print str
2) Transfering this to PL/Python:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF-8'))
$$ LANGUAGE plpythonu;
Problem: plpython throws an error, where my commandline script did it
correctly:
# select test('aÄÖÜ');
ERROR: plpython: function test could not create return value
DETAIL: type 'exceptions.UnicodeEncodeError': 'ascii' codec can't
encode character u'\u0308' in position 2: ordinal not in range(128)
I use PG 8.3 and Python 2.5.2. How can I make plpython behaving like in
a normal python environment?
In the end it should look like this:
CREATE TABLE t (
...
ts ts_vector NOT NULL
);
INSERT INTO t (ts) VALUES(to_tsvector(normalize(?)));
Andi
David Fetter schrieb:
On Wed, Sep 16, 2009 at 07:20:21PM +0200, Andreas Kalsch wrote:
Has somebody integrated Unicode normalization into Postgres? if not, I
would have to implement my own function by using this CPAN module:
http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ .
I need a function which removes all diacritics (1) and transforms some
characters to a more compatible form (2) to get a better index on
strings.
Best,
Andi
1) à,ä, ... = a
2) ø = o, ƒ = f, ª = a
You mean something like this?
http://wiki.postgresql.org/wiki/Strip_accents_from_strings%2C_and_output_in_lowercase
Cheers,
David.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 8.4 installer
Hi, I'm using Windows XP Pro. I am trying to install Postgres 8.4. I had 8.3 installed. Because I didn't have any important data, to make it easier I removed 8.3, the data directory, removed the Postgres windows user and removed all registry values I could find. I also shut down my anti virus and anti spyware software that was running (and restarted my computer). When I run the postgres installer (postgresql-8.4.0-1-windows.exe) I get an error about the file postgresSQL.conf not being found. When the installer finishes I have an empty data directory. I also tried installing the data directory in a place other than the program files directory. I have done this a few times now and I'm just not seeing what I'm missing. When I originally installed Postgres 8.3 I didn't use the one click installer. Since then I have upgraded to another 8.3.x without any issues. Christine Penner Ingenious Software 250-352-9495 christ...@ingenioussoftware.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] wrong error from ./configure in pgsql 8.3.8 for libxml
Was building pgsql 8.3.8 from source on a new install of Centos 5.2, and got this error from ./configure --with-libxml : checking for xmlSaveToBuffer in -lxml2... no configure: error: library 'xml2' (version = 2.6.23) is required for XML support But I had libxml2 v 2.6.26 or so installed. The real problem was that libxml2-devel wasn't installed. No big deal, just thought I'd mention it. -- 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] Unicode normalization
Update: The error is of course: The function tries to return str
instead of unicode. It is not str.decode('UTF-8') which causes the error.
Andreas Kalsch schrieb:
No,
I need a solution which is as generic as possible. I use UTF-8 encoded
unicode strings on all levels. This is what I have done so far:
1) Writing a separate Python command line script for testing - works
as expected:
#!/usr/bin/python
import sys
import unicodedata
str = sys.argv[1].decode('UTF-8')
str = unicodedata.normalize('NFKD', str)
str = ''.join(c for c in str if unicodedata.combining(c) == 0)
print str
2) Transfering this to PL/Python:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF-8'))
$$ LANGUAGE plpythonu;
Problem: plpython throws an error, where my commandline script did it
correctly:
# select test('aÄÖÜ');
ERROR: plpython: function test could not create return value
DETAIL: type 'exceptions.UnicodeEncodeError': 'ascii' codec can't
encode character u'\u0308' in position 2: ordinal not in range(128)
I use PG 8.3 and Python 2.5.2. How can I make plpython behaving like
in a normal python environment?
In the end it should look like this:
CREATE TABLE t (
...
ts ts_vector NOT NULL
);
INSERT INTO t (ts) VALUES(to_tsvector(normalize(?)));
Andi
David Fetter schrieb:
On Wed, Sep 16, 2009 at 07:20:21PM +0200, Andreas Kalsch wrote:
Has somebody integrated Unicode normalization into Postgres? if not,
I would have to implement my own function by using this CPAN
module: http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ .
I need a function which removes all diacritics (1) and transforms
some characters to a more compatible form (2) to get a better index
on strings.
Best,
Andi
1) à,ä, ... = a
2) ø = o, ƒ = f, ª = a
You mean something like this?
http://wiki.postgresql.org/wiki/Strip_accents_from_strings%2C_and_output_in_lowercase
Cheers,
David.
--
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] Current state of XML capabilities in PostgreSQL?
I'm looking for the current state of XML capabilities in PostgreSQL and I'm coming up with a lot of confusing links and a bit short on documentation. Postgres' XML is still lacking in a few spots. But the core functionality is certainly there to do all of the every day stuff. The trick with working with XML in the database is to know when to store it as XML and when to shred it into relational tables. If its a structured document (looks like something you'd open in Word) save it as XML. If it looks like something you'd open in Excel then start shredding. And it looks like maybe you want to do a tv guide type thing. That is something you'll want to shred to tables. I'm looking for the functionality that I mentioned above that allowed more comprehensive XML operations but I'm just not finding any documentation for it, if it exists. What exactly is it you are trying to do but cant? Scott -- 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] Unicode normalization
On Wed, Sep 16, 2009 at 09:35:02PM +0200, Andreas Kalsch wrote:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF-8'))
$$ LANGUAGE plpythonu;
I'd guess you want that to be:
return unicodedata.normalize('NFKD', str.decode('UTF-8')).encode('UTF-8');
If you're converting from a utf8 encoding, you probably need to go
back again! This could certainly be made easier though, PG knows what
encoding its strings are stored in, why doesn't it work with unicode
strings by default?
--
Sam http://samason.me.uk/
--
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] Current state of XML capabilities in PostgreSQL?
I have this XML that I don't wish to parse out to tables (BTDT and don't wish to go there for the most part). There might be the uncommon chance where an XML-friendly operation would be very useful. On 9/16/09, Scott Bailey arta...@comcast.net wrote: I'm looking for the current state of XML capabilities in PostgreSQL and I'm coming up with a lot of confusing links and a bit short on documentation. Postgres' XML is still lacking in a few spots. But the core functionality is certainly there to do all of the every day stuff. The trick with working with XML in the database is to know when to store it as XML and when to shred it into relational tables. If its a structured document (looks like something you'd open in Word) save it as XML. If it looks like something you'd open in Excel then start shredding. And it looks like maybe you want to do a tv guide type thing. That is something you'll want to shred to tables. I'm looking for the functionality that I mentioned above that allowed more comprehensive XML operations but I'm just not finding any documentation for it, if it exists. What exactly is it you are trying to do but cant? Scott -- 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] Unicode normalization
On Wed, Sep 16, 2009 at 4:42 PM, Sam Mason s...@samason.me.uk wrote:
On Wed, Sep 16, 2009 at 09:35:02PM +0200, Andreas Kalsch wrote:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF-8'))
$$ LANGUAGE plpythonu;
I'd guess you want that to be:
return unicodedata.normalize('NFKD', str.decode('UTF-8')).encode('UTF-8');
If you're converting from a utf8 encoding, you probably need to go
back again! This could certainly be made easier though, PG knows what
encoding its strings are stored in, why doesn't it work with unicode
strings by default?
Isn't it python that's making the mistake here, not pg?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to simplify unicode strings
Thank you Sam,
this leaded to the correct solution:
CREATE OR REPLACE FUNCTION simplify (str text)
RETURNS text
AS $$
import unicodedata
s = unicodedata.normalize('NFKD', str.decode('UTF-8'))
s = ''.join(c for c in s if unicodedata.combining(c) == 0)
return s.encode('UTF-8')
$$ LANGUAGE plpythonu;
test=# select simplify('Français va à Paris, () {} [] µ @ º Ångstrøm
Phiat-im hû-hō sī phiat tī 1-ê ki-chhó· jī-bó bīn-téng ê hû-hō. Siōng
phó·-phiàn ê kong-lêng sī kái-piàn ki-chhó· jī-bó ê hoat-im.');
simplify
-
Francais va a Paris, () {} [] μ @ o Angstrøm Phiat-im hu-ho si phiat ti
1-e ki-chho· ji-bo bin-teng e hu-ho. Siong pho·-phian e kong-leng si
kai-pian ki-chho· ji-bo e hoat-im.
(1 row)
One question remains: How is the performance of PL/Python?
When there are syntax errors in the Python code, they are not reported
on CREATE, because the function seems be recompiled on every call.
This leads to the next question: When will the unicode stuff included in
the main distribution?
Andi
Sam Mason schrieb:
On Wed, Sep 16, 2009 at 09:35:02PM +0200, Andreas Kalsch wrote:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF-8'))
$$ LANGUAGE plpythonu;
I'd guess you want that to be:
return unicodedata.normalize('NFKD', str.decode('UTF-8')).encode('UTF-8');
If you're converting from a utf8 encoding, you probably need to go
back again! This could certainly be made easier though, PG knows what
encoding its strings are stored in, why doesn't it work with unicode
strings by default?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] oom ( kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 )
I am having a problem with the system freezing when the system is very busy. I have found the entry oom-killer in our messages log. I would like to confirm that the proper way of dealing with this is to set the sysctl parameter below. Also, the kernel parameter for shmmax and shmall are not correct configured, but another system that appears to be configured correctly has the settings below, do they look right? Linux Kernel 2.6.18-53.el5 Is this the fix for this problem? sysctl -w vm.overcommit_memory=2 Proposed ( 16 gigs ) kernel.shmmax=17179869184 kernel.shmall=3774873 x (4096) = 15461879808 .89 = 15461879808/17179869184 Currently ( 16 gigs ) kernel.shmmax = 68719476736 kernel.shmall = 4294967296 x (4096) vi /var/log/messages Sep 16 00:11:43 pgprd kernel: postgres invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 Sep 16 00:11:43 pgprd kernel: Sep 16 00:11:43 pgprd kernel: Call Trace: Sep 16 00:11:43 pgprd kernel: [800bed05] out_of_memory+0x8e/0x2f5 Sep 16 00:11:43 pgprd kernel: [8000f071] __alloc_pages+0x22b/0x2b4 Sep 16 00:11:43 pgprd kernel: [80012720] __do_page_cache_readahead+0x95/0x1d9 Sep 16 00:11:43 pgprd kernel: [800618e1] __wait_on_bit_lock+0x5b/0x66 Sep 16 00:11:43 pgprd kernel: [8003f11a] __lock_page+0x5e/0x64 Sep 16 00:11:43 pgprd kernel: [800130ab] filemap_nopage+0x148/0x322 Sep 16 00:11:43 pgprd kernel: [800087ed] __handle_mm_fault+0x1f8/0xdf4 Sep 16 00:11:43 pgprd kernel: [80064a6a] do_page_fault+0x4b8/0x81d Sep 16 00:11:43 pgprd kernel: [8005bde9] error_exit+0x0/0x84 _ Create a cool, new character for your Windows Live™ Messenger. http://go.microsoft.com/?linkid=9656621
[GENERAL] Segmentation Fault during database restoration
Hi, I am new to PostgreSQL. I have been trying to restore a compressed(.gz) database using gunzip -c *filename*.gz | psql *dbname* After some 8 or 9 tables are restored the program exists giving error: Segmentation Fault. I have attached the crash report below. Process: psql [362] Path:/Library/PostgreSQL/8.4/bin/psql Identifier: psql Version: ??? (???) Code Type: X86 (Native) Parent Process: bash [279] Date/Time: 2009-09-16 23:06:29.065 +0100 OS Version: Mac OS X 10.5.8 (9L30) Report Version: 6 Anonymous UUID: E980E439-11E5-4B08-BBAA-ECABD8719349 Exception Type: EXC_BAD_ACCESS (SIGSEGV) Exception Codes: KERN_INVALID_ADDRESS at 0x014f Crashed Thread: 0 Thread 0 Crashed: 0 psql0xd3b5 gets_fromFile + 296 1 psql0xdf73 MainLoop + 613 2 psql0x00010d7a main + 2394 3 psql0x3fc2 _start + 216 4 psql0x3ee9 start + 41 Thread 0 crashed with X86 Thread State (32-bit): eax: 0x014f ebx: 0xd29c ecx: 0x edx: 0x0150 edi: 0x00302866 esi: 0xb674 ebp: 0xb3b8 esp: 0xbfffef80 ss: 0x001f efl: 0x00010216 eip: 0xd3b5 cs: 0x0017 ds: 0x001f es: 0x001f fs: 0x gs: 0x0037 cr2: 0x014f Binary Images: 0x1000 -0x5243f +psql ??? (???) /Library/PostgreSQL/8.4/bin/psql 0x5c000 -0x7aa0f +libpq.5.2.dylib ??? (???) /Library/PostgreSQL/8.4/lib/libpq.5.2.dylib 0x84000 -0x8dfe3 libpam.1.dylib ??? (???) 18edc8caade04f4f81e1dd9712b51abc /usr/lib/libpam.1.dylib 0x93000 -0xa9fea libedit.2.dylib ??? (???) eb7bc965302ee8d47e585dbbfd82c938 /usr/lib/libedit.2.dylib 0x17b000 - 0x2c2fef +libxml2.2.dylib ??? (???) /Library/PostgreSQL/8.4/lib/libxml2.2.dylib 0x8fe0 - 0x8fe2db43 dyld 97.1 (???) 458eed38a009e5658a79579e7bc26603 /usr/lib/dyld 0x90cde000 - 0x90e45ff3 libSystem.B.dylib ??? (???) ae47ca9b1686b065f8ac4d2de09cc432 /usr/lib/libSystem.B.dylib 0x90e4b000 - 0x90e6ffeb libssl.0.9.7.dylib ??? (???) 3aead3bb2aee39ceff1531c655cdc801 /usr/lib/libssl.0.9.7.dylib 0x91bab000 - 0x91c9fff4 libiconv.2.dylib ??? (???) 96ff4c6f84c4a1623cb78287371cdd3f /usr/lib/libiconv.2.dylib 0x91ca - 0x91cfdffb libstdc++.6.dylib ??? (???) 7d389389a99ce696726cf4c8980cc505 /usr/lib/libstdc++.6.dylib 0x926b1000 - 0x926b5fff libmathCommon.A.dylib ??? (???) /usr/lib/system/libmathCommon.A.dylib 0x92819000 - 0x92844fe7 libauto.dylib ??? (???) 2e44c523b851e8e25f05d13a48070a58 /usr/lib/libauto.dylib 0x9284c000 - 0x9297ffe7 com.apple.CoreFoundation 6.5.7 (476.19) a332c8f45529ee26d2e9c36d0c723bad /System/Library/Frameworks/CoreFoun dation.framework/Versions/A/CoreFoundation 0x92ca2000 - 0x92d54ffb libcrypto.0.9.7.dylib ??? (???) adb50814ede29b88f370b1c8712bc93e /usr/lib/libcrypto.0.9.7.dylib 0x93184000 - 0x93355ffb com.apple.security 5.0.5 (36371) 1f7f48b36bc90d114220cc81e4e4694f /System/Library/Frameworks/Security.framew ork/Versions/A/Security 0x949c8000 - 0x949d6ffd libz.1.dylib ??? (???) a98b3b221a72b54faf73ded3dd7000e5 /usr/lib/libz.1.dylib 0x94c9 - 0x94cbfff7 libncurses.5.4.dylib ??? (???) d14a12e66edb347d4ce52089b17e3d24 /usr/lib/libncurses.5.4.dylib 0x952ae000 - 0x953e7ff7 libicucore.A.dylib ??? (???) dd8aa51c356e79ef8cdfa341a0d69f5b /usr/lib/libicucore.A.dylib 0x956c7000 - 0x956cefe9 libgcc_s.1.dylib ??? (???) e280ddf3f5fb3049e674edcb109f389a /usr/lib/libgcc_s.1.dylib 0x965ae000 - 0x965ccfff libresolv.9.dylib ??? (???) 39f6d8651f3dca7a1534fa04322e6763 /usr/lib/libresolv.9.dylib 0x9663b000 - 0x9671bfff libobjc.A.dylib ??? (???) d1469bf9fe852864d4fff185c72768e8 /usr/lib/libobjc.A.dylib 0x96d3d000 - 0x96dedfff edu.mit.Kerberos 6.0.13 (6.0.13) 6f91042bf8a860731add9dcb09b5cb73 /System/Library/Frameworks/Kerberos.framew ork/Versions/A/Kerberos 0xfffe8000 - 0xfffebfff libobjc.A.dylib ??? (???) /usr/lib/libobjc.A.dylib 0x - 0x1780 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib - any clues?? Regards, Sulman.
[GENERAL] Segmentation fault during restoration of compressed(.gz) database
Hi, I am new to PostgreSQL. I have been trying to restore a compressed(.gz) database using gunzip -c filename.gz | psql dbname After some 8 or 9 tables are restored the program exists giving error: Segmentation Fault. I have attached the crash report below. Process: psql [362] Path:/Library/PostgreSQL/8.4/bin/psql Identifier: psql Version: ??? (???) Code Type: X86 (Native) Parent Process: bash [279] Date/Time: 2009-09-16 23:06:29.065 +0100 OS Version: Mac OS X 10.5.8 (9L30) Report Version: 6 Anonymous UUID: E980E439-11E5-4B08-BBAA-ECABD8719349 Exception Type: EXC_BAD_ACCESS (SIGSEGV) Exception Codes: KERN_INVALID_ADDRESS at 0x014f Crashed Thread: 0 Thread 0 Crashed: 0 psql0xd3b5 gets_fromFile + 296 1 psql0xdf73 MainLoop + 613 2 psql0x00010d7a main + 2394 3 psql0x3fc2 _start + 216 4 psql0x3ee9 start + 41 Thread 0 crashed with X86 Thread State (32-bit): eax: 0x014f ebx: 0xd29c ecx: 0x edx: 0x0150 edi: 0x00302866 esi: 0xb674 ebp: 0xb3b8 esp: 0xbfffef80 ss: 0x001f efl: 0x00010216 eip: 0xd3b5 cs: 0x0017 ds: 0x001f es: 0x001f fs: 0x gs: 0x0037 cr2: 0x014f Binary Images: 0x1000 -0x5243f +psql ??? (???) /Library/PostgreSQL/8.4/bin/psql 0x5c000 -0x7aa0f +libpq.5.2.dylib ??? (???) /Library/PostgreSQL/8.4/lib/libpq.5.2.dylib 0x84000 -0x8dfe3 libpam.1.dylib ??? (???) 18edc8caade04f4f81e1dd9712b51abc /usr/lib/libpam.1.dylib 0x93000 -0xa9fea libedit.2.dylib ??? (???) eb7bc965302ee8d47e585dbbfd82c938 /usr/lib/libedit.2.dylib 0x17b000 - 0x2c2fef +libxml2.2.dylib ??? (???) /Library/PostgreSQL/8.4/lib/libxml2.2.dylib 0x8fe0 - 0x8fe2db43 dyld 97.1 (???) 458eed38a009e5658a79579e7bc26603 /usr/lib/dyld 0x90cde000 - 0x90e45ff3 libSystem.B.dylib ??? (???) ae47ca9b1686b065f8ac4d2de09cc432 /usr/lib/libSystem.B.dylib 0x90e4b000 - 0x90e6ffeb libssl.0.9.7.dylib ??? (???) 3aead3bb2aee39ceff1531c655cdc801 /usr/lib/libssl.0.9.7.dylib 0x91bab000 - 0x91c9fff4 libiconv.2.dylib ??? (???) 96ff4c6f84c4a1623cb78287371cdd3f /usr/lib/libiconv.2.dylib 0x91ca - 0x91cfdffb libstdc++.6.dylib ??? (???) 7d389389a99ce696726cf4c8980cc505 /usr/lib/libstdc++.6.dylib 0x926b1000 - 0x926b5fff libmathCommon.A.dylib ??? (???) /usr/lib/system/libmathCommon.A.dylib 0x92819000 - 0x92844fe7 libauto.dylib ??? (???) 2e44c523b851e8e25f05d13a48070a58 /usr/lib/libauto.dylib 0x9284c000 - 0x9297ffe7 com.apple.CoreFoundation 6.5.7 (476.19) a332c8f45529ee26d2e9c36d0c723bad /System/Library/Frameworks/CoreFoun dation.framework/Versions/A/CoreFoundation 0x92ca2000 - 0x92d54ffb libcrypto.0.9.7.dylib ??? (???) adb50814ede29b88f370b1c8712bc93e /usr/lib/libcrypto.0.9.7.dylib 0x93184000 - 0x93355ffb com.apple.security 5.0.5 (36371) 1f7f48b36bc90d114220cc81e4e4694f /System/Library/Frameworks/Security.framew ork/Versions/A/Security 0x949c8000 - 0x949d6ffd libz.1.dylib ??? (???) a98b3b221a72b54faf73ded3dd7000e5 /usr/lib/libz.1.dylib 0x94c9 - 0x94cbfff7 libncurses.5.4.dylib ??? (???) d14a12e66edb347d4ce52089b17e3d24 /usr/lib/libncurses.5.4.dylib 0x952ae000 - 0x953e7ff7 libicucore.A.dylib ??? (???) dd8aa51c356e79ef8cdfa341a0d69f5b /usr/lib/libicucore.A.dylib 0x956c7000 - 0x956cefe9 libgcc_s.1.dylib ??? (???) e280ddf3f5fb3049e674edcb109f389a /usr/lib/libgcc_s.1.dylib 0x965ae000 - 0x965ccfff libresolv.9.dylib ??? (???) 39f6d8651f3dca7a1534fa04322e6763 /usr/lib/libresolv.9.dylib 0x9663b000 - 0x9671bfff libobjc.A.dylib ??? (???) d1469bf9fe852864d4fff185c72768e8 /usr/lib/libobjc.A.dylib 0x96d3d000 - 0x96dedfff edu.mit.Kerberos 6.0.13 (6.0.13) 6f91042bf8a860731add9dcb09b5cb73 /System/Library/Frameworks/Kerberos.framew ork/Versions/A/Kerberos 0xfffe8000 - 0xfffebfff libobjc.A.dylib ??? (???) /usr/lib/libobjc.A.dylib 0x - 0x1780 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib - any clues?? Regards, Sulman. -- View this message in context: http://www.nabble.com/Segmentation-fault-during-restoration-of-compressed%28.gz%29-database-tp25482391p25482391.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- 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] Regarding initdb pg_ctl
Hey Magnus, I tried out your suggestion, we are providing quotes correctly. We tried out one thing we installed postgresql outside Program Files. When I say installed I want to mean that I copied compiled binaries. User installing is local user belonging to Administrators group. Then we ran initdb utility with data directory to be in same directory (Outside data directory) . So initdb created it correctly. Then we tried to register service using pg_ctl/register options. It worked too. Then we tried to start service so here it failed. But when we tried to ran same scenario with runas /user:local_user pg_ctl start -D Data directory on command prompt, postgres server started without any problem. So I am confused as theoretically both scenarios are same. Since service should be started by same user which is provided later to start postgres through command line. All of these problems are caused only on Windows 2003 Server Enterprise Edition with windows XP everything is fine. Can you provide some inputs on this? Thanks Regards, Vikram -Original Message- From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Tuesday, September 15, 2009 1:19 AM To: Vikram Patil Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Regarding initdb pg_ctl On Tue, Sep 15, 2009 at 03:55, Vikram Patil vpa...@actuate.com wrote: Thanks Magnus for help. Is there any way to start pg_ctl without creating postgres user? I am trying to use same logged in user to run initdb and start service. As per documentation it seems to be allowed after 8.3. We tried to use it the way I describe on Windows XP and it worked without any problem. Certainly, that works fine. Our installer first copies compiled binaries and then try to run initdb as current user. If it worked then we register service with same user and password. Users are defined in Active directory on active directory server ,basically we are using domain\user format to log in and run installation. Once registration is finished, we need to start service. That's a pretty standard thing, it pretty much works. I tried to run initdb with data directory path outside Program Files .It works fine But when data directory path is located inside program files, initdb fails. That should work. Another possibility is that it breaks because you have spaces in the path name, and are not quoting it properly. The quoting rules on Windows can be very strange :-) As per your advice I tried process monitor, it shows that there are no failures. So we can assume it is a issue with permissions. Can you see it opening postgres.exe? Or do you get a not foud error somewhere? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] Segmentation Fault during database restoration
Sulman Sarwar sulmansar...@gmail.com writes: I am new to PostgreSQL. I have been trying to restore a compressed(.gz) database using gunzip -c *filename*.gz | psql *dbname* After some 8 or 9 tables are restored the program exists giving error: Segmentation Fault. That's weird ... gets_fromFile certainly looks pretty bulletproof from here. Can you extract a self-contained test case? Also, did you build the psql executable yourself, or get it from somewhere else, and if so where? 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
Re: [GENERAL] wrong error from ./configure in pgsql 8.3.8 for libxml
Scott Marlowe scott.marl...@gmail.com writes: Was building pgsql 8.3.8 from source on a new install of Centos 5.2, and got this error from ./configure --with-libxml : checking for xmlSaveToBuffer in -lxml2... no configure: error: library 'xml2' (version = 2.6.23) is required for XML support But I had libxml2 v 2.6.26 or so installed. The real problem was that libxml2-devel wasn't installed. Well, in point of fact the library is *not* there so far as configure can tell --- there's no libxml2.so or libxml2.a file. And in any case we're not going to put in anything as platform-specific as suggesting that you might need a -devel RPM (to say nothing of the similar but not identical packaging conventions on other platforms). I think that's just something you have to know about if you're building software on Red Hat-based platforms. 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
Re: [GENERAL] Segmentation Fault during database restoration
On Wed, 2009-09-16 at 23:32 +0100, Sulman Sarwar wrote: Hi, I am new to PostgreSQL. I have been trying to restore a compressed(.gz) database using Just out of interest, how did you install PostgreSQL? Did you install a pre-built binary? If so, from where? Guessing from the paths, it doesn't look like you built it yourself or used something like MacPorts, but it's better to know than guess. I ask in particular because there have been big problems caused by building PostgreSQL as a universal binary. It seems to be important to configure it and build it only for the architecture you're actually using. That probably goes for ia32 vs x86_64 as well as ppc32/ppc64 . -- Craig Ringer
Re: [GENERAL] Segmentation Fault during database restoration
Craig Ringer cr...@postnewspapers.com.au writes: I ask in particular because there have been big problems caused by building PostgreSQL as a universal binary. It seems to be important to configure it and build it only for the architecture you're actually using. That probably goes for ia32 vs x86_64 as well as ppc32/ppc64 . Well, it's possible to do it but it's not easy --- you need to deal with the fact that the configure-generated headers should be different for the different arches. There were some discussions in -hackers last year about how to do it. The reported location of the error is not code that I would expect to be subject to architectural issues, though, so I suspect this isn't immediately relevant. 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
Re: [GENERAL] wrong error from ./configure in pgsql 8.3.8 for libxml
On Wed, Sep 16, 2009 at 8:57 PM, Tom Lane t...@sss.pgh.pa.us wrote: Scott Marlowe scott.marl...@gmail.com writes: Was building pgsql 8.3.8 from source on a new install of Centos 5.2, and got this error from ./configure --with-libxml : checking for xmlSaveToBuffer in -lxml2... no configure: error: library 'xml2' (version = 2.6.23) is required for XML support But I had libxml2 v 2.6.26 or so installed. The real problem was that libxml2-devel wasn't installed. Well, in point of fact the library is *not* there so far as configure can tell --- there's no libxml2.so or libxml2.a file. And in any case Ahhh, I see, the regular rpm installs the libxml2.so, the -devel installs the link to libxml2.so.2.6.26 Got it. -- 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] Unicode normalization
Andreas Kalsch wrote:
2) Transfering this to PL/Python:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF-8'))
$$ LANGUAGE plpythonu;
This is wrong, which is why we published a correct version here:
http://wiki.postgresql.org/wiki/Strip_accents_from_strings
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
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] Segmentation Fault during database restoration
I used one click installer for Mac OSX from EnterpriseDB. http://www.enterprisedb.com/products/pgdownload.do#osx On Thu, Sep 17, 2009 at 4:10 AM, Tom Lane t...@sss.pgh.pa.us wrote: Craig Ringer cr...@postnewspapers.com.au writes: I ask in particular because there have been big problems caused by building PostgreSQL as a universal binary. It seems to be important to configure it and build it only for the architecture you're actually using. That probably goes for ia32 vs x86_64 as well as ppc32/ppc64 . Well, it's possible to do it but it's not easy --- you need to deal with the fact that the configure-generated headers should be different for the different arches. There were some discussions in -hackers last year about how to do it. The reported location of the error is not code that I would expect to be subject to architectural issues, though, so I suspect this isn't immediately relevant. regards, tom lane --
