RE: UPDATE: ERROR: relation_info: Relation 41069 not fo und - Mailing list pgsql-general

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
> -----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)
> >
> >
> >
> >
> >
>
>
>
>
>