Re: [GENERAL] tsearch2 frequent updates

On Sat, 23 Jul 2005, Steve Atkins wrote: On Sat, Jul 23, 2005 at 02:37:42PM -0400, Matthew Terenzio wrote: If I'm using Tsearch2 to search a public online forum, do you think it's okay to update on every forum entry? Put another way: is to_tsvector() resource intensive when used in this way?

Re: [GENERAL] temporary tables ?

Thanks for explaination. Zlatko - Original Message - From: Sean Davis [EMAIL PROTECTED] To: Zlatko Matic [EMAIL PROTECTED] Cc: pgsql list pgsql-general@postgresql.org Sent: Sunday, July 24, 2005 1:27 AM Subject: Re: [GENERAL] temporary tables ? What is the influence on database

[GENERAL] pg_resetxlog question

(v 7.4.8 on linux) pg_resetxlog question... I have a idle database (idle = no writes for @12 hours, everything committed, full dump in between) that was shut down cleanly, then imaged to another machine. Forgetting a certain flag in the rsync command, my symlinked pg_xlog didn't make the

[GENERAL] \dt gives ERROR: did not find '}' at end of input node

Please I need help I receive the following error trying to do \dt or \di command in psql. What is wrong and how it can be fixed ? Data in this database are several GB and are vital for me ...

[GENERAL] postgres temporary tables and MS Access

I tried to work with postgres temporary tables from MS Access, but unsuccessfully... I was able to create temporary table by pass-through query, also I succeeded in creating linked table through code, but when I try to open it, an error apears and Access says there is no schema... Also, I

Re: [GENERAL] \dt gives ERROR: did not find '}' at end of input node

On Sun, Jul 24, 2005 at 01:50:38PM +0200, NTPT wrote: I receive the following error trying to do \dt or \di command in psql. What is wrong and how it can be fixed ? Previous reports of this error suggest that the problem might be caused by Gentoo's hierarchical queries patch. Is that

Re: [GENERAL] pg_resetxlog question

Andrew Rawnsley [EMAIL PROTECTED] writes: I have a idle database (idle = no writes for @12 hours, everything committed, full dump in between) that was shut down cleanly, then imaged to another machine. Forgetting a certain flag in the rsync command, my symlinked pg_xlog didn't make the

[GENERAL] Could not convert UTF-8 character to ISO8859-1?

I am trying to copy data from a MSSQL srv to PGSQL srv 8 using Delphi under Windows... But I just keep getting this error... Why? (My PGSQL server is using LATIN1) And how do I get around this? BTW; I see in the log for my PGSQL server that someone is setting Client encoding to UTF-8, but I am

Re: [GENERAL] Could not convert UTF-8 character to ISO8859-1?

As far as I know, UTF-8 is the standard encoding used by MSSQL. ISO8859-1 is LATIN1, so the system is trying to convert (as the error message says) from utf-8 (SqlServer) to ISO8859-1 ( LATIN1 ). So I think you have to search on the MSSQL side, not PostgreSql... You can also use UNICODE

Re: [GENERAL] Could not convert UTF-8 character to ISO8859-1?

I don't think you are correct... UTF-8 might be default on MSSQL, but it is the ODBC connection to PGSQL that sets the client encoding to UTF-8... (I.e. when I just connect to the PGSQL server, I get a statement in the PG log file that says set client_encoding to 'UTF8'.. And I don't want to

Re: [GENERAL] Could not convert UTF-8 character to ISO8859-1?

On Jul 24, 2005, at 1:52 PM, Bjørn T Johansen wrote: I don't think you are correct... UTF-8 might be default on MSSQL, but it is the ODBC connection to PGSQL that sets the client encoding to UTF-8... (I.e. when I just connect to the PGSQL server, I get a statement in the PG log file that

[GENERAL] get sequence from remote server

Hi, is there a way to get a sequence from another Postgres-Server? I have some data servers an one admin server. When a new row is inserted on one of the data servers, the server should ask automatically for a sequence number from the admin server. How can I do this? Maybe using pl/pgsql? thx

Re: [GENERAL] get sequence from remote server

On Jul 24, 2005, at 3:23 PM, Stefan wrote: Hi, is there a way to get a sequence from another Postgres-Server? I have some data servers an one admin server. When a new row is inserted on one of the data servers, the server should ask automatically for a sequence number from the admin

Re: [GENERAL] Can't connect after restart

Another question on the same matter: Do I need XP SP2 for pgSQL 8.0.3 to work correctly? I have all the security patches, but not SP2. No, it shold work fine with both RTM and SP1. (That said, I'd definitly recommend SP2, but that is as a general matter not as a postgresql requirement)

Re: [GENERAL] PostgreSQL + windows xp + ipv6

Hi, I am with problems to function postgreSQL 8.0.3 in windows XP with the Ipv6 protocol. I try to have access the bank in the following way: psql -h ::1 -d db_teste -u postgres but it gives an error: could not translate ::1: Unknown host. already I configured the archive pg_hba.conf so

Re: [GENERAL] Bad locking with MS-Access

Ets ROLLAND schrieb: For all the data created BEFORE the transfert to PostgreSQL, all works fine. For the records created SINCE this transfert, it is impossible to modify or delete these records !? MS-Access say that The record is acceded by an other user, even I am the only user. As

Re: [GENERAL] Could not convert UTF-8 character to ISO8859-1?

Yes, that did the trick... I tried to execute the same statement at the same time as I did the insert, but it needed to be in a separate statement Thx :) BTJ John DeSoi wrote: On Jul 24, 2005, at 1:52 PM, Bjørn T Johansen wrote: I don't think you are correct... UTF-8 might be

Re: [GENERAL] Problems compiling Postgresql 8.0.3 on 10.4

Vivek Khera wrote: On Jul 20, 2005, at 3:37 AM, Jamie Deppeler wrote: Hi, i have just installed 10.4 on one of our machines and cannot get past this error during make gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith - Wendif-labels -fno-strict-aliasing -dynamiclib