#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    7
    Rep Power
    0

    Unhappy error: relation catalog information: relation 5247696 not found


    help please,

    i'm getting this error message when inserting data on my table. if i do a select of the rows there are actually values in it.

    potgreSQL 6.5.3
    red hat linux 7.2
  2. #2
  3. Me likey breadsticks...
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2003
    Location
    Los Angeles
    Posts
    1,189
    Rep Power
    18
    Can you post your table layout and INSERT query?
    PostgreSQL, it's what's for dinner...
  4. #3
  5. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    Yes, please post an example query and your table structure.

    PostgreSQL 6.5.3 is quite outdated, so I doubt many Devshed members will be familiar with it. I have never used it. But, if this error has suddenly started happening, with no changes in your INSERT queries, then it looks to me like there might be a corruption of your pg_ catalog tables.

    Do a complete dump of your database before attempting anything else, or you might lose data. Browse your logfiles for clues as to when the problem started. Probably the best thing is to then do a complete system backup before dropping your database completely and restoring from dump.

    I strongly recommend you upgrade to a later version of PostgreSQL, because the performance and stability has improved greatly. You might find a few difficulties in upgrading from such an old version of PostgreSQL, though, so you might want to first upgrade to PostgreSQL 7.0.3, and then to 7.3.4, which is the latest stable version. All versions of PostgreSQL are available as source: ftp://ftp8.us.postgresql.org/pub/pgsql/source
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    7
    Rep Power
    0

    re:


    thnx guys. i'll try dumping the schema...i'll ask my DBA to do that.

IMN logo majestic logo threadwatch logo seochat tools logo