Connect without queries?

Hi -

I am attempting to connect to a Postgres-like database with PGODBC.
The driver seems to be able to communicate with the server, but it
complains that the pg_type table could not be found (hardly
surprising - none of the PG metadata tables are there).

Is there some way to just turn the driver into a data conduit? Just
open a connection, make queries and get back data?

TIA,


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Connect without queries?

Richard Wesley wrote:
> Hi -
>
> I am attempting to connect to a Postgres-like database with PGODBC. The
> driver seems to be able to communicate with the server, but it complains
> that the pg_type table could not be found (hardly surprising - none of
> the PG metadata tables are there).
>
> Is there some way to just turn the driver into a data conduit? Just
> open a connection, make queries and get back data?

Not likely, PGODBC requires libpq which is going to at some level try to
communicate with the server beyond the protocol.

Joshua D. Drake


>
> TIA,
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Connect without queries?

Joshua D. Drake wrote:
> Richard Wesley wrote:
>> Hi -
>>
>> I am attempting to connect to a Postgres-like database with PGODBC. The
>> driver seems to be able to communicate with the server, but it complains
>> that the pg_type table could not be found (hardly surprising - none of
>> the PG metadata tables are there).
>>
>> Is there some way to just turn the driver into a data conduit? Just
>> open a connection, make queries and get back data?
>
> Not likely, PGODBC requires libpq which is going to at some level try to
> communicate with the server beyond the protocol.

It doesn't require libpq, but it will still be looking for catalogues.

I'm interested to know what a 'postgres-like' database is though -
especially one that doesn't have any catalogues.

/D

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Connect without queries?

Dave Page wrote:
> Joshua D. Drake wrote:
>> Richard Wesley wrote:
>>> Hi -
>>>
>>> I am attempting to connect to a Postgres-like database with PGODBC. The
>>> driver seems to be able to communicate with the server, but it complains
>>> that the pg_type table could not be found (hardly surprising - none of
>>> the PG metadata tables are there).
>>>
>>> Is there some way to just turn the driver into a data conduit? Just
>>> open a connection, make queries and get back data?
>> Not likely, PGODBC requires libpq which is going to at some level try to
>> communicate with the server beyond the protocol.
>
> It doesn't require libpq, but it will still be looking for catalogues.

Oh did you guys go back to the protocol speak in the current version?

Sincerely,

Joshua D. Drake

>
> I'm interested to know what a 'postgres-like' database is though -
> especially one that doesn't have any catalogues.
>
> /D
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Connect without queries?

Joshua D. Drake wrote:
> Dave Page wrote:
>> Joshua D. Drake wrote:
>>> Richard Wesley wrote:
>>>> Hi -
>>>>
>>>> I am attempting to connect to a Postgres-like database with PGODBC. The
>>>> driver seems to be able to communicate with the server, but it complains
>>>> that the pg_type table could not be found (hardly surprising - none of
>>>> the PG metadata tables are there).
>>>>
>>>> Is there some way to just turn the driver into a data conduit? Just
>>>> open a connection, make queries and get back data?
>>> Not likely, PGODBC requires libpq which is going to at some level try to
>>> communicate with the server beyond the protocol.
>> It doesn't require libpq, but it will still be looking for catalogues.
>
> Oh did you guys go back to the protocol speak in the current version?

Yes, we support v3.0 natively now, but can dynamically load libpq for
connection setup if the user wants to use, pgpass,
Kerberos or SSL.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq