Re: [PATCHES] ALTER TABLE modifications

2003-11-14 Thread Dave Cramer
Rod, I tried the current patch on a RC2 release, and I noticed one undesirable side affect. Modifying a column moves it to the end. In high availability situations this would not be desirable, I would imagine it would break lots of code. Dave On Thu, 2003-11-13 at 11:35, Hannu Krosing wrote:

Re: [PATCHES] ALTER TABLE modifications

2003-11-14 Thread Dave Cramer
OK, Here is another approach, that would retain column order. It will require that the table be locked while this proceeds, but I think this is a good idea anyway. lock table create newtable as select c1, c2, c3::newtype modify pg_class to point to the new filename modify existing pg_attribute

Re: [PATCHES] [HACKERS] Problems compiling Postgresql 8.0.3 on 10.4

2005-07-20 Thread Dave Cramer
Jamie, That's strange, I have 8.03 building fine on 10.4 ? Did you simply do a make without a make clean and run configure again ? Dave On 20-Jul-05, at 3:37 AM, Jamie Deppeler wrote: Hi, i have just installed 10.4 on one of our machines and cannot get past this error during make gcc