New topic: Update field type in ProsgreSQL
<http://forums.realsoftware.com/viewtopic.php?t=46588> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message Grant Post subject: Update field type in ProsgreSQLPosted: Thu Jan 17, 2013 7:27 am Joined: Sun Jan 22, 2006 2:37 am Posts: 325 Hi, In PostgreSQL, can I update a field type so that it must have a value when the record is created or there will be an error? I have a bug thats not filling out a field sometimes and its very rare. I thought if I could make the database throw an error if that field was blank, I would be able to find it. But I need to do it on a running database so I don't want to screw it up. Also, later it might be good to turn the field back to a normal field. Is that easy and reliable to be able to do? Top DaveS Post subject: Re: Update field type in ProsgreSQLPosted: Thu Jan 17, 2013 9:35 am Joined: Sun Aug 05, 2007 10:46 am Posts: 4423 Location: San Diego, CA Most databases has the ability to specify a field cannot be NULL usually during the CREATE TABLE phase, but can be added (in some databases) using ALTER TABLE _________________ Dave Sisemore MacPro, OSX Lion 10.7.4 RB2012r1 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
