Re: [GENERAL] "FATAL 1: my bits moved right off the end of theworld!"
> Peter Eisentraut wrote: > > > This is getting to be our favourite error message... > > > > It is caused by a corrupted B-Tree index. Drop and recreate that one. > > Thanks. Unfortunately, the lack of context to the error message makes it difficult > to identify which index is "that one." The message was last showing up during the > process of dropping/recreating a series of triggers and functions via "psql -f" > without any table inserts/updates. > I have fixed 7.0 so it will show the index name. -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROTECTED]| (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [GENERAL] Documentation of nitty gritty stuff.
Hi, Where should I look in the documentation for how to "quote" data for Postgres? e.g. Quoting quotes.. select * from t where x='It''s hard to find' Quoting Likes- trying to find backslashes- select * from t where x like '%\\%' ? Also more information on limits of data/types would be good - serial, character types. Can characters store 8 bit data safely. If not, can we kludge it with numeric.. How to get datetime to show the famed 1 microsecond resolution- "order by" doesn't seem to work. There's quite a bit of good info in the current Postgres docs, but it seems to gloss over some nitty gritty details. Cheerio, Link.
