Re: [GENERAL] Removing Constraints Efficiently

2009-04-17 Thread Tom Lane
Jeff Cook writes: > I'm attempting to remove constraints (primary/foreign keys) ahead of a > massive import. Once the data has been imported, I would like to > regenerate the constraints I removed. This process is recommended in > PostgreSQL's documentation and incidentally would make import much

[GENERAL] Removing Constraints Efficiently

2009-04-16 Thread Jeff Cook
I'm attempting to remove constraints (primary/foreign keys) ahead of a massive import. Once the data has been imported, I would like to regenerate the constraints I removed. This process is recommended in PostgreSQL's documentation and incidentally would make import much more tenable. However, we'

Re: [GENERAL] Removing constraints

2000-11-13 Thread Tom Lane
"Nathan Barnett" <[EMAIL PROTECTED]> writes: > Thanks for the initial help. I followed your instructions, but now I'm > getting an error: "ERROR: RelationBuildTriggers: 2 record(s) not found for > rel nametable". Where else would these triggers be referenced. If you manually add/delete trigger

RE: [GENERAL] Removing constraints

2000-11-13 Thread Nathan Barnett
Nathan Barnett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephan Szabo Sent: Monday, November 13, 2000 11:47 AM To: Nathan Barnett Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Removing constraints You should be able remove the fk constraint by dropping the t