Hi,
for adding a geometry-column to an existing table use one of the
postgis-functions "select AddGeometryColumn(...);" described in:
http://postgis.refractions.net/documentation/manual-1.5/AddGeometryColumn.html
Ludwig
Am 17.01.2011 18:35, schrieb "Plata Martínez, Álvaro (KNMI)":
Hi,
Using
Am 20.08.2010 23:10, schrieb Wang, Mary Y:
Hi,
I'm having a problem right now. Some of our French users uploaded
some files with file names that had French accent marks, and those
file names were inserted into the Postgres database. When I examined
the value of those file names, they all ha
Hi,
on a Windows/PostgrSQL 8.4 three from your queries throw errors (sorry,
but they are in german):
select to_date('01/04/2013 23:59:59','DD/MM/ HH24:Mi:SS');
=> FEHLER: ungültige Kombination von Datumskonventionen
HINT: Die Gregorianische und die ISO-Konvention für Wochendaten können
n
Hi List,
not another question on how to store files (db or filesystem), i decided to use
the filesystem.
I'm now searching for a trigger, that deletes the physical file when deleting a
database-record containing the filename in one of its fields. Is there a sample
somewhere how this could be do
I don't know about Postgres 8.3, but with 8.4-docs the Syntax of your
query could be
select * from tblretrain where NOT ('ms-ap-t2-02c9' = ANY (owners));
regards
Ludwig
Grant Maxwell schrieb:
Hi Folks
According to the 8.3 docs I should be able to write:
select * from tblretrain where 'ms-
t2.token and
t1.exponent != t2.exponent
inner join test_right as t3 on t1.token = t3.token and t1.exponent =
t3.exponent
inner join test_right as t4 on t2.token = t4.token and t2.exponent =
t4.exponent;
Regards
Ludwig Kniprath
Alban Hertroys schrieb:
Greetings!
I'm having some troubles
Scott Marlowe schrieb:
On Sat, May 23, 2009 at 7:18 AM, Christophe wrote:
On May 23, 2009, at 9:13 AM, Daniel Verite wrote:
I don't know why this query returns false:
SELECT '20040506 070809.01'::timestamp(6) - '20010203
040506.007000'::timestamp(6) = '1188 day 3 hour 3 minute 3 se
Hello Hendra,
there is no function right(column, n-Chars), but you can use
substring(column-name from offset for num_chars) in combination with
char_length for getting the right-n-characters as f. e.:
select substring(column from (char_length(column) - 3) for 4) from table
Ludwig
>Dear all,
Dear list,
I have to solve a simple Problem, explained below with some sample-Data.
A typical M:N-constellation, rivers in one table, communities in the
other table, m:n-join-informations (which river is running in which
community) in a third table.
Table rivers:
R_ID R_Name
1 river_1
2
>On Sun, Jul 20, 2008 at 05:50:30PM -0500, Martin wrote:
>> Ok, this should be simple. How do I find the defined maximum
>> length of a varchar field?
SELECT
character_maximum_length
FROM
information_schema.columns
WHERE
table_schema = 'name_of_your_schema' and
table_name = 'name_o
Hallo Bob,
I also use pgDmin on XP with postGIS and imported Shape-Files, but without
problems.
As far as I know pgadmin uses gtk, and there are some google-hits for
searchvalues "pgadmin" and "gtk" reporting hardware-crashes on windows and
linux Systems.
Perhaps the same problem?
Ludwig
>MS's
Perhaps trivial, but:
Additional to or instead of triggers You can use grants to allow updates only
to special users.
Ludwig
>Hello there
>
>Can anyone please tell me how to make a column uneditable..
>
>Plz give me some output
>
>thans
>
--
Sent via pgsql-general mailing list (pgsql-general@
Hi,
I think, this is the wrong list, it appears to be a PHP error.
Anyway, try to put the global $_SERVER['SCRIPT_NAME'] into {}brackets:
list($page_id)=sqlget("select page_id from pages where
name='{$_SERVER['SCRIPT_NAME']}'");
Hope, You're not lost anymore ...
Ludwig
PJ schrieb:
I'm using
Devrim GUNDUZ schrieb:
Hello,
On Tue, 2006-10-10 at 11:30 +0200, Ludwig Kniprath wrote:
"/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1": libgeos_c.so.1: cannot
open shared object file: No such file or directory
Did you run make install agains geos? Is the path that libg
PostgreSQL 8.1 on ubuntu-linux 6.06 (kernel 2.6.15-27-686):
Compiled proj-4.4.9 and geos-2.2.3 without problems.
Output from postgis-./configure-Command:
SUMMARY
---
HOST_OS: linux-gnu
PGSQL: /usr/bin/pg_config
GEOS: /usr/local/bin/ge
15 matches
Mail list logo
