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

From: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
To: wsheldah(at)lexmark(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: UPDATE: ERROR: relation_info: Relation 41069 not fo und
Date: 2001-08-21 19:36:50
Message-ID: 19AB8F9FA07FB0409732402B4817D75A038A8A@FILESERVER.SRF.srfarms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lexmark(dot)com [mailto:wsheldah(at)lexmark(dot)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(dot)com(at)interlock(dot)lexmark(dot)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(at)lexmark(dot)com [mailto:wsheldah(at)lexmark(dot)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(dot)com(at)interlock(dot)lexmark(dot)com> on
> > 08/21/2001 10:16:21
> > AM
> >
> > To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)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(at)postgresql(dot)org
> > >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to
> > majordomo(at)postgresql(dot)org)
> >
> >
> >
> >
> >
>
>
>
>
>

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-08-21 19:39:00 Re: macaddr data type issue
Previous Message Carlos Felipe Zirbes 2001-08-21 19:16:30 RE: New RPMS ?