Re: [HACKERS] Temparary disable constraint
Maybe you are right as technically but this behaver causes a lot of maintance problem on a database that alot of view and functions that depends on a table or a type. I think objects has a property if that object is enable or not. We hope this problem can be resolved at 8.4 release. Best Regards Adnan DURSUN ASRIN Bilisim Ltd. - Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: Adnan DURSUN [EMAIL PROTECTED] Cc: pgsql-hackers@postgresql.org Sent: Wednesday, January 17, 2007 5:49 PM Subject: Re: [HACKERS] Temparary disable constraint Adnan DURSUN wrote: Hi, Maybe added more further things to TODO list. Enabled / disabled other objects like view/funtion. imagine a lot of views that referances a table and i wanna drop a column on this table that used by these views. Postgres doesnt allow this. First i must drop these views then drop the column on that table and then recreate these views. Can this be resolved (like oracle does) ? Not easily, because the view are bound to the object id of the tables involved. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Temparary disable constraint
- Original Message - From: Richard Huxton dev@archonet.com To: Bruce Momjian [EMAIL PROTECTED] Cc: Adnan DURSUN [EMAIL PROTECTED]; pgsql-hackers@postgresql.org Sent: Thursday, January 18, 2007 5:57 PM Subject: Re: [HACKERS] Temparary disable constraint Not easily, because the view are bound to the object id of the tables involved. The trick would be I think to bind them to individual columns, so if view V doesn't mention column C then dropping C has no effect on it. That's a lot more dependencies to track of course. Is that not possible that all objects have a column that says whether object state is ok or not. When any session wants to try to execute any DML on object, then the Postgres checks that state column. If object state is not ok then Postgres raises an exception. Best Regards Adnan DURSUN ASRIN Bilisim Ltd. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Temparary disable constraint
Hi, Maybe added more further things to TODO list. Enabled / disabled other objects like view/funtion. imagine a lot of views that referances a table and i wanna drop a column on this table that used by these views. Postgres doesnt allow this. First i must drop these views then drop the column on that table and then recreate these views. Can this be resolved (like oracle does) ? Best regards Adnan DURSUN ASRIN Bilişim Ltd. - Original Message - From: Hubert FONGARNAND To: Bruce Momjian Cc: pgsql-hackers@postgresql.org Sent: Wednesday, January 17, 2007 10:36 AM Subject: Re: [HACKERS] Temparary disable constraint Ok it works, but we have to write a plpgsql function that takes the table_name and the constraint name in parameters It could be useful to have a : ALTER TABLE ... DISABLE CONSTRAINT ... (as oracle does) it could be good to add this to the TODO LIST... Thanks Le mardi 16 janvier 2007 à 22:02 -0500, Bruce Momjian a écrit : Hubert FONGARNAND wrote: Hi, Is there a way to temporary disable a constraint (without drop and recreating it) in postgresql? Sure, try ALTER TABLE ... DISABLE TRIGGER for the constraint trigger name. ___ Ce message et les 鶥ntuels documents joints peuvent contenir des informations confidentielles. Au cas o?ne vous serait pas destin鬠nous vous remercions de bien vouloir le supprimer et en aviser imm餩atement l'exp餩teur. Toute utilisation de ce message non conforme ࠳a destination, toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est formellement interdite. Les communications sur internet n'鴡nt pas s飵ris饳, l'int駲it頤e ce message n'est pas assur饠et la soci鴩 魥ttrice ne peut 괲e tenue pour responsable de son contenu.
[HACKERS] Can i see server SQL commands ?
Hi all I wanna know what is going on while a DML command works. For example ; Which commands are executed by the core when we send an UPDATE tab SET col = val1... in case there is a foreing key or an unique constraint on table tab. How can i see that ? Best regards Adnan DURSUN ASRIN Bilişim Ltd. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] proposal for PL packages for 8.3.
- Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: Josh Berkus josh@agliodbs.com Cc: Tom Lane [EMAIL PROTECTED]; Pavel Stehule [EMAIL PROTECTED]; dev@archonet.com; pgsql-hackers@postgresql.org Sent: Wednesday, August 09, 2006 1:49 AM Subject: Re: [HACKERS] proposal for PL packages for 8.3. Or we could just add local variables to schema and dispense with PACKAGES entirely. Sure, makes more sense to me. I don't think people want Oracle syntax as much as Oracle packages capabilities. Is it would be nice , if packages have been ; 1. Package level variables (Public variables) 2. Package member level variables (Private variable) 3. Public and private package members 4. Syntax must be as closer as plpgsql (declaration, assingment etc) rather than any syntax that we have to learn :-) Best regards Adnan DURSUN ASRIN Bilisim Ltd. ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] Database Objects States
Our database has about 700 objects (tables,views, stored functions, types etc), we want to make a change on a view or tables, it said that there were a lot of depended obejcts. I know that depended object must be dropped and then created to solve this. But, It has too many dependecies to drop. It will be nice to all, if PostgreSQL database objects has an state (valid/invalid) like Oracle has. Depended objects states are changed to invalid if any changes would make to the objects that are referenced by them. For example ; Assuming, we have a table named T and a view named W. We wanna change on a column table T, it will said that view W depended on it. If the database would has a lot of dependecies then the problem will never be solved. In my opinion, we let the changes on table T then must change the state the view W to invalid. Of course, i dont know if this is possible.. I hope this is not a nice dream :-) Best regards Adnan DURSUN ASRIN Bilisim Ltd. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Transaction Speed
This depends on your server capability and performance.. You can use PostgreSQL as real time database. It is real not a toy :-) Adnan DURSUNASRIN Bilisim Ltd. Turkey - Original Message - From: moises To: pgsql-hackers@postgresql.org Sent: Thursday, July 20, 2006 3:36 PM Subject: [HACKERS] Transaction Speed Can any body talk me how many transactions make postgres in a second? For example Inserts, Update, delete, etc. Im very interesting in this data, because I want to use postgres for a real time database for process control. Thanks and regards M.Sc.Moisés Herrera Vázquez Especialista Superior en Automática Empresa de Automatización Integral, CEDAI Sucursal Villa Clara. Teléfono: (53) 42 -203311 ___
[HACKERS] unsubscribe
unsubscribe