U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSQL Support Classes [Experimental]

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

Return to the default flat view

Create a new topic

Submit Reply

Re: PostgreSQL Support Classes [Experimental] [message #9065 is a reply to message #9064]

Mon, 16 April 2007 12:13

unodgs is currently offline

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

Quote:

Obviously, not as sexy as simply puttin more "PRIMARY_KEY" columns, OTOH at least Oracle SQL syntax is similar - you have to add it in single contraint, not as several "PRIMARY_KEY" comlums.

If databse is SQL 92 compatible there is posibility to define primary key in single line. It seems that most of db engines support it.

create table t
(
  id integer,
  ver integer,
  type integer,
  ...,
  primary key(id, ver, type)  
)

I proposed putting PRIMARY_KEY attribute next to every column to avoid several macros like:
SINGLE_PRIMARY_KEY
DUAL_PRIMARY_KEY
TRIO_PRIMARY_KEY etc..

Of course I don't know if it is possible to implement it using c preprocessor. If not - I suggest to get rid of primary_key attribute as well as DUAL_PRIMARY_KEY and define new macro
PRIMARY_KEY(...) which allow you to define primary key for maximum 5 columns.

Report message to a moderator

Send a private message to this user

[Message index]

		PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 00:28
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 09:11
		Re: PostgreSQL Support Classes [Experimental] By: fallingdutch on Sun, 15 April 2007 09:19
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Sun, 15 April 2007 16:02
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 17:44
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 20:25
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 20:49
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 20:59
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 21:04
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 21:18
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 09:20
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 10:22
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 10:37
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 12:13
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 19:44
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 20:11
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 20:37
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 22:42
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 17 April 2007 00:01
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Mon, 16 April 2007 19:43
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Mon, 16 April 2007 18:46
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Mon, 16 April 2007 19:57
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Tue, 17 April 2007 09:08
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 17 April 2007 11:53
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Wed, 18 April 2007 08:57
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Thu, 01 May 2008 16:53
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Thu, 01 May 2008 22:55
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Sun, 04 May 2008 10:15
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 04 May 2008 11:24
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Mon, 05 May 2008 17:12
		Re: PostgreSQL Support Classes [Experimental] By: mr_ped on Mon, 05 May 2008 20:59
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 05 May 2008 22:14
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Tue, 06 May 2008 17:24
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 06 May 2008 19:45

Previous Topic:	Catch errors with Sql.Execute
Next Topic:	Newbie help with PostgreSQL example

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue May 14 09:57:46 CEST 2024

Total time taken to generate the page: 0.02657 seconds