U++ framework: U++ SQL » Quick explanation of function calls for postgresql

Home » U++ Library support » U++ SQL » Quick explanation of function calls for postgresql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Quick explanation of function calls for postgresql [message #16617 is a reply to message #16613]

Wed, 02 July 2008 16:08

captainc
Messages: 278
Registered: December 2006
Location: New Jersey, USA

Experienced Member

Thank you for the explanation; very helpful.

Quote:

All_Tables will "dump" SQL scripts from .sch file and stores them into database.

If this is going to execute the scripts anyway, what is the use for checking for changes to update immediately after? Will All_Tables() only execute the "create tables" sql from the "S_*.sql" file, whereas Upgrade() will execute the "U_*.sql" file?
Also, is there an equivalent to the All_Tables() function that will only compare the current scripts with the potential new ones and not execute the create statements (even though the create statements simply fail when the table already exists...)?

Report message to a moderator

[Message index]

		Quick explanation of function calls for postgresql By: captainc on Mon, 30 June 2008 22:50
		Re: Quick explanation of function calls for postgresql By: mirek on Wed, 02 July 2008 13:01
		Re: Quick explanation of function calls for postgresql By: captainc on Wed, 02 July 2008 16:08
		Re: Quick explanation of function calls for postgresql By: mirek on Wed, 02 July 2008 22:50

Previous Topic:	SQLite queries problem
Next Topic:	PostgreSQL GetInsertedId()

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 20 22:59:13 GMT+2 2026

Total time taken to generate the page: 0.00549 seconds