[Babase] Saving query output as a table

Karl O. Pinc kop at meme.com
Thu Jun 1 11:53:10 EDT 2006


On 06/01/2006 10:18:38 AM, Leah Gerber wrote:

> No, that was not the problem. I had thought of that. I can't figure  
> out what was going on. I closed the browser and logged in again. Now  
> the same query works. That is strange.

I see what is going on here.

Phppgadm is altering your search path depending upon what
schema you are in.  If you click on a schema, say, to
look at the names of the tables on the right
hand side of the page, it puts that schema
first in the search path when you call up a SQL window.
The default order is babase, sandbox, yourname
but it gets shuffled around by phppgadmin.
If you can make a table in the scheme at the front,
it works.  Otherwise you have to qualify the table
with the schema.

At any rate, that's what's going on with Catherine.
Qualifying the table with the schema should _always_ work.
Leah's difficulties feel like they're related,
but maybe not.  Leah, did you perhaps not click
on any database at all?  That might do it.

Does this make sense to everybody?

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list