[Arnaud Lesauvage - Tue at 02:13:59PM +0200] > Tobias Brox wrote: > >Oh, the gid is not primary key. I guess I should also apologize for > >adding noise here :-) > > Yes, it is a primary key, but I am the noise maker here ! ;-)
Oh - it is. How can you have a default value on a primary key? Will it use the index if you do "analyze"? Is there an index on the table at all, do you get it up if you ask for a description of the table (\d tablename)? ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq