[postgis-users] create table sintax

[Ben Madin]

Júlio,

The problem is probably not a postgis problem (although the constraints may be geometry type related), but a postgres procedural language problem. 

However, you haven't provided much information, no example, and you have just kept re-posting it. Even changing the email subject didn't really help much. I would suggest that you provide a better example of what is going wrong for you, rather than leaving it to the imagination of other readers. (Although many of those who do work this list are miracle workers when it comes to providing answers, I'm not!)

Sorry if this sounds a bit abrupt, but normally in mailing lists if you haven't received a reply to your question, it means no one understands the problem. Re-posting the same question probably won't help.

cheers

Ben


On 19/04/2011, at 4:46 PM, Júlio Almeida wrote:

> Hello,
>  
> If I run
>  
> create table newtable (like oldtable including constraints);
>  
> in the SQL window with works just file.
> But if i execute
>  
> execute 'create table '||newtable||' (LIKE '||oldtable||' including constraints)';
>  
> inside a function, in a LOOP, the constraints aren't created.
> What is the problem?
> Tanks,
>  
> julio almeida 
>  
>  
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users