[HACKERS] Observed an issue in CREATE TABLE syntax

2014-04-04 Thread Rajeev rastogi
I observed an issue that even if invalid syntax is provided for CREATE TABLE, table is getting created successfully. Below table creation succeed even though same constraint name is given multiple times. None of the below constraints has any meaning of giving

Re: [HACKERS] Observed an issue in CREATE TABLE syntax

2014-04-04 Thread Tom Lane
Rajeev rastogi rajeev.rast...@huawei.com writes: Should we not throw error for above syntaxes? No. There's nothing wrong with those statements, and complaining about them will accomplish nothing except to break applications that used to work. Admittedly, code that generates such declarations