Re: [GENERAL] bytea columns and large values

Hey Merlin, The lo interface sucks but it's slightly better on resources for > really huge bytea and tends to be more consistently implemented in > database drivers. If I was doing this, I would of course be crafting > a carefully generated client in C, using libpqtypes, which is the gold > stand

Re: [GENERAL] how to install 9.1 on non-graphical server?

On Fri, 2011-09-23 at 02:46 +0200, Andreas wrote: > is there a way to install the EnterpriseDB V9.1 release on a server > without X-Windows? You can run the installer with --mode text parameter. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.co

Re: [GENERAL] How to find freak UTF-8 character?

On Sat, Oct 01, 2011 at 07:55:01AM +0200, Leif Biberg Kristensen wrote: > I've somehow introduced a spurious UTF-8 character in my database. When I try > to export to an application that requires LATIN1 encoding, my export script > bombs out with this message: > > psycopg2.DataError: character 0

Re: [GENERAL] bytea columns and large values

On Sat, Oct 1, 2011 at 4:27 AM, Dmitriy Igrishin wrote: > Hey Merlin, > >> The lo interface sucks but it's slightly better on resources for >> really huge bytea and tends to be more consistently implemented in >> database drivers.  If I was doing this, I would of course be crafting >> a carefully

Re: [GENERAL] bytea columns and large values

2011/10/2 Merlin Moncure > On Sat, Oct 1, 2011 at 4:27 AM, Dmitriy Igrishin > wrote: > > Hey Merlin, > > > >> The lo interface sucks but it's slightly better on resources for > >> really huge bytea and tends to be more consistently implemented in > >> database drivers. If I was doing this, I wo

Re: [GENERAL] How to find freak UTF-8 character?

On Saturday 1. October 2011 21.29.45 Andrew Sullivan wrote: > I see you found it, but note that it's _not_ a spurious UTF-8 > character: it's a right-to-left mark, ans is a perfectly ok UTF-8 code > point. Andrew, thank you for your reply. Yes I know that this is a perfectly legal UTF-8 character

[GENERAL] SQL Help - Finding Next Lowest Value of Current Row Value

Greetings, I have a large table (~19 million records). Records contains a field identifying a vessel and a field containing an time (epoch). Using the current rows vessel and time values, I need to be able to find the next lowest time value for the vessel and use it to compute how much time has el

[GENERAL] Log-Info Replication

Hello. I tried to use replication with version 9.1. But i get always the Error FATAL: falsche Pr?fsumme in Kontrolldatei I think, it would be good get a hint on a server with 'hot_standby = on' "if you try to replicate: it is not possible to replicate between 32 and 64bit" thanks andreas --

Re: [GENERAL] SQL Help - Finding Next Lowest Value of Current Row Value

On Sat, Oct 1, 2011 at 2:30 PM, Jeff Adams wrote: > Greetings, > > I have a large table (~19 million records). Records contains a field > identifying a vessel and a field containing an time (epoch). Using the > current rows vessel and time values, I need to be able to find the next > lowest time v

[GENERAL] Searching for "bare" letters

Hi, everyone.  I'm working on a project on PostgreSQL 9.0 (soon to be upgraded to 9.1, given that we haven't yet launched).  The project will involve numerous text fields containing English, Spanish, and Portuguese.  Some of those text fields will be searchable by

Re: [GENERAL] Searching for "bare" letters

On Sun, 2011-10-02 at 01:25 +0200, Reuven M. Lerner wrote: > Hi, everyone. I'm working on a project on PostgreSQL 9.0 (soon to be > upgraded to 9.1, given that we haven't yet launched). The project > will involve numerous text fields containing English, Spanish, and > Portuguese. Some of those

Re: [GENERAL] Searching for "bare" letters

> Hi, everyone. I'm working on a project on PostgreSQL 9.0 (soon to be > upgraded to 9.1, given that we haven't yet launched). The project will > involve numerous text fields containing English, Spanish, and Portuguese. > Some of those text fields will be searchable by the user. That's easy >

Re: [GENERAL] Searching for "bare" letters

One approach would be to "normalize" all the text and search against that. That is, basically convert all non-ASCII characters to their equivalents. I've had to do this in Solr for searching for the exact reasons you've outlined: treat "ñ" as "n". Ditto for "ü" -> "u", "é" => "e", etc. This is

Re: [GENERAL] Change server encoding after the fact

Thanks y'all for your help on this. I took this opportunity to upgrade to 9.1.1 which is UTF8 by default and I ended up manually cleaning up the borked data by hand (there wasn't that much). So all is well now. Thanks again. /Cody On Fri, Sep 30, 2011 at 3:37 PM, Scott Marlowe wrote: > On F

Re: [GENERAL] SQL Help - Finding Next Lowest Value of Current Row Value

On Sat, Oct 1, 2011 at 5:30 PM, Jeff Adams wrote: > Greetings, > > I have a large table (~19 million records). Records contains a field > identifying a vessel and a field containing an time (epoch). Using the > current rows vessel and time values, I need to be able to find the next > lowest time

[GENERAL] Why PGSQL has no developments in the .NET area?

PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish. The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC driver is not the right choice for ORM framework of .NET. I want to know whether there is any efficient .NET provider and is PGSQL compatible with

Re: [GENERAL] Why PGSQL has no developments in the .NET area?

Rohit Coder wrote: PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish. The ODBC driver works better as compared to NPGSQL, but I suspect the ODBC driver is not the right choice for ORM framework of .NET. I want to know whether there is any efficient .NET provider and is P