Re: [pgadmin-support] 'create script' not usable for columns set 'not null' and 'default'

2012-07-03 Thread Rohan Carly
On 3/07/2012 4:09 PM, Dave Page wrote: On Tue, Jul 3, 2012 at 8:38 AM, Rohan Carly wrote: In pgAdmin III v.1.14.1, if you navigate to schemas/public/tables//Columns/ and right-click on the column name and press "create script", you often get a script that will not execute. The problem occurs w

Re: [pgadmin-support] 'create script' not usable for columns set 'not null' and 'default'

2012-07-03 Thread Dave Page
On Tue, Jul 3, 2012 at 8:38 AM, Rohan Carly wrote: > In pgAdmin III v.1.14.1, if you navigate to > schemas/public/tables//Columns/ and right-click on the column > name and press "create script", you often get a script that will not > execute. > > The problem occurs when you have a column that has

[pgadmin-support] 'create script' not usable for columns set 'not null' and 'default'

2012-07-03 Thread Rohan Carly
In pgAdmin III v.1.14.1, if you navigate to schemas/public/tables//Columns/ and right-click on the column name and press "create script", you often get a script that will not execute. The problem occurs when you have a column that has "NOT NULL" and a "DEFAULT" property. e.g. A script genera