[auth] Problem generation SQL script

View: New views
3 Messages — Rating Filter:   Alert me  

[auth] Problem generation SQL script

by Rocco Fusella-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello everyone,
I noticed a problem with auth, in practice I create the script to generate the database (I use ANT or MAVEN) and I run into postgre to create tables.
After that I made the test to insert a Group manually and after to cancel but just delete the line in the table GROUP while the associated row in the table SUBJECT not erase.
I check the script and apparently is not created the rule on the cancellation which is required by default to "ON UPDATE NO ACTION ON DELETE NO ACTION."
But if the operations erasure are made directly from the code with smartweb everything works properly.
I wanted to know then how can create the script sql them properly?

Hello Rocco

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user

Re: [auth] Problem generation SQL script

by svetrini :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Sorry.. I don't understand you...
if smartweb works, where is the problem ? :-)
How do you delete the grouop?

2008/5/7 Rocco Fusella <rfusella@...>:
Hello everyone,
I noticed a problem with auth, in practice I create the script to generate the database (I use ANT or MAVEN) and I run into postgre to create tables.
After that I made the test to insert a Group manually and after to cancel but just delete the line in the table GROUP while the associated row in the table SUBJECT not erase.
I check the script and apparently is not created the rule on the cancellation which is required by default to "ON UPDATE NO ACTION ON DELETE NO ACTION."
But if the operations erasure are made directly from the code with smartweb everything works properly.
I wanted to know then how can create the script sql them properly?

Hello Rocco

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user

Re: [auth] Problem generation SQL script

by Rocco Fusella-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

What I wanted to know and if you can create the script so that if I'm going to be pgAdmin erasing a group I must also cancel its subject,
>From smartweb does everything but if I had to make manual operations on db must remember that if a gate line in the table group should also go to delete a row in the table subject.
I hope to have been more clear, certainly my English is incomprehensible :-)

2008/5/8 Stefano V <stvnove@...>:
Sorry.. I don't understand you...
if smartweb works, where is the problem ? :-)
How do you delete the grouop?

2008/5/7 Rocco Fusella <rfusella@...>:
Hello everyone,
I noticed a problem with auth, in practice I create the script to generate the database (I use ANT or MAVEN) and I run into postgre to create tables.
After that I made the test to insert a Group manually and after to cancel but just delete the line in the table GROUP while the associated row in the table SUBJECT not erase.
I check the script and apparently is not created the rule on the cancellation which is required by default to "ON UPDATE NO ACTION ON DELETE NO ACTION."
But if the operations erasure are made directly from the code with smartweb everything works properly.
I wanted to know then how can create the script sql them properly?

Hello Rocco

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
smartweb-user mailing list
smartweb-user@...
https://lists.sourceforge.net/lists/listinfo/smartweb-user
LightInTheBox - Buy quality products at wholesale price