Обсуждение: ALTER TABLE problems

Поиск
Список
Период
Сортировка

ALTER TABLE problems

От
Ruslan A Dautkhanov
Дата:

			
		

		
	

	
	
							

	
	

	

		

			
Re: ALTER TABLE problems

									
		    

		        
От
 
		    	
Tom Lane

		    

		    

		        
Дата:

		        




			

		

	

	
							
						
	

	

		

			
				
Ruslan A Dautkhanov <rusland@scn.ru> writes:
> I had found today that when I tries to add column to a table with
> simultaneous creating foreign key for this column, no constraints
> really created with no any errors messages, but a column really
> added.

Yeah, this is a known bug in 7.3.*: ALTER TABLE ADD COLUMN fails to
process REFERENCES clauses.  There is a fix in place for 7.3.3.

            regards, tom lane