ALTER Bigserial error

Hi,

I’m trying to alter in a bigserial on GP/PG 8.1  I’m getting the error

ERROR: type "bigserial" does not exist

SQL state: 42704

I understand that bigserial isn’t a ‘true’ type, that it’s a notational convenience.  

And that I can alter in the default.

But it is listed in the type table in the doc and I can create new tables with it.

I should be able to use it in an alter.

Is there a way to fix this bug? 

What would need to change for this issue to be resolved.

Thanks

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

   orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com