RE: Difference between insert by a function and per hand - Mailing list pgsql-odbc

Maybe a difference in the versions I'm using. Postgresql 7.1.2, ODBC
7.01.0005 (get at http://odbc.postgresql.org ) and MS Access 2K. If you can
I'd advise upgrading the postgresql parts of the setup. The only other thing
I can think of is Access getting confused about Primary Keys or similar. Do
you have single field primary keys?
- Stuart

> -----Original Message-----
> From:    DI Hasenöhrl [SMTP:i.hasenoehrl@aon.at]
> Sent:    Friday, June 22, 2001 10:17 AM
> To:    Henshall, Stuart - WCP
> Subject:    Re: Difference between insert by a function and per hand
>
> Hello Stuart,
> I see the data, but I can't update the tuples inserted by the function I
> can update only these tuples, which I inserted in datasheet view.
> My ODBC settings are:
> Driver:
>     Disable Generic Optimizer: yes
>     KSQO: yes
>     Recognize Unique Indexes: yes
>     all others: no
> Data Source:
>     all: no
>     Protocol: 7.X
>
> After enabling Row Versioning and relink, I can't see my data in datasheet
> view, each field contains #name?
> What' this?????
>
> Irina
>
>     ----- Original Message -----
>     From: Henshall, Stuart - WCP
> <mailto:SHenshall@westcountrypublications.co.uk>
>     To: 'DI Hasenöhrl' <mailto:i.hasenoehrl@aon.at>
>     Cc: 'pgsql-odbc@postgresql.org' <mailto:'pgsql-odbc@postgresql.org'>
>
>     Sent: Friday, June 22, 2001 10:58 AM
>     Subject: RE: Difference between insert by a function and per hand
>
>     Hello Irina,
>     I seem to be able to edit when viewing in datasheet. Are you able to
>     see the data?(I was after shift+F9 to refresh the data). I have Row
>     Versioning enabled and find that tends to help Access handle things.
> Also
>     I'm using Access 2K which may not be identical. If you add row
> versioning
>     you'll need to relink you're tables to get the xmin field. What are
> your
>     ODBC settings?
>     - Stuart
>
>     > -----Original Message-----
>     > From: DI Hasenöhrl [ SMTP:i.hasenoehrl@aon.at
> <mailto:SMTP:i.hasenoehrl@aon.at>]
>     > Sent: Friday, June 22, 2001 9:37 AM
>     > To: Henshall, Stuart - WCP
>     > Subject: Re: Difference between insert by a function and per hand
>     >
>     > Hello Stuart,
>     >
>     > I access these rows in the tables datasheet view, because at this
> time I
>     > make experiments but it should work.
>     >
>     > I think, that the tuples of the table are *marked* in a certain
> kind,
>     > because tuples I inserted via datasheet I can update and tuples
> inserted
>     > by function I can't update via datasheet, but I don't see a
> difference.
>     >
>     > Hope you can bring me on the right way ;-)
>     >
>     > Thanks
>     > Irina
>     >
>     > ----- Original Message -----
>     > From: Henshall, Stuart - WCP
>     > < <mailto:SHenshall@westcountrypublications.co.uk>>
>     > To: 'DI Hasenöhrl' < <mailto:i.hasenoehrl@aon.at>> ;
>     > pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org> <
> <mailto:pgsql-odbc@postgresql.org>>
>     > Sent: Friday, June 22, 2001 10:10 AM
>     > Subject: RE: Difference between insert by a function and per hand
>     >
>     > How are you trying to access these rows? If its via a form or
>     > recordset it
>     > may be necessary to requery.
>     > - Stuart
>     >
>     > > -----Original Message-----
>     > > From: DI Hasenöhrl [ SMTP:i.hasenoehrl@aon.at
> <mailto:SMTP:i.hasenoehrl@aon.at>
>     > < <mailto:SMTP:i.hasenoehrl@aon.at>>]
>     > > Sent: Thursday, June 21, 2001 10:00 AM
>     > > To: pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
> < <mailto:pgsql-odbc@postgresql.org>>
>     > > Subject: Difference between insert by a function and per hand
>     > >
>     > > Hello all,
>     > >
>     > > I use postgresql 7.0.2 as backend, ODBC Driver 7.1.003 and
>     > MsAccess97 as
>     > > frontend.
>     > > Now I have the following Problem and hope, someone can help me.
>     > >
>     > > I developed a function in plpgsql, which inserts rows in a table
>     > *price*.
>     > > This function is called from VBA-Code and everything seemed to
> be
>     > OK, but
>     > > then I realized, that I can't change these rows inserted by the
>     > function.
>     > > When I put in rows by the normal way as linked table, I can
> change
>     > these
>     > > rows. Where is the difference to insert rows by a function or
> per
>     > hand.
>     > >
>     > > Has anyone an idea, please let me know.
>     > >
>     > > Thanks in advance
>     > > Irina
>     > >
>     > > E-Mail: i.hasenoehrl@aon.at <mailto:i.hasenoehrl@aon.at> <
> <mailto:i.hasenoehrl@aon.at>> <
>     > < <mailto:i.hasenoehrl@aon.at>>>
>     >
>     >
>
>