[Babase] how do regular users append to tables

Karl O. Pinc kop at meme.com
Thu Dec 6 15:51:50 EST 2007


On 12/06/2007 02:39:50 PM, kfenn wrote:
> Karl O. Pinc wrote:
>> It's up to the person who creates the table to grant
>> permission.
> Its my recollection that I was the owner of both fecal tables for  
> which I tried the upload program.  I think the error messages  
> suggested that the program wasn't finding the table, but I'll go back  
> and try to run it again checking everything you have suggested with  
> the permissions.

I suspect the problem is that the upload program does not ask
for a schema.  We could have it ask, or when you want to
upload into some other schema you can qualify the table
name with the schema name.  (fecal.allmales)

> 
> There is no such thing as "the end of a table".  The current PPA
>> browse displays the rows in the order they happen to come out.
>> Usually the come out in the same order, but that could change
>> at any time.  I think the right approach is to modify PPA so that
>> the rows browse in id number order.  (Technically, an ascending
>> sort of the primary key.  All our tables have primary keys.)
> I understand, but its a hard transition to make for regular users.   
> No one like it when I tell them that "browsing the tables is like a  
> box of chocolates....you just never know what you're going to get".   
> So yes, lets investigate a default browse by primary key.

Ok.

>> FYI, for the record.
>> In addition to the upload program and the import PPA feature
>> there's also the SQL "COPY FROM" statement.  All these put
>> data in table.  (There's also using INSERT to put the results of
>> a query into a table.)
>> 
> Thanks, I will try these out.

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