On Sun, 19 Oct 2003, culley harrelson wrote:
> It seems to me that these values should be the same:
>
> select 'lydia eugenia treviño', convert('lydia eugenia treviño' using
> ascii_to_utf_8);
>
> but they seem to be different. What am I missing?
I don't think the marked n is a valid ascii chara
Hello,
I have a quick question regarding tsearch2, hopefully this is an okay
place to ask because I couldn't find a tsearch2-specific mailing list..
Anyways, when the field which is indexed using tsearch2 is displayed in
it's entirety I want the searched keywords to be highlighted, just as in
a h
On Fri, 17 Oct 2003, Nick Burrett wrote:
> > It would be worth revisiting this and trying to understand where the
> > performance problem is, rather than just assuming that you have to work
> > around it.
>
> Luckily my CVS tree has such information. Basically this database holds
> samples of the
Holger Marzen <[EMAIL PROTECTED]> writes:
> I use PostgreSQL for counting network traffic, I use a sample every five
> minutes. Because my queries became too slow I simply added another table
> that holds the data per day. Every day, yesterday's data get added,
> inserted into the "day"-table and
It is one of the extended characters in iso-8859-1. This data was taken
from a text field in a SQL_ASCII database. Basically what I am trying to
do is migrate data from a SQL_ASCII database to a UNICODE database by
running all the data through an external script that does something like:
select
Stephen wrote:
Good news,
I partially fixed the problem on Linux 2.4. It appears the responsiveness
can be improved significantly by tuning the disk IO elevator in Linux using
"elvtune" in util-linux. The elevator in Linux is used to re-order
read/write requests to reduce disk seeks by ordering r
On Sat, Oct 18, 2003 at 06:48:10PM -0300, Martin Marques wrote:
> We are trying to make some things work with plpgsql. The problem is that I
> built several functions that call one another, and I thought that the way of
> calling it was just making the assign:
>
> var:=func1(arg1,arg2);
Have yo
On Sun, 19 Oct 2003, culley harrelson wrote:
> It is one of the extended characters in iso-8859-1. This data was taken
> from a text field in a SQL_ASCII database. Basically what I am trying to
> do is migrate data from a SQL_ASCII database to a UNICODE database by
> running all the data through
Ok I tried that, still no luck, i set tgdeferrable to 't' for all the constraints as
you can see below. I then put the delete statement within a transaction that set all
constraints to deferred, but still get a referential integrity violation.
I ran this statement:
taupo=# BEGIN;
BEGIN
taupo=#
I'm getting this error on PHP pages:
Warning: pg_connect(): Cannot create new link. Too
many open links (0).
In php.ini, pgsql.max_links = -1. Any idea what the
problem is? Something in postgresql.conf (I haven't
changed anything there yet)?
TIA,
CSN
__
Do you Y
10 matches
Mail list logo