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 wrote:
> Craig Ringer writes:
> > I ask in particular because there have been big problems caused by
> > building PostgreSQL as a universa
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 vers
On Wed, Sep 16, 2009 at 8:57 PM, Tom Lane wrote:
> Scott Marlowe 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 >=
Craig Ringer 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/p
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
Scott Marlowe 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 libx
Sulman Sarwar 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
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 ini
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.
---
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.
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 cor
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 plpyth
On Wed, Sep 16, 2009 at 4:42 PM, Sam Mason 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 plpyth
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 wrote:
>> I'm looking for the current state of XML capabilities in Post
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.
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
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 do
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 r
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
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].d
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
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, i
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 compa
[ 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@postg
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
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 Weiterleit
On Wed, Sep 16, 2009 at 5:24 PM, John R Pierce 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?
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 ther
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...@gm
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 maili
2009/9/16 Tom Lane :
> =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= 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
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= 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 o
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@pos
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 -
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
To: Ed Koch; g...@seespotcode.net
Cc: dmag...@gmail.com ; pgsql-general@postgresql.org
Sent: Wed Sep 16 07:24:28
I second that. Why would such a thing be written?
- Original Message -
From: Madison Kelly
To: Martin Gainty
Cc: Ed Koch; g...@seespotcode.net ; dmag...@gmail.com
; pgsql-general@postgresql.org
Sent: Wed Sep 16 07:37:13 2009
Subject: Re: [GENERAL] I need a Postgres Admin $130K + 20K i
If anyone wants to have a MEANINGFUL conversation please respond to me off line
- Gaitly needs attention apparently..
- Original Message -
From: Martin Gainty
To: li...@alteeve.com
Cc: Ed Koch; g...@seespotcode.net ; dmag...@gmail.com
; pgsql-general@postgresql.org
Sent: Wed Sep 16
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
DE
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)
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 val
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 Nachri
Martin Gainty wrote:
lets assume you never take a cab anywhere and you pack enough PB&J 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
lets assume you never take a cab anywhere and you pack enough PB&J 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
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
-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
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 strin
46 matches
Mail list logo
