Opened 17 years ago

Closed 16 years ago

#1699 closed enhancement (fixed)

postgres: add the ability to specify a list of tables to be treated as layers

Reported by: cph Owned by: Even Rouault
Priority: normal Milestone: 1.6.0
Component: OGR_SF Version: unspecified
Severity: normal Keywords: postgis postgresql
Cc: warmerdam, project10, Mateusz Łoskot

Description

This functionality is already available for other datasources(as per FrankW). This feature is really needed as it is a huge performance problem when we only want to export 1 table from a system with 100's of tables listed in the geometry_columns table.

Attachments (1)

1699_pg_table_connstr.patch (10.8 KB ) - added by project10 16 years ago.
patch implementing #1699

Download all attachments as: .zip

Change History (7)

comment:1 by warmerdam, 17 years ago

Cc: warmerdam added
Component: defaultOGR_SF
Keywords: postgis postgresql added
Milestone: 1.5.0
Owner: changed from warmerdam to Mateusz Łoskot

Mateusz,

I'd like you to add a way of specifying a table list is the PG: connection string. Perhaps an entry like TABLES=name1,name2,... could be allow to establish the set of tables to be scanned. This would need to be removed from the string before the rest is passed on to the postgres connection opening function.

by project10, 16 years ago

Attachment: 1699_pg_table_connstr.patch added

patch implementing #1699

comment:2 by project10, 16 years ago

This patch allows the list of tables to be specified in the manner Frank suggests. Doing so skips enumeration of the spatial tables from the database metadata.

Includes documentation update and minor documentation style and grammar issue fixes.

comment:3 by project10, 16 years ago

Cc: project10 added

comment:4 by Even Rouault, 16 years ago

Cc: Mateusz Łoskot added
Owner: changed from Mateusz Łoskot to Even Rouault

comment:5 by Even Rouault, 16 years ago

Milestone: 1.5.11.6.0

Patch commited in trunk in r14204 (with minor adaptations related to memory usage).

Is this appropriate for backporting into 1.5 branch ?

comment:6 by Even Rouault, 16 years ago

Resolution: fixed
Status: newclosed

Answering to myself ;-), I don't think it's appropriate. There have been quite a lot of changes in the postgres driver since 1.5 and that one is really new feature.

Closing

Note: See TracTickets for help on using tickets.