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
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]
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,
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(
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
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
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
Hi,
Anyone know where I can get a decent description of the system tables and
their contents?
Thanks in advance,
Colin
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
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:
10 matches
Mail list logo