[Pgpool-general] pgpool3.3

[Paul Robert Marino]

OIDs are internaly generated by the database server there for there is no
way for pgpool to replicate them and in postgresql-8.x the existance of an
oid number for a row is optional and turned off by default. the best bet is
to avoid querying them







On 5/25/07, Julio Leyva <jcleyva at hotmail.com> wrote:
>
> Hi all
>
> I installed pgpool 3.3 and I having a problem when I try to check the
> description for a table
>
>
> psql -p 9999 test
>
> \d numbers
>
> Did not find any relation with OID 645204768. (I got this error message)
>
> Then for the same table
>
> \d numbers
>
> Did not find any relation with OID 26726. (This error message , note that
> the OID is different
>
> again the same table
>
> \d numbers (I got a differente output)
>
> Indexes:
>     "pk_cbntransaction" PRIMARY KEY, btree (transactionid)
>     "ix_drawid_transaction" btree (drawid)
>     "ix_onlinetick_cbntrans" btree (onlineticketid)
>     "ix_referenceid_transac" btree (referenceid)
>     "ix_terminalid_transaction" btree (terminalid)
>     "ix_transaction_date" btree (transactiondate)
> Foreign-key constraints:
>     "fk_cbntrans_reference_draw" FOREIGN KEY (drawid) REFERENCES
> draw(drawid) ON UPDATE RESTRICT ON DELETE RESTRICT DEFERRABLE INITIALLY
> DEFERRED
>     "fk_cbntrans_reference_game" FOREIGN KEY (gameid) REFERENCES
> game(gameid) ON UPDATE
>
> In this it shows me indexes and foreign keys , but never shows the
> columns,
> so I don't know what's going on here..
>
> Thanks a lot
>
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20070525/eae332c4/attachment.html