Hello.
I was asked a simple question. We have table employees:
\d employees
Table "public.employees"
Column |Type |
Modifiers
+-+-
On sön, 2011-10-02 at 15:45 -0400, Joseph S wrote:
> Mismatch of relation names: database "dbname", old rel
> pg_toast.pg_toast_1280475, new rel pg_toast.pg_toast_1202320
> Failure, exiting
This will be fixed in 9.1.2 (or get the code already from git).
--
Sent via pgsql-general mailing list (p
At 01:25 02/10/2011, 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 text fields w
I've tried the upgrade a few times, but I always get one type of failure
or another.
Performing Consistency Checks
-
Checking current, bin, and data directories ok
Checking cluster versions ok
Checking database user is a
2011/9/28, Merlin Moncure :
>
> I disagree. unnest() and array_agg() (or, even better, array()
> constructor syntax) are an absolute joy to work with and thinking in a
> more functional way, which is usually the key to making things run
> quickly. Also both functions are trivial to emulate in use
>> I don't see the problem - you can have a dictionary, which does all work
>> on recognizing bare letters and output several versions. Have you seen
>> unaccent
>> dictionary ?
>
> This seems to be the direction that everyone is suggesting, and I'm quite
> grateful for that. (I really hadn't ever
>> 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
>> co
Hi,
On Sun, 2011-10-02 at 12:41 +0200, r d wrote:
>
> I decided to install the PGDG repo (pgdg-fedora91-9.1-5.noarch) to
> make it update. It does not.
Fedora/Red Hat distro RPMs a only binary compatible since last year. I
broke package compatibility by enabling multiple version installation.
I downloaded both postgresql-9.1.1-1-windows-x64-binaries.zip and
postgresql-9.1.1-1-windows-binaries.zip, running on Simplified Chinese
Windows XP Professional x64.
The output of `psql --help`(x64) is UTF-8 encoded, they will be displayed as
malformed characters in command prompt window.
psql
On Sunday 2. October 2011 17.54.52 Raymond O'Donnell wrote:
> I may have missed it upthread, but if you haven't already would you
> consider writing up your solution for the benefit of the archives?
I did, in my own first reply to the original message:
SELECT * FROM foo WHERE bar LIKE E'%\xe2\x80
On 02/10/2011 15:55, Leif Biberg Kristensen wrote:
> On Sunday 2. October 2011 16.34.27 Cédric Villemain wrote:
>> you may have miss this one :
>> http://tapoueh.org/blog/2010/02/23-getting-out-of-sql_ascii-part-2.html
>
> That's an, uh, interesting article, but as far as I can see, it doesn't tel
Hi, Oleg. You wrote:
I don't see the problem - you can have a dictionary, which does all work
on recognizing bare letters and output several versions. Have you seen
unaccent
dictionary ?
This seems to be the direction that everyone is suggesting, and I'm
quite grateful for that. (I really h
On Sunday 2. October 2011 16.34.27 Cédric Villemain wrote:
> you may have miss this one :
> http://tapoueh.org/blog/2010/02/23-getting-out-of-sql_ascii-part-2.html
That's an, uh, interesting article, but as far as I can see, it doesn't tell
anything about how to find a perfectly legal three-byte
Hi Sim,
On 10/02/2011 08:02 AM, Sim Zacks wrote:
> If I understand plpython correctly, it uses the python installed on the
> machine. In other words, plpythonu doesn't support the new style
> classes, it depends on what version of python is installed.
Well, Python has had new style classes since
2011/10/2 Leif Biberg Kristensen :
> On Sunday 2. October 2011 15.53.50 pasman pasmański wrote:
>> Its simple to remove strange chars with regex_replace.
>
> True, but first you have to know how to represent a «strange char» in
> Postgresql :P
>
> It isn't all that obvious, and it's difficult to s
On Sunday 2. October 2011 15.53.50 pasman pasmański wrote:
> Its simple to remove strange chars with regex_replace.
True, but first you have to know how to represent a «strange char» in
Postgresql :P
It isn't all that obvious, and it's difficult to search for the solution. I
tried a lot of dif
Its simple to remove strange chars with regex_replace.
2011/10/1, Leif Biberg Kristensen :
> 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
>> po
On 09/30/2011 05:10 AM, Joe Abbate wrote:
Although there are no discussions or examples in the documentation, I've
determined that PL/Python supports Python new style classes like class
Test(object), and import of standard modules.
Now, in order for to_yaml/to_map to do its
On 10/01/2011 10:32 PM, 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
Hi,
I would like to know which if any is a recommended install and upgrade
method.
My situation is summarized as:
I currently have Postgresql 9.0.4 installed via the Fedora Core FC15 yum
repo, and 9.1.x is not there (yet).
I decided to install the PGDG repo (pgdg-fedora91-9.1-5.noarch) to make
I don't see the problem - you can have a dictionary, which does all work on
recognizing bare letters and output several versions. Have you seen unaccent
dictionary ?
Oleg
On Sun, 2 Oct 2011, Uwe Schroeder wrote:
Hi, everyone. Uwe wrote:
What kind of "client" are the users using? I assume yo
> Hi, everyone. Uwe wrote:
> > What kind of "client" are the users using? I assume you will have some
> > kind of user interface. For me this is a typical job for a user
> > interface. The number of letters with "equivalents" in different
> > languages are extremely limited, so a simple matching
Jeff Adams wrote on 01.10.2011 23:30:
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 an
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 text fiel
Hi, everyone. Uwe wrote:
What kind of "client" are the users using? I assume you will have some kind
of user interface. For me this is a typical job for a user interface. The
number of letters with "equivalents" in different languages are extremely
limited, so a simple matching routine in the
25 matches
Mail list logo
