[postgis-users] add foreign-key constraint on raster import

[Max Demars]

Yes Pierre, very clever! I suppose that could be a workaround. Maybe not my
first choice solution though...
Thanks a lot!

-Max Demars


On Wed, May 14, 2014 at 11:27 AM, Pierre Racine <Pierre.Racine at sbf.ulaval.ca
> wrote:

> 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:burton449geo at gmail.com]
> > 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
> > <jmathis at redzonesoftware.com> 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
> > (pierre.racine at sbf.ulaval.ca) 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: postgis-users-bounces at lists.osgeo.org
> > [mailto:postgis-users-
> >               > bounces at lists.osgeo.org] On Behalf Of Max Demars
> >               > Sent: Wednesday, May 14, 2014 10:08 AM
> >               > To: postgis-users at lists.osgeo.org
> >               > 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
> >               postgis-users at lists.osgeo.org
> >               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
> >       postgis-users at lists.osgeo.org
> >       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
>
>


-- 
Stack Overflow: http://stackoverflow.com/users/1914034/burton449
GIS Overflow: http://gis.stackexchange.com/users/14426/burton449
LastFm: http://www.lastfm.fr/user/burton449
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140514/da196432/attachment.html>