Search Postgresql Archives

ALTER Bigserial error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux