hi ,all
why did not suppert Rollback? postgresql
update user_t where user_id=103 set user_name='henr y'
but can not rollback . why , how to rollabck
and do not suppert the
delete from user_t where user_id=105 cascade;
why did not suppert cascade ?
thanks
henryhcface
Last Activity: Feb 2 '08, 02:04 AM
Joined: Sep 6 '07
Location:
-
why did not suppert Rollback? postgresql
-
yes ,this question ,i found too.
can not rollback .
it is not like the oracle. -
please help me .
can anyone help me?Leave a comment:
-
attention......
attention......
attention......
attention......
attention......Leave a comment:
-
can anyone help me ?Leave a comment:
-
expecting ....
expecting ....
expecting ....expecting ....Leave a comment:
-
may be the following url can help you to understand the mysql and the postgresql
http://www.gbunix.com/htmldata/2004_08/2/10/article_535_1.h tml...Leave a comment:
-
how to move the data ,because of the partition table
i am so sorry! the english is not my mother language.
but i need everyone help actually.
it takes 16 seconds to query the this sql
SELECT count(*) FROM Sold_Listing_V as slv WHERE slv.Is_Paid ='1'
so , we ask for help
the sold_listing_v is a View ,
CREATE OR REPLACE VIEW sold_listing_v AS
SELECT item_t.item_eba y_id, userinfo.user_e bay_id, item_t.list_typ e,... -
thank you for your help
actually , my english is poor. ....Leave a comment:
-
how can we use partition table ?
now i have a question, because in our project
some tables have too records ,so the speed of the run application is
very slow ,
we plan to use partition table. but what can we do ?
the restriction condition as followers
the original data in the table ,
means how could i move the data .to other partition tables,
and at the same time the foreign key also... -
the original data in the table ,
means how could i move the data .to other partition tables,
and at the same time the foreign key also must be taken
account.Leave a comment:
-
thank you rski
but now i have another question, because in our project
some tables have too records ,so the speed of the run application is
very slow ,
we plan to use partition table. but what can we do ?
the restriction condition as followers
the original data in the table ,
the table have 2 foreign key
expecting your answers...Leave a comment:
-
fixing permissions on existing directory e:/testdb ... ok
creating directory e:/testdb/global ... ok
creating directory e:/testdb/pg_xlog ... ok
creating directory e:/testdb/pg_xlog/archive_status ... ok
creating directory e:/testdb/pg_clog ... ok
creating directory e:/testdb/pg_subtrans ... ok
creating directory e:/testdb/pg_twophase ... ok
creating directory e:/testdb/pg_multixact/members ... ok...Leave a comment:
-
but the initdb command ,
how can use the initdb ,can i use the initdb to create the db
then how to write the command ....Leave a comment:
-
how can i use the initdb?
i use the comman , initdb in my postgresql
as followers
initdb henryDB
means ,i want to create the database henryDB
but wrong .syntax error at or near "initdb" at character 1
how can i do ? thank you
No activity results to display
Leave a comment: