7.3b2 strangeness

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: Brian Hirt <bhirt(at)mobygames(dot)com>
Subject: 7.3b2 strangeness
Date: 2002-10-24 15:27:28
Message-ID: 1035473248.22705.202.camel@tex.mobygames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, i recently installed 7.3b2 on my machine to start looking at the
changes and to make sure my code works with the new system in
anticipation of 7.3. I dumped my 7.2 database and reloaded in into
7.3. The dump and resore went fine, and most everything seems to work
great. I did run into a strange thing, where I cannot update one of my
tables. I get "Relation 0 does not exist" Does anyone have any ideas
why this would be happing?

When i shut down 7.3 and startup 7.2 the update works just fine,
datasets are identical.

[root(at)tex moby]# /usr/pg-7.3/bin/psql basement
Welcome to psql 7.3b2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

basement=# update game_review set approved = 5 where moby_user_id = 10;
ERROR: Relation 0 does not exist
basement=# select approved, count(*) from game_review where moby_user_id
= 10 group by approved;
approved | count
----------+-------
1 | 10
(1 row)

basement=# \d game_review
Table "public.game_review"
Column | Type | Modifiers
--------------------+--------------------------+---------------
game_id | integer |
moby_user_id | integer |
summary | character varying(255) |
favorite | text |
least_favorite | text |
review | text |
approved | smallint |
review_timestamp | timestamp with time zone | default now()
platform_id | integer |
points | smallint |
approver_id | integer |
approval_timestamp | timestamp with time zone |
approval_record_id | integer |
Indexes: game_review_primarykey unique btree (game_id, moby_user_id,
platform_id),
game_review_approved btree (approved),
game_review_moby_user_idx btree (moby_user_id)
Triggers: RI_ConstraintTrigger_17133907,
RI_ConstraintTrigger_17133908,
RI_ConstraintTrigger_17133909,
RI_ConstraintTrigger_17134250,
delete_approval_history

basement=#

--
Brian Hirt <bhirt(at)mobygames(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ingo Schellhammer 2002-10-24 15:34:34 Performance on very large indexed tables
Previous Message Juan Jose Comellas 2002-10-24 15:01:13 VACUUM FULL not working with persistent connections in v7.2