Fred
thanks for help
Fred Lehodey wrote:
you can try:
1)
CREATE SEQUENCE my_seq START 1
2)
CREATE VIEW my_view AS
SELECT nextval('my_seq'), otherfield, ...
FROM mytable1, mytable2
it worked :)
CREATE SEQUENCE final_sps_elevation_seq START 1;
CREATE OR REPLACE VIEW "final_sps_elevation" (
Hi Piotr,
you can try:
1)
CREATE SEQUENCE my_seq START 1
2)
CREATE VIEW my_view AS
SELECT nextval('my_seq'), otherfield, ...
FROM mytable1, mytable2
HTH,
Fred
2009/5/29 Piotr Synowiec
> Kevin Neufeld wrote:
>
>> Piotr Synowiec wrote:
>> > Is there any particular reason why AddGeoemtryC
Kevin Neufeld wrote:
Piotr Synowiec wrote:
> Is there any particular reason why AddGeoemtryColumn doesn't work on
Views ?
AddGeometryColumn adds a column to a table and registers the column
with the geometry_columns. If you want to add a geometry column to
your VIEW, alter your VIEW to se
Piotr Synowiec wrote:
> Is there any particular reason why AddGeoemtryColumn doesn't work on
Views ?
AddGeometryColumn adds a column to a table and registers the column with the geometry_columns. If you want to add a
geometry column to your VIEW, alter your VIEW to select the column from an
Hi
I have view created from 2 tables to select and combine data I need.
I tried to add geometry column with below command but it failed.
SELECT AddGeometryColumn( 'my_view', 'geom_field', -1, 'GEOMETRY',2);
Instead I used
INSERT INTO geometry_columns
(f_table_catalog,f_table_schema,f_table_name,
le? "CREATE TABLE public.estac_aemet (field type, etc... "
>>> Did you use special accent characters in its creation?
>>>
>>>
>>>
>>>> -Original Message-
>>>> From: [EMAIL PROTECTED]
>>>> [mailto:[EMAIL PRO
creation?
>>
>>
>>
>>> -Original Message-
>>> From: [EMAIL PROTECTED]
>>> [mailto:[EMAIL PROTECTED] On
>>> Behalf Of [EMAIL PROTECTED]
>>> Sent: Wednesday, August 27, 2008 8:13 AM
>>> To: PostGIS Users Discussion
>
gt; From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, August 27, 2008 10:23 AM
> To: PostGIS Users Discussion
> Cc: PostGIS Users Discussion
> Subject: RE: [postgis-users] AddGeometryColumn error
>
>
> I tried one thing
type, etc... "
> Did you use special accent characters in its creation?
>
>
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On
>> Behalf Of [EMAIL PROTECTED]
>> Sent: Wednesday, August 27, 2008 8:13 AM
>&
nt characters in its creation?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, August 27, 2008 8:13 AM
> To: PostGIS Users Discussion
> Cc: PostGIS Users Discussion
> Subject:
Correctly, I have 3 databases: postgres (This my DB), demo_postgis and
template_postgis
In my DB there is no FUNCTIONS
In template_postgis there are all the POSTGIS functions.
Can I import from 'my DB' all PostGIS functions that are in other DB
(template_postgis)
Thanks.
> Hi,
>
> maybe your in
Hi,
maybe your instalation of postgis functions and etc are not in postgres db.
If you are using windwos search for others databases, maybe a postgis or
postgis_template. At that databases you will find the the functions.
If you are using linux then you will have to add that functions to some
dat
No, is correct like 'estac_aemet'
How do I know if my POSTGIS functions are installed ok?
In my DB called 'postgres' I have no Functions.
>> Yes, the tabla estac_aemet exists. The schema is public
>>
>
> Did you create the table using double quotes to name it ? "ESTAC_AEMET" maybe
> ?
> If so,
> Yes, the tabla estac_aemet exists. The schema is public
>
Did you create the table using double quotes to name it ? "ESTAC_AEMET" maybe ?
If so, then you have to respect the case in the table name when naming it:
SELECT addgeometrycolumn('public','ESTAC_AEMET', 'the_geom', 23030,'POINT',2)
You
Yes, the tabla estac_aemet exists. The schema is public
>> Now, with you purpose, this error:
>>
>>
>> ERROR: no existe la relación «public.estac_aemet»
>
> Is the estac_aemet table exists ? If so, in which schema was it created ?
> ___
> postgis-users
> Now, with you purpose, this error:
>
>
> ERROR: no existe la relación «public.estac_aemet»
Is the estac_aemet table exists ? If so, in which schema was it created ?
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.re
Now, with you purpose, this error:
ERROR: no existe la relación «public.estac_aemet»
CONTEXTO: sentencia SQL: «ALTER TABLE public.estac_aemet ADD COLUMN the_geom
geometry »
PL/pgSQL function "addgeometrycolumn" line 90 at EXECUTE statement
sentencia SQL: «SELECT AddGeometryColumn('', $1 , $2 ,
> First of all, Postgres display me the next error with this query:
>
> My database is named postgres
> My table is named estac_aemet
> The name of the new column I want to create is the_geom
> 23030 is UTM-ED50 huso 30 (Proyection I want)
>
> SELECT addgeometrycolumn('postgres','estac_aemet', 'the
First of all, Postgres display me the next error with this query:
My database is named postgres
My table is named estac_aemet
The name of the new column I want to create is the_geom
23030 is UTM-ED50 huso 30 (Proyection I want)
SELECT addgeometrycolumn('postgres','estac_aemet', 'the_geom', 23030,
> Hi everyone!
>
> I have installed PostgreSQL 8.3 and PostGIS (postgis_1_3_3_pg83). I have a
> table with many stations in Southern Spain (POINT) and their coordinates
> LATITUDE, LONGITUDE and ELEVATION.
>
> How can I create a geometry column? I try with AddGeometryColumn but I
> couldn't.
>
Hi
Hi everyone!
I have installed PostgreSQL 8.3 and PostGIS (postgis_1_3_3_pg83). I have a
table with many stations in Southern Spain (POINT) and their coordinates
LATITUDE, LONGITUDE and ELEVATION.
How can I create a geometry column? I try with AddGeometryColumn but I couldn't.
Thanks.
Javier Est
21 matches
Mail list logo