RE: UPDATE: ERROR: relation_info: Relation 41069 not fo und

Started by Ryan C. Bonhamover 24 years ago1 messagesgeneral

Ryan@srfarms.com

over 24 years ago

I created a new DSN, and it still gives me the error.. I am really just
waiting for it to dawn on me that i didn soethign really stupid, but untill
then.. As far as the VB snippet, i am Using VB 6.0 and using
dataenvironments. I have a form loading that has some text boxes on it, that
call the dataenronvment. I have a button with the following code on it.

DataEnvironment1.rsTest.Update
Dataenvironment1.rsTest.MoveNext 'This is the line that crashes..

I also have a
Dataenvironment.rsTest.Sort = "col1"
line on the form load that gives me the same error..

On further examination it is not just this form.. I am giong to ro restart
my server.. I did restart PostgreSQL service, but i will see what happens if
i reboot..

Ryan

Show quoted text

-----Original Message-----
From: wsheldah@lexmark.com [mailto:wsheldah@lexmark.com]
Sent: Tuesday, August 21, 2001 11:21 AM
To: Ryan C. Bonham
Subject: RE: [GENERAL] UPDATE: ERROR: relation_info: Relation
41069 not
fo und

You changed a table definition? Try deleting and recreating
the Windows DSN, or
just creating a new DSN and using that one. If that doesn't
work, would you
mind sharing a VB snippet?

"Ryan C. Bonham" <Ryan%srfarms.com@interlock.lexmark.com> on
08/21/2001 11:18:02
AM

To: "Wesley_Sheldahl/Lex/Lexmark.LEXMARK"@sweeper.lex.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: RE: [GENERAL] UPDATE: ERROR: relation_info:
Relation 41069 not fo und

They are running as the same user.... Which tells me it's
something with the
VB Project but.. Nothing else changed, that I know of, except
I added a
field to a table.... This is weird..

-----Original Message-----
From: wsheldah@lexmark.com [mailto:wsheldah@lexmark.com]
Sent: Tuesday, August 21, 2001 11:02 AM
To: Ryan C. Bonham
Subject: Re: [GENERAL] UPDATE: ERROR: relation_info: Relation
41069 not
found

Is it a permissions problem? If you run psql as the same
user as VB uses to
connect, can you select from the view?

"Ryan C. Bonham" <Ryan%srfarms.com@interlock.lexmark.com> on
08/21/2001 10:16:21
AM

To: pgsql-general%postgresql.org@interlock.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] UPDATE: ERROR: relation_info: Relation
41069 not found

Ok, I dumped teh view and recreated it, and now pgadmin and
phppgadmin will
both open the view.. My problem is that Visula Basic will
not.. I get the
same error message as below.. I have tried pointing the
recordset to the
view, i have tried using giving it the select statment
directly, and nothign
seems to work.. Anyone have any ideas??

Hi,

Ok i am lost.. I added a filed to a table, now when i try to
do a select on
that table, or open a view based on that table i get teh
following message.
I get the following message in both phpPGAdmin and PGAdmin
1&2 and my VB
program. Can someone tell me what i did... Thanks..

PostgreSQL said: ERROR: relation_info: Relation 41069 not found

Ryan

---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org

---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)