[Babase] Queries that run forever

Karl O. Pinc kop at meme.com
Wed Apr 4 00:55:38 EDT 2007


I'm running vacuum analyze now.  It takes a while.

On 04/03/2007 11:43:25 PM, Tyler Brock wrote:
> 
> INSERT INTO ranks VALUES (nextval('ranks_rnkid_seq'::regclass),  
> 'ALI', '1984-1-01', '1.0', 'ADF', '1');

If you list the columns you can then leave off the
rnkid column and allow the sequence to pick up
the default.  (If for some reason you need
the generated id you can get it with the currval() call,
IIRC.)

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