On 2009-02-02, Bart Degryse wrote:
>
> --=__PartF6DE34E1.0__=
> Content-Type: text/plain; charset=UTF-8
> Content-Transfer-Encoding: quoted-printable
>
> Thanks for the ideas!
> The function Jasen suggests works partially.
> There are also entities like
> ‘
> ’
> “
> ”
> …
these work fine here.
Hello,
I am trying to migrate from postgresql-8.1.11-1.el5_1.1 (i386) to
postgresql-8.3.4-1.fc10.x86_64. But I can not.
Database uses ltree and tsearch and the problem seems to be this.
I am using,
pg_dump in first computer and psql in second computer to execute script.
First error:
psql:inform
On Wed, 2009-02-04 at 22:57 +0100, F. wrote:
> First error:
> psql:informatica.sql:24: ERROR: no se encuentra la función
> «gtsvector_in» en el archivo «/usr/lib64/pgsql/tsearch2.so»
>
> Anyone know any way to migrate?
Tsearch2 was integrated in core as of 8.3. You will need to read this:
http:
F. wrote:
Hello,
I am trying to migrate from postgresql-8.1.11-1.el5_1.1 (i386) to
postgresql-8.3.4-1.fc10.x86_64. But I can not.
Database uses ltree and tsearch and the problem seems to be this.
I am using,
pg_dump in first computer and psql in second computer to execute script.
First error:
Hi,
I was doing EXPLAIN ANALYZE on a query where I compare against
current_date and noticed the following:
Filter: (date <= ('now'::text)::date)
I knew about now() but did not know about 'now' and have since learnt
of 'today', 'tomorrow', etc. Great!
So, I changed my condition to <= 'now' t
