Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Script:
Query per visualizzare percentuale di storage disponibile e ripartizione storage per datafile
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
DYN SQL
Shell scripting...
Script:
Shell script automating oracle data pump schema export
A User Agent, like a web browser, uses HTTP to request a HTML document
Php Funzione mail()
In programming the danger of exploring the small details of coding is that you get obsessed with every line of code you write, thereby greatly reducing productivity.
In general, is not worth obsessing over code. On the other hand you should code with deliberation and intent. Steven Feurstein Oracle Magazine July /August 2004 A User Agent, like a web browser, uses HTTP to request a HTML document
|
PostgreSQL
Home >PostgreSQL > Posgresql how disable and renable foreign constraints
I had to recover old table data, to do it quickly that I want to delete first the data contained and load from a backup. Cannot just delete the data because the table was linked with several foreign keys. In this case, the backup data are consistent with all the foreign keys, I just needed to disable the foreign keys temporarily to delete the rows. In PostgreSQL, the command: ALTER TABLE t DISABLE TRIGGER ALL; does not just disable all the triggeres table but also the foreign key constraints -- Parent referenced table pgdb=# create table r (c char primary key ); -- Children referencing table pgdb=# create table t (c char primary key ); pgdb=# alter table t add FOREIGN KEY (c) REFERENCES r; -- Due the foreign constraint can insert on children table(t) only if the value is in the referenced table (r) pgdb=# insert into r values ('a'); pgdb=# insert into t values ('a'); -- Obviously, cannot insert or delete data not in the parent table pgdb=# insert into t values ('b'); ERROR: insert or update on table "t" violates foreign key constraint "t_c_fkey" DETAIL: Key (c)=(b) is not present in table "r". -- In fact, nor deleting pgdb=# delete from r; ERROR: update or delete on table "r" violates foreign key constraint "t_c_fkey" on table "t" DETAIL: Key (c)=(a) is still referenced from table "t". -- pgdb=# ALTER TABLE r DISABLE TRIGGER ALL; ALTER TABLE pgdb=# delete from r; DELETE 1 -- don't forget to renable it ... pgdb=# ALTER TABLE r ENABLE TRIGGER ALL ; Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial PostgreSQL determine database uptime [PostgreSQL] Postgres check database is Master or Replica ways to check database replication role [PostgreSQL] Ordering by highest or lowest value of multiple columns PostgreSQL functions in order by clause [PostgreSQL] Posgresql how disable and renable foreign constraints forcing data into a table ignoring foreign keys (or trigger) [PostgreSQL] Comandi date and timestamp simple Using date and timestamp [PostgreSQL] Add time to a date date function operation [PostgreSQL] How set a default schema working away in your postgreSQL session [PostgreSQL] postgres tip: how re-execute a query every n second a nice postgres shell command [PostgreSQL] Grouping data by the week example date_trunc function, trimming days by the week [PostgreSQL] How get PosgreSQL table size pg_total_relation_size function [PostgreSQL] PostgreSQL determine database size pg_database_size function returns database size [PostgreSQL] PostgreSQL enable autostart at reboot on Centos / Redhat Configure autostart after reboot [PostgreSQL]
Marco Magnani marcomagnani@fishscript.com
|
CercaAnger is creative, depression is useless.
Dyson, Freeman J. Anger is creative, depression is useless.
Dyson, Freeman J.
Oracle...
Definizioni:
SCN
Shell scripting...
Script:
Shell script automating oracle data pump schema export
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |