Re: script errors or PEBKAC?

I would check the order in which things are being created in your process.

What I usually do is create all the tables sans indexing or constraints (except primary key). Once the table are done, load the data in to the tables that need to be populated. Then constraints, triggers and then indexes. But, hey, that is just me. One thing, make sure you know your data. I mean if you are adding new (not before used on the data) unique indexes, make sure the loaded data will support that uniqueness.

Just 2 cents.
Michael

> From: hawat(dot)thufir(at)gmail(dot)com
> To: pgsql-general(at)postgresql(dot)org
> Date: Fri, 4 Mar 2011 07:48:04 -0800
>
> I cannot get the script here:
>
> https://docs.google.com/leaf?id=0B5hKxkS1VyAxOGMzZjY4ZjktZjZkOS00Zjc3LWExYmEtYTU3ZThjYzZiMjk3&hl=en
>
> to run correctly. Looking at the output, many, many, errors, it seems
> to assume tables exist which don't. Is that correct?
>
> The script is supposed to create a database, but it seems to assume that
> the schema is already there and configured?
>
> Or, maybe I'm not running it correctly?
>
>
> thanks,
>
> Thufir
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general