[GENERAL] broken xlog - recovery plan check

2012-03-23 Thread Colin Taylor
Hi I seem to have an 8.3.9 database with a broken xlog, PANIC: heap_insert_redo: invalid max offset number My plan is to run pg_resetxlog. Hopefully it then starts up. Test recent data as thoroughly as possible - (script some Select * ' s?) If ok -> curse ops and their raid caches If not -> curs

RE: [GENERAL] Table Description!!

2001-07-05 Thread Colin Taylor
from pg_tables; > Alter table foo add col descript text ; > > HTH > Omid > > >From: Colin Taylor <[EMAIL PROTECTED]> > >To: "'Fariba Noorbakhsh'" <[EMAIL PROTECTED]>, > >[EMAIL PROTECTED] > >Subject: RE: [GENERAL]

RE: [GENERAL] Table Description!!

2001-07-05 Thread Colin Taylor
You could use the "COMMENT" command. Something like: COMMENT ON TABLE IS ''; HTH, Colin > -Original Message- > From: Fariba Noorbakhsh [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 04 July 2001 14:54 > To: [EMAIL PROTECTED] > Subject: [GENERAL] Table Description!! > > > Hi everybody,

RE: [GENERAL] PostgreSQL: The elephant never forgets UPDATE

2001-06-01 Thread Colin Taylor
Hi, In the Advanced Features section. In the section about Inheritance, there is the following command: INSERT INTO dist_author(a_id, lastname, email, award) VALUES (110, 'Seuss','[EMAIL PROTECTED]', 'National Book Awards); There is a quote (') missing, it should read: INSERT INTO dist_author(

RE: [GENERAL] Questions about Synonyms - Again

2001-01-19 Thread Colin Taylor
MAIL PROTECTED]] > Sent: Friday, January 19, 2001 3:56 PM > To: Colin Taylor > Cc: Pgsql Mailing List (E-mail) > Subject: Re: [GENERAL] Questions about Synonyms - Again > > > Colin Taylor writes: > > > Are Synonyms supported on Postgresql? > > There is nothing

[GENERAL] Questions about Synonyms - Again

2001-01-19 Thread Colin Taylor
Hi, Quick questions, I hope! Are Synonyms supported on Postgresql? If so, how can I list them? Also, If so, what version did they began to be supported? Thanks, Colin

RE: [GENERAL] Query question

2001-01-18 Thread Colin Taylor
SELECT * FROM my_table WHERE my_field LIKE 'A%'; Should do it! > -Original Message- > From: Jorch [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 16, 2001 5:40 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Query question > > > How can I make query > > SELECT * FROM my_table WHERE

[GENERAL] System Tables Questions

2001-01-02 Thread Colin Taylor
Hi, Anyone know where I can get a decent description of the system tables and their contents? Thanks in advance, Colin

[GENERAL] Trouble With Strings

2000-11-23 Thread Colin Taylor
Hi, I have been having a few problems with strings (varchar)s. How can I insert a quote ' character in a string? The following, needless to say does not work: INSERT INTO table (string) VALUES ('colin's'); Also, are there any other characters that need special attention in order to put t

RE: [GENERAL] Sample Program

2000-11-02 Thread Colin Taylor
Found examples in: http://www.postgresql.org/docs/aw_pgsql_book/node188.html These include the techniques that I use at home and have had "few" problems. Have fun. > -Original Message- > From: Nick Fankhauser [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 01, 2000 7:58 PM > To: