Re: [Gambas-user] Can't access PostreSQL schemas

2009-09-25 Thread 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 <12u...@gmail.com> > José Luis Castro a écrit : > > Hi Benoît. Thanks for yo

Re: [Gambas-user] Can't access PostreSQL schemas

2009-09-25 Thread José Luis Castro
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

[Gambas-user] Can't access PostreSQL schemas

2009-09-23 Thread José Luis Castro
Hi. I've created a schema in a PostreSQL database. The sintax for accessing data from the schema is: schema.tableName That works fine when trying with .exec method (i.e. "SELECT * FROM schema.tableName" or "INSERT INTO schema.tableName VALUES..."), but it doesn't work when I try to use the .edit me

[Gambas-user] Problem accessing PostreSQL schemas

2009-09-17 Thread José Luis Castro
Hola. Cree un esquema en una base de datos PostgreSQL. La sintaxis para acceder a los datos del esquema es: esquema.NombreTabla. Funciona bien cuanto utilizo el método .exec (p.e: "SELECT * FROM schema.tableName" or "INSERT INTO schema.tableName VALUES..."), pero no funciona cuando intento utilizar