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

From Henshall, Stuart - WCP
Subject RE: RE: Difference between insert by a function and per ha nd
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F745FA@MAIL_EXCHANGE
Whole thread Raw
Responses RE: RE: Difference between insert by a function and per ha nd
List pgsql-odbc
    Try giving a primary key with just one field (I tend to add 'junk'
serials for this purpose). I seem to hazily recall something about problems
with multiple field primary keys (very hazy can't remember what, where or
why). I have no idea why row versioning isn't working for you. It may be
related to the other problems you've been having. As to Postgresql 7.1.2
I've not had any problems except getting it to run as a service under NT
(runs fine manually on NT).
hope something here helps,
- Stuart


> -----Original Message-----
> From:    DI Hasenöhrl [SMTP:i.hasenoehrl@aon.at]
> Sent:    Friday, June 22, 2001 10:59 AM
> To:    Henshall, Stuart - WCP
> Subject:    Re: [ODBC] RE: Difference between insert by a function and
> per hand
>
> My primary key consists of 3 fields.
>
> Do you know, why I can't use Row Versioning?
> Does Postgresql 7.1.2 run without bugs?
>
> Kind regards,
> 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 11:31 AM
>     Subject: [ODBC] RE: Difference between insert by a function and per
> hand
>
>     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
> <mailto: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'> <
> <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>
>     > < <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>> <
>     > < <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>>
>     > > < < <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>>
>     > < < <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>>> <
>     > > < < <mailto:i.hasenoehrl@aon.at>>>>
>     > >
>     > >
>     >
>     >
>
>     ---------------------------(end of
> broadcast)---------------------------
>     TIP 3: if posting/reading through Usenet, please send an appropriate
>     subscribe-nomail command to majordomo@postgresql.org
> <mailto:majordomo@postgresql.org> so that your
>     message can get through to the mailing list cleanly
>
>

pgsql-odbc by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: RE: Difference between insert by a function and per hand
Next
From: Dariusz Pietrzak
Date:
Subject: RE: RE: Difference between insert by a function and per ha nd