dbTalk Databases Forums  

[BUGS] BUG #2296: select query error.

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2296: select query error. in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sudhakar
 
Posts: n/a

Default [BUGS] BUG #2296: select query error. - 03-02-2006 , 07:26 AM







The following bug has been logged online:

Bug reference: 2296
Logged by: Sudhakar
Email address: sudakars (AT) slashsupport (DOT) com
PostgreSQL version: 7.3.4
Operating system: Linux
Description: select query error.
Details:

Hi,

we are getting the following error while execute select querry.

airlinklive=# select * from ctcasetrack;
ERROR: Invalid page header in block 1391 of ctcasetrack

Kindly help us to resolve the problem.

Thanks in advance
regards
Sudhakar

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote
  #2  
Old   
Qingqing Zhou
 
Posts: n/a

Default Re: [BUGS] BUG #2296: select query error. - 03-03-2006 , 12:49 AM







""Sudhakar"" <sudakars (AT) slashsupport (DOT) com> wrote
Quote:

we are getting the following error while execute select querry.

airlinklive=# select * from ctcasetrack;
ERROR: Invalid page header in block 1391 of ctcasetrack

Page #1391 is corrupted. Check out the following thread to see if you can
save some of your data.

http://archives.postgresql.org/pgsql...2/msg00212.php

Regards,
Qingqing



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.