[GENERAL] broken xlog - recovery plan check

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 - curse

RE: [GENERAL] Table Description!!

You could use the COMMENT command. Something like: COMMENT ON TABLE table name IS 'comment'; 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

RE: [GENERAL] Table Description!!

Omid From: Colin Taylor [EMAIL PROTECTED] To: 'Fariba Noorbakhsh' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: [GENERAL] Table Description!! Date: Thu, 5 Jul 2001 08:08:55 +0100 You could use the COMMENT command. Something like: COMMENT ON TABLE table name IS 'comment'; HTH

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

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

[GENERAL] Questions about Synonyms - Again

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] Questions about Synonyms - Again

CTED]] 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 in PostgreSQL that's called a "synonym" per se, so

RE: [GENERAL] Query question

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 my_field

[GENERAL] System Tables Questions

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

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

RE: [GENERAL] Sample Program

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: