Home » U++ Library support » U++ SQL » PostgreSQL Support Classes [Experimental]
Re: PostgreSQL Support Classes [Experimental] [message #9053 is a reply to message #9037] |
Sun, 15 April 2007 20:25 |
|
I tried the plugin. It works great but I had to modify the PostrgreSQLTest databse schema file. In this file there is:
TABLE_(TESTPARTNER)
SERIAL_ (TESTPARTNER_ID) PRIMARY_KEY
STRING_ (TESTPARTNER_NAME, 200) INDEX
STRING_ (TESTPARTNER_ADDRESS, 200)
END_TABLE
TABLE_(TESTPRODUCT)
SERIAL_ (TESTPRODUCT_ID) PRIMARY_KEY
STRING_ (TESTPRODUCT_NAME, 200) INDEX
STRING_ (TESTPRODUCT_UNIT, 20)
END_TABLE
In postrgre schema macros SERIAL is defined as
#define SERIAL(x) COLUMN("serial primary key", int64, x, 0, 0)
so in final sql file there is double primary key attribute:
create table TESTPARTNER (
TESTPARTNER_ID serial primary key primary key,
TESTPARTNER_NAME varchar(200),
TESTPARTNER_ADDRESS varchar(200)
);
create table TESTPRODUCT (
TESTPRODUCT_ID serial primary key primary key,
TESTPRODUCT_NAME varchar(200),
TESTPRODUCT_UNIT varchar(20)
);
I think we should remove primary key from SERIAL and BIGSERIAL macros and let the user explicitly define it in schema file.
[Updated on: Sun, 15 April 2007 20:26] Report message to a moderator
|
|
|
|
|
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]
|
|
|
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
|
Goto Forum:
Current Time: Tue May 14 02:13:57 CEST 2024
Total time taken to generate the page: 0.02649 seconds
|