[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    Re: [postgis-devel] another patch for shp2pgsql
From:       strk <strk () keybit ! net>
Date:       2004-08-05 20:00:36
Message-ID: 20040805200036.GB97172 () freek ! keybit ! net
[Download RAW message or body]

On Thu, Aug 05, 2004 at 03:52:13PM -0400, Carl Anderson wrote:
> 
> one more schema sensitive instance

one more commit.
--strk;

> 
> -- 
> Carl Anderson
> GIS Manager Fulton County, Georgia
> carl.anderson@co.fulton.ga.us
> 404.730.8026
> 

> --- shp2pgsql.c.old	Thu Aug  5 15:30:09 2004
> +++ shp2pgsql.c	Thu Aug  5 15:32:45 2004
> @@ -1167,9 +1167,19 @@
> 
> 	free(col_names);
> 	if(opt != 'a'){
> -		printf("\nALTER TABLE ONLY \"%s\" ADD CONSTRAINT \"%s_pkey\" PRIMARY KEY \
>                 (gid);\n",table,table);
> -		if(j > 1){
> -			printf("SELECT setval ('\"%s_gid_seq\"', %i, true);\n", table, j-1);
> +		if ( schema )
> +		{
> +			printf("\nALTER TABLE ONLY \"%s\".\"%s\" ADD CONSTRAINT \"%s_pkey\" PRIMARY KEY \
> (gid);\n",schema,table,table); +			if(j > 1){
> +				printf("SELECT setval ('\"%s\".\"%s_gid_seq\"', %i, true);\n", schema, table, \
> j-1); +		}
> +		}
> +		else
> +		{
> +			printf("\nALTER TABLE ONLY \"%s\" ADD CONSTRAINT \"%s_pkey\" PRIMARY KEY \
> (gid);\n",table,table); +			if(j > 1){
> +				printf("SELECT setval ('\"%s_gid_seq\"', %i, true);\n", table, j-1);
> +			}
> 		}
> 	}
> 

> _______________________________________________
> postgis-devel mailing list
> postgis-devel@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel


[prev in list] [next in list] [prev in thread] [next in thread]