Shouldn't it be up to your app to add (if it does not exist yet) and set a key column every time a new raster is loaded? Or even better change the name of the raster before it is loaded so it gets a unique filename based on you users properties? The logic of identifying the files should be done before importing in the DB.
Pierre > -----Original Message----- > From: Max Demars [mailto:[email protected]] > Sent: Wednesday, May 14, 2014 11:19 AM > To: PostGIS Users Discussion > Cc: Pierre Racine > Subject: Re: [postgis-users] add foreign-key constraint on raster import > > I was thinking about this way to do it, but my app has many users, and in > case two rasters with the same filename are loaded, there would be a > problem using filename to create a foreign key. The aim of the foreign key > here would be to specify which user is the owner of which raster. > > > I suppose I could find a way to handle the possibility of two rasters with the > same filename, but if I could create the foreign key during the import, I > think that would be the best. > > > > On Wed, May 14, 2014 at 11:08 AM, Jason Mathis > <[email protected]> wrote: > > > That what I was thinking too. Just to clarify its a capital â-Fâ. > > Its a handy option for post processing the files in the db. > > http://postgis.net/docs/using_raster_dataman.html#RT_Raster_Lo > ader > > > > On May 14, 2014 at 9:04:32 AM, Pierre Racine > ([email protected]) wrote: > > > You can add the filename as a new column with the -f > option. Then you can extract whatever you want from this column to build > a key. > > Does this works for you? > > Pierre > > > -----Original Message----- > > From: [email protected] > [mailto:postgis-users- > > [email protected]] On Behalf Of Max Demars > > Sent: Wednesday, May 14, 2014 10:08 AM > > To: [email protected] > > Subject: [postgis-users] add foreign-key constraint on > raster import > > > > Hi, > > > > > > I want to import many rasters from files into a same > tablewith a foreign-key > > constraint to be able to query them individually or > grouped as needed. > > > > > > I was hopping that the raster2pgsql tool would be able to > do it, but no > > chance. > > > > Is there a way to ask raster2pgsql to add a foreign-key > during import? If > > not, what would be the best approach for this purpose? > > > > Thank you very much, > > > > > > -Max Demars > > > > > > -- > > > > Stack Overflow: > http://stackoverflow.com/users/1914034/burton449 > > > > GIS Overflow: > http://gis.stackexchange.com/users/14426/burton449 > > > > LastFm: http://www.lastfm.fr/user/burton449 > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis- > users > > > > This transmission contains confidential and privileged information > intended solely for the party identified above. If you receive this message in > error, you must not use it or convey it to others. Please destroy it > immediately and contact the sender at (303) 386-3955 > <tel:%28303%29%20386-3955> or by return e-mail to the sender. > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > > -- > > Stack Overflow: http://stackoverflow.com/users/1914034/burton449 > > GIS Overflow: http://gis.stackexchange.com/users/14426/burton449 > > LastFm: http://www.lastfm.fr/user/burton449 _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
