[postgis-users] create table sintax

[Richard Gomes]

Julio,

You can always create constraints by hand if they are not created 
automagically when you create a table based on some other existing table.

I hope it helps.

Cheers :)

Richard Gomes
http://www.jquantlib.org/index.php/User:RichardGomes
twitter: frgomes

JQuantLib is a library for Quantitative Finance written in Java.
http://www.jquantlib.com/
twitter: jquantlib


On 19/04/11 13:21, Ben Madin wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110426/da4475d5/attachment.html>