Re: [GENERAL] Postgis error

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

Re: [GENERAL] PostGIS return multiple points

Just some thoughts: - create a multipoint with 100 vertices instead of a single point and query once with st_Intersect - prepare the single-point-query and execute the prepared query 100 times with the changing coordinates Ludwig - Ursprüngliche Nachricht - Von: trevor1940 Gesendet

Re: [GENERAL] Could not Store French Accent Marks Correctly in Postgres

= $target_file_name; while(file_exists($target_dir . '/' . $target_file_name)){ $i++; $target_file_name = $i . $old_target_file_name; } return $target_file_name; } /SNIP Ludwig

Re: [GENERAL] to_date function

« für »MI« DETAIL: Der Wert muss eine ganze Zahl sein. Regards Ludwig Am 07.07.2010 23:07, schrieb Carlos Henrique Reimer: Hi I've a Linux box running postgresql 8.2.17 and facing some strange results from the to_date function. As you can see in the following tests the problem occurs when

[GENERAL] Synchronize filenames in table with filesystem

be done? I'm runnig PG 8.4 on a windows machine. Regards Ludwig -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] problem with array query

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

Re: [GENERAL] How to match sets?

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 creating a query, or rather, I can write one

Re: [GENERAL] 8.3: timestamp subtraction

Scott Marlowe schrieb: On Sat, May 23, 2009 at 7:18 AM, Christophe x...@thebuild.com 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

Re: [GENERAL] ask: select right(column) ???

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

Re: [GENERAL] inconsistency in aliasing

I don't know, if this is an inconsistence or a bug, but here a possible workaround: select current_timestamp::abstime::int4 as score, current_timestamp::abstime::int4 + 1 as score + 1 order by score + 1; Ludwig This works: critik=# select current_timestamp::abstime::int4

[GENERAL] Query m:n-Combination

looking at the data above (only river_1 is running through all these countries), but how to query this by sql? Thanks in advance Ludwig -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Field size

= 'name_of_your_table' and column_name = 'name_of_your_column' bye... Ludwig -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Windows Crash

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 web

Re: [GENERAL] Query

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

Re: [GENERAL] E_PARSE error ?

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

Re: [GENERAL] Password safe web application with postgre*s*

, somehow the credentials must be cleartext, so you cant get rid of this lack of security in my opinion.By the way, this is an *intra*net-solution, and we dont have hackers in our staff, I hope...Ludwig

Re: [GENERAL] Underscore _ in LIKE pattern

...Ludwig

Re: [GENERAL] Substring Problem

Type casting is required since 8.3, trySELECT substring(date :: varchar from 1 for 7) AS stryearmonth, COUNT(id) AS countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY stryearmonth ORDER BY stryearmonth ASCBye...LudwigHi there, it seems to work with 8.1, but not anymore with 8.3. What is

Re: [GENERAL] Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3

Yes, there is a great solution,take a look at PostGIS: http://www.postgis.org/It shurely will do all you want with geodata, but perhaps not as simple as you like...bye...LudwigHello,I have a lot of GeoData( Latitude and Longitude ) in my PostgreSQL Database. Is store them as numeric at this

Re: [GENERAL] Trouble with foreign key

Hi,whats the result of SELECT * from tmp_stamp where _stamp = 2f980de9f2297c7902f3415f6537c6be;?Perhaps different fieldtypes (f. e. VARCHAR in table www_es_orderhead_cs versus CHAR(n) in Table _stamp filled up with blanks)?LudwigHi,there is a problem with foreign key (PG 8.3RC2). Please, look at

Re: [GENERAL] Users, groups and inheritance questions

ROLE. For example, being a member of a role with CREATEDB privilege does notimmediately grant the ability to create databases, even if INHERIT is set; it would be necessary tobecome that role via SET ROLE before creating a database.bye...Ludwig

Re: [GENERAL] Problem compiling PostGIS 1.1.4

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 libgeos_c.so.1

[GENERAL] Problem compiling PostGIS 1.1.4

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:

[GENERAL] Unable to Start PostgreSQL 8.1.4 on Windows XP

in advance, ludwig lim __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

Re: [GENERAL] Unable to Start PostgreSQL 8.1.4 on Windows XP

Hi Thomas : --- Thomas Kellerer [EMAIL PROTECTED] wrote: Ludwig Isaac Lim wrote on 15.08.2006 18:05: Searching the web using google gives me the following information about error 1063: Error code 1063: ERROR_FAILED_SERVICE_CONTROLLER_CONNECT - I had a similar issue several weeks ago

Re: [GENERAL] PGSQL 7.4 - 8.1 migration performance problem

Hi : Maybe you forget to run the ANALYZE command afterwards. ludwig. --- Philippe Lang [EMAIL PROTECTED] wrote: Hi, For an unknown reason, I cannot post this message to the mailing-list! Here it is: http://www.attiksystem.ch/postgresql-general.txt Cheers, Philippe Lang

Re: [GENERAL] PGSQL 7.4 - 8.1 migration performance problem

Hi: How about the postgresql.conf settings? Did you changed them? ludwig. --- Philippe Lang [EMAIL PROTECTED] wrote: Hi, I did not mention it in my first email, but I did run ANALYSE before running the query... So statistics are just fine for the execution plan engine. Philippe

Re: [GENERAL] PGSQL 7.4 - 8.1 migration performance problem

(check http://www.powerpostgresql.com/PerfList) . ludwig. --- Philippe Lang [EMAIL PROTECTED] wrote: Hi, I have now disabled hyperthreading in /etc/grub.conf (added noht at the end of kernel lines), rebooted the server, run ANALYSE on the database again, and launched the query: things are even

Re: [GENERAL] Ordering of records in group by not possible

. select a,sum(b) as sum_b from c group by a order by a, sum_b ludwig lim __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast

Re: [GENERAL] evaluating equation stored in a string

Hi : How about creating a view that converts integer into numeric? create view name as select col1::numeric as col1, select col2::numeric as col2 ... and then query the view instead. This way your formula doesn't need to use cast anymore. ludwig lim --- SunWuKung [EMAIL PROTECTED] wrote

[GENERAL] Clarification Regarding Vacuum and template1

in creating a new database. Am I missing something here? Thank you very much, ludwig lim __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast

Re: [GENERAL] Clarification Regarding Vacuum and template1

, should one vacuum template1 when vacuuming other database (Assuming one doesn't use vaccumdb script when vacuuming database)? Will this problem occur if I vacuum all database except template1? Thanks for the previous quick response. Thank you once again. ludwig lim

[GENERAL] \dD does not show check constraint for domain on version 8.0.4?

://archives.postgresql.org/pgsql-patches/2005-04/msg00034.php). psql --version psql (PostgreSQL) 8.0.4 Was the patch for version 8.1? I'm just wondering why the patch was not applied to PostgreSQL version 8.0.4 Thank you! Ludwig Lim

[GENERAL] Pg - Perl 5 prob

have saved them. Logged in as user ludwig I can insert data with no problem. But as my small Perl-program tries to connect to the database, that does not work. postgres.log: Peer authentication failed for user 'ludwig' What to do? Ludwig ---(end of broadcast

[GENERAL] Sequences - problem

looking for is $#ports then ... I think this method will take a lot of time and is not very effective, as I do not think I wil ever access one of the entrys read (at least not while putting some information) ... Saluti! Ludwig ---(end of broadcast

[GENERAL] Sequences/Problem II.

Hallo! I temporary solved the problem with the sequences by making a query: select id from ports order by id desc limit 1; But I am not convinced this is the real way to get the number of element the table ports has Saluti! Ludwig ---(end of broadcast

Re: [GENERAL] Newbie Question

, and-so-on references all-other-tables ); How, each time You insert some data in huibui using insert into huibui (field1, and-son-on) values (?, ..); the 'tralala' counter will be increased by one (nextval). Saluti! Ludwig ---(end of broadcast)--- TIP

[GENERAL] Invoices

tables. Maybe someone can help? Saluti! Ludwig ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])