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
-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
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
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
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
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
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
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
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
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;
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
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;
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
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
=?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
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
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
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:
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
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
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
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
[ 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
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
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
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
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 =
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
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
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
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
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
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
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
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
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
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.
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
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 ...
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
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
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
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:
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
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
46 matches
Mail list logo