Обсуждение: Q: pgaccess on macintosh ?

Is there anyone running pgaccess on a Mac?

I tried

pgaccess-0.96
postgres 6.4
Mac Tcl/Tk 8.0.5 on a Power PC

I had the following problems:

1) pgsql.tcl (got it from ftp.flex.ro) script is not
sourced when I put it into the "Tool Command Language" Folder in the
System Extensions (using source pgsql.tcl)

2) I put the code at the beginning of  pgaccess.tcl and got lots of
errors. When I corrected some of them, I could get a connectio to my
database but the following queries didn´t work (due to an error in
pg_result: "pg_result: First argument is not a valid query result.")

Am I using wrong versions, is macintosh not supported by pgaccess, or
is there something substantially wrong in what I do?

Thanks for any help

Kami

--
K. Darabi, M.D.
Neurosurgery
Johannes Gutenberg University Medical School
Mainz, Germany
Phone: +49-(0)-6131-17-7331   Fax: +49-(0)-6131-17-2274
--

I'm new to this list so hello everybody!

The questions:

1) Is there (or is anybody working on) a Borland Delphi TDataset to
provide native access to Postgres databases?
I don't mean using odbc, but directly the Postgres client API.

2) I've got a little confused about Postgres docs talking about
something that I understand as an unique row id (sorry, I'm familiar
with Oracle terms).
Is there such a "rowid"? Is it possible to retrieve it without
explicitely being referred in the sql query?

Excuse my poor English, hope you understand anyway O:)

greetings

    Nico
    nico@clubdelphi.com

On Sun, 18 Apr 1999, Nicolas Aragon wrote:

> I'm new to this list so hello everybody!
>
> The questions:
>
> 1) Is there (or is anybody working on) a Borland Delphi TDataset to
> provide native access to Postgres databases?
> I don't mean using odbc, but directly the Postgres client API.

I don't think so. You're free to write one though...
>
> 2) I've got a little confused about Postgres docs talking about
> something that I understand as an unique row id (sorry, I'm familiar
> with Oracle terms).
> Is there such a "rowid"? Is it possible to retrieve it without
> explicitely being referred in the sql query?

It's called 'oid' and you can retrieve it only by explicitly mentioning
it:

SELECT oid,* FROM t1;

Taral

I was browsing a Delphi share site and found a product for sale that
interfaces to postgres without the BDE!  If I can find the link again I
will let you know.

Taral wrote:

> On Sun, 18 Apr 1999, Nicolas Aragon wrote:
>
> > I'm new to this list so hello everybody!
> >
> > The questions:
> >
> > 1) Is there (or is anybody working on) a Borland Delphi TDataset to
> > provide native access to Postgres databases?
> > I don't mean using odbc, but directly the Postgres client API.
>
> I don't think so. You're free to write one though...
> >
> > 2) I've got a little confused about Postgres docs talking about
> > something that I understand as an unique row id (sorry, I'm familiar
> > with Oracle terms).
> > Is there such a "rowid"? Is it possible to retrieve it without
> > explicitely being referred in the sql query?
>
> It's called 'oid' and you can retrieve it only by explicitly mentioning
> it:
>
> SELECT oid,* FROM t1;
>
> Taral

Hello,

>> 1) Is there (or is anybody working on) a Borland Delphi TDataset...
>I don't think so. You're free to write one though...

That's my intention, but I don't want to reinvent the wheel :)

>> Is there such a "rowid"? Is it possible to retrieve it without
>> explicitely being referred in the sql query?
>It's called 'oid' and you can retrieve it only by explicitly mentioning

So I'll have to parse SQL to include or require the user to do it in
order to be able to write back.

Thank you!

  Nico

Hello,

>I was browsing a Delphi share site and found a product for sale that

Thanks, but I meant open source, I should have told O:)

greetings

   Nico