Re: [GENERAL] BTree max row size?

On Tue, Dec 21, 2004 at 12:51:05PM -0500, Ernest Kim wrote: > > I'm trying to use the tiki-wiki software. It has several indexes > which store the web page's data as an index criteria. The problem > comes up when a web page is a large web page. It can't store the page > in the index. > > Do

Re: [GENERAL] [sfpug] Basic problem installing TSearch2 (full text

Jon, > SHOW server_encoding; > /* above command displays: SQL_ASCII */ > update pg_ts_cfg set locale = 'SQL_ASCII' where ts_name = 'default' Are you sure your locale is SQL_ASCII and not en_US? --Josh ---(end of broadcast)--- TIP 8: explain a

Re: [GENERAL] default index for primary key of a table

[EMAIL PROTECTED] writes: > Postgres automatically creates index for Primary key of a table. I want to > turn this off, so that the default index is not created for primary key. > How can I do this?? Postgres does not support UNIQUE constraints (and PRIMARY KEY implies a UNIQUE constraint) with

Re: [GENERAL] 8.0 Beta3 worked, RC1 didn't!

Yes, this is exactly the same behaviour as mine. I've also seen the exact same entries in the log file (tested this last night). Many, many of these entries spanning only a couple of seconds. Does anyone have any ideas I can try to rectify this problem? Thanks, Peter -Original Message--

Re: [GENERAL] loading only few rows from huge table

On Wed, Dec 22, 2004 at 11:31:59 -0800, Mark <[EMAIL PROTECTED]> wrote: > Hi, > I have a table with 100K rows. One of columns is a timestamp and > indicates when this row inserted. > > What will the the best way of getting 10 latest rows from that table > and introducing partial data retrieval

Re: [GENERAL] ISO_8859_8 encoding

"Sim Zacks" <[EMAIL PROTECTED]> writes: > Error: Could not access file "$libdir/utf8_and_iso8859": No such file or > directory. The file utf8_and_iso8859.so is in the /usr/local/pgsql/lib > directory. Is there somewhere I have to assign the $libdir variable or is > this something else completely?

Re: [GENERAL] BTree max row size?

I'm trying to use the tiki-wiki software. It has several indexes which store the web page's data as an index criteria. The problem comes up when a web page is a large web page. It can't store the page in the index. Do you know of another way of dealing with this issue aside from re-compiling

[GENERAL] ISO_8859_8 encoding

PG 8.0 Beta 1 I created a new database with ISO_8859_8 encoding and I am getting an error of: Error: Could not access file "$libdir/utf8_and_iso8859": No such file or directory. The file utf8_and_iso8859.so is in the /usr/local/pgsql/lib directory. Is there somewhere I have to assign the $libdir v

[GENERAL] default index for primary key of a table

Hi, Postgres automatically creates index for Primary key of a table. I want to turn this off, so that the default index is not created for primary key. How can I do this?? Regards, Vinita Bansal

[GENERAL] 8.0 Beta3 worked, RC1 didn't!

I have the same problem ! When I setup Postgres 8.0 Beta 4 on a Windows Xp or 2003 Server, it works parfectly with parameter listen_adresses set to '*' or localhost. I have been testing Beta5, RC1 and RC2 on my XP workstation and there is no problem, event if I accept external connections ( listen

[GENERAL] loading only few rows from huge table

Hi, I have a table with 100K rows. One of columns is a timestamp and indicates when this row inserted. What will the the best way of getting 10 latest rows from that table and introducing partial data retrieval (rows 50-60, 100- 120, etc) Thanks, Mark.

Re: [GENERAL] Caching/Indexing Function Output

> On Thu, Dec 23, 2004 at 01:22:42PM -0800, Mike wrote: > > > My question is- is there anyway, since a call to sp_host('10.0.0.1') will > > always > > return the same value (the primary key/sequence value from the ip_addresses > > table), to cache/index that value somehow, so anytime I ever call th