Re: [GENERAL] Using complex PRIMARY KEY

2009-10-08 Thread A. Kretschmer
In response to A. Kretschmer : > In response to Zsolt : > > > > This is our first project using PostgerSQL, where I have a problem I cant > > solve > > on a neat way (I assume PGSQL should provide a nice solution...). > > > > So we have an old xBase based program we are trying to port to Postgre

Re: [GENERAL] Using complex PRIMARY KEY

2009-10-08 Thread Gurjeet Singh
2009/10/8 Zsolt > > This is our first project using PostgerSQL, where I have a problem I cant > solve on a neat way (I assume PGSQL should provide a nice solution...). > > So we have an old xBase based program we are trying to port to PostgreSQL > while we should keep the original data structure

Re: [GENERAL] Using complex PRIMARY KEY

2009-10-07 Thread A. Kretschmer
In response to Zsolt : > > This is our first project using PostgerSQL, where I have a problem I cant > solve > on a neat way (I assume PGSQL should provide a nice solution...). > > So we have an old xBase based program we are trying to port to PostgreSQL > while > we should keep the original da

Re: [GENERAL] Using complex PRIMARY KEY

2009-10-07 Thread Sam Mason
On Wed, Oct 07, 2009 at 09:19:58PM +0200, Zsolt wrote: > For a given house I would like to start the numbering of tenants from > 1. Each house could have tenant_ID=1, obviously in this case the > house_ID will differ. The combination of tenant_ID and house_ID will > be the unique identifier of each

[GENERAL] Using complex PRIMARY KEY

2009-10-07 Thread Zsolt
Normal 0 21 false false false MicrosoftInternetExplorer4 This is our first project using PostgerSQL, where I have a problem I cant solve on a neat way (I assume PGSQL should provide a nice solution...). So we have an old xBase ba