View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 09:04 PM
Dave Page
 
Posts: n/a
Default Re: Problem with Serial Columns

Luiz K. Matsumura wrote:
> The atacched diff file modify this (reference is the source of 1.6.3),
> but I don't have sufficient skill to compile the source and I'm not a
> C/C++ programmer to do a better change.


Thanks - I've applied a fix along these lines. It'll be in beta 3.

> I think that a better test to serial columns, may be to verify primarily
> if there are a dependence between the column and the sequence, and then
> verify if the default value of the column is a nextval of the this
> sequence.


Yeah, that's been on the todo list for a while but noone got round to it
yet:

- detect serial columns from pg_depend, not column default (observe
deviating serial name)

Thanks, Dave

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote