PostgreSQL force create table / ignore constraints?

From: hartrc <rhart2(at)mt(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL force create table / ignore constraints?
Date: 2012-10-03 15:12:25
Message-ID: 1349277145502-5726469.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Version Postgresql 9.1.6
OS: SLES 11 64 bit

Background:
Our developers create database schema in development environment using
PGAdmin (often using the GUI to generate the DDL).
We always deploy to production using a script, a single .sql file which we
execute via psql command line. This allows us to generate an output with any
errors and have good view of deployment history over time.

Issue
The issue we have is that developers generate the .sql script mainly by
copying and pasting from PGAdmin's SQL pane. The issue we have is then the
order of the object creation is important otherwise creation of tables and
fail when there is a foreign key constraint on another table that does not
exist (but is created later in the script). This is not a big deal in a
schema with 3 or 4 tables but when there are 20+ it is time consuming task
to reorder all the create statements.

Can anyone recommend a way of dealing with this? My only other thought has
been pg_dump although i would prefer if the developers could generate the
scripts themselves.

Thanks,
Rob

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-force-create-table-ignore-constraints-tp5726469.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-10-03 15:13:20 Fwd: pros and cons of two security models
Previous Message Robert Sosinski 2012-10-03 14:54:18 Re: Postgres will not start due to corrupt index