[GENERAL] tsearch2 problems / limitations

Hi, I've successfully added tsearch2 to an existing database and the speedup of searches is brilliant. I'm now trying to extend this to other parts of our system. One of the tables holds reasonable amounts of text, some fields hold up to 2Mb. When I try and run UPDATE table SET idxfti=to_tsvec

Re: [GENERAL] CREATE TABLE problem in plpgsql trigger

James Croft wrote: The problems seems to be with the table_name arg being a variable and not a literal but can't see how to fix this. If anyone knows what's going on here or has any pointers it would be appreciated. Thanks, James Sorry, I'm running PgSQL 7.4.7 on RedHat Ent

[GENERAL] CREATE TABLE problem in plpgsql trigger

Hi all, I'm trying to create a trigger function for a few tables that will store old versions of rows prior to any update on them. Part of the function needs to creates other tables (the table to store these snapshots in). When this trigger runs I get the and error of 'syntax error at or near "

Re: [GENERAL] CREATE TABLE problem in plpgsql trigger

Stephan Szabo wrote: On Thu, 19 May 2005, James Croft wrote: Hi all, I'm trying to create a trigger function for a few tables that will store old versions of rows prior to any update on them. Part of the function needs to creates other tables (the table to store these snapshots in). When

[GENERAL] Temp tables as session var containers

Hi, I've seen the session variable question pop up a fair bit on this list. The temporary table solution seems good but I've got a question before using it... - My app creates a temp table for session vars - UPDATE, INSERT and DELETE triggers on tables use this data My question is: If I run a qu

[GENERAL] PostgreSQL release schedule

Hi, Does anyone know if there is a publicly available release schedule for upcoming versions of PostgreSQL along with proposed new functionality? In a month or so I'm going to start on updating an app from Pg7.1 and would like to know if should start writing for Pg8.0 or if 8.1 is around the

Re: [GENERAL] PostgreSQL release schedule

Scott Marlowe wrote: I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it needs to take to come out, which could be anything, but will likely be no earlier than the end of the year. I believe there was talk about an 8.1 coming out to replace the caching algorithm, but I believ

Re: [GENERAL] PostgreSQL release schedule

Marc G. Fournier wrote: I'd almost think taht this shuld be much more prominently put in a section on the main page of the web site, actually ... make it nice and visible instead of buried on a sub page ... I agree it would be good to have a link on the main page. Possibly near "What's ne

[GENERAL] Temporary table visibility

Hi all, I've had a look at through the list archives but haven't found an answer to this one. Any suggestions appreciated (aside from ones suggesting that I should not need to do this ;-)... - A normal table foo is created in a database. - Clients connect to the database, some create a tem

Re: [GENERAL] Temporary table visibility

On 25 Jan 2006, at 14:17, Jaime Casanova wrote: How can I determine what temporary tables exist in my session, bearing in mind that other sessions contain temp tables using the same names? just the ones you have created in your session, temporary tables in other sessions are invisible to you