When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE
tse_history INCLUDING ALL WITH OIDS
I get this error
ERROR: syntax error at or near LIKE
LINE 2: CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL ...
testing, I find that using the word LIKE always causes errors
: [GENERAL] PgAdmin errors
On 3/26/2014 12:32 PM, Hall, Samuel L (Sam) wrote:
When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE
tse_history INCLUDING ALL WITH OIDS
I get this error
ERROR: syntax error at or near LIKE
LINE 2: CREATE TABLE tse_history_old LIKE tse_history INCLUDING
: Wednesday, March 26, 2014 3:02 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PgAdmin errors
On 3/26/2014 12:58 PM, Hall, Samuel L (Sam) wrote:
That doesn't help. Even this CREATE TABLE tse_history_old (LIKE tse_history)
gives an error
the exact same error ?
--
john r pierce
Yes
PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, March 26, 2014 4:03 PM
To: Hall, Samuel L (Sam)
Cc: John R Pierce; pgsql-general@postgresql.org
I have a Postgressql-9.2 database with postgis-2.0 in production service. Due,
I think, to a bad postgis upgrade, there are both old and new functions
present. I am planning to install Postgresql-9.3 and Postgis-2.01 and then copy
the data over with pg_upgrade. My question is: Will this also
I have a table (pubacc_lo) from the US government with 500,00+ rows. It has
latitude and longitude in three columns each for degrees, minutes and seconds.
I need a Point geometry column. So I wrote this query:
with mydata AS (SELECT (pubacc_lo.lat_degrees + pubacc_lo.lat_minutes/60 +
Thank you! That worked fine.
From: bricklen [mailto:brick...@gmail.com]
Sent: Friday, August 23, 2013 10:08 AM
To: Hall, Samuel L (Sam)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Update quey
On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam)
sam.h...@alcatel
Using PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
POSTGIS=2.0.1 r9979 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.8.0, 6 March 2012
GDAL=GDAL 1.9.2, released 2012/10/08 LIBXML=2.8.0 LIBJSON=UNKNOWN
TOPOLOGY RASTER
Postgis seems to be
I have an application that writes an Excel Spreadsheet to postgres. For the
values that go in number fields, I check the Excel values for dbnull and set
the parameters to 0, like this: cmd.Parameters(9).Value = 0. Npgsql throws an
error format specifier was invalid If I do this: