[Gambas-user] Can't access PostreSQL schemas

[José Luis Castro]

Sorry, Jean-Yves: I have no idea how to do that. Is it necessary? Or -better
answered- when is necessary to declare a "search_path" variable?
Thaks for your help.

2009/9/25 Jean-Yves F. Barbier <12ukwn at ...626...>

> José Luis Castro a écrit :
> > Hi Benoît. Thanks for your kind answer.
> >
> > I must say, however, the database was created and it's maintained using
> the
> > application "PGAdmin", so I can say with absolute security that the table
> > I'm trying to acces has been created, in fact, with a primary key. Also I
> > ran a lot of queries from PGAdmin and everything works just fine; so a
> > priori I think the database and tables are well designed.
> > On the other hand, I tried to access from Gambas 2.16, another table of
> the
> > same database, but a one that is not into the schema (for instance, has
> the
> > same sctructure, keys and indexes) and works fine when using the Edit()
> > method. That's the reason I think this is a problem with schemas.
>
> José, did you set your schema up into the 'search_path' variable ?
>
> --
> Reality is a cop-out for people who can't handle drugs.
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>