Re: [GENERAL] unable to publish layer

2011-02-05 Thread Craig Ringer
On 02/05/2011 07:36 PM, gargdevender74 wrote: i have got .img and .rrd file and it is read by the geoserver but unable to publish in layer. plz help me out http://wiki.postgresql.org/wiki/Guide_to_reporting_problems It's also possible that you may want the PostGIS mailing lists, not here. Ei

Re: [GENERAL] Looking for Suggestion on Learning

2011-02-05 Thread ray joseph
> On Saturday, February 05, 2011 9:30:13 am ray wrote: > > I have built a few databases with MS Access and I would like to learn > > how to use pgsql. I have found some examples but they have been too > > complex to follow or to abstract with no specific details. > > > > I would like to find a s

Re: [GENERAL] CRUD functions, similar to SQL stored procedurs, for postgresql tables?

2011-02-05 Thread Rob Sargent
margaretgil...@chromalloy.com wrote: We use some SQLserver databases that have stored procedures for all C.R.U.D. functions so the same code is used no matter what language the developer is working in. The procedures are built by a master package that reads the table structures and creates the

Re: [GENERAL] Looking for Suggestion on Learning

2011-02-05 Thread John R Pierce
On 02/05/11 9:30 AM, ray wrote: I have built a few databases with MS Access and I would like to learn how to use pgsql. I have found some .. Access really isn't a database, its an application development system that happens to use databases, by default the Jet engine. Postgres would re

Re: [GENERAL] Looking for Suggestion on Learning

2011-02-05 Thread Adrian Klaver
On Saturday, February 05, 2011 9:30:13 am ray wrote: > I have built a few databases with MS Access and I would like to learn > how to use pgsql. I have found some examples but they have been too > complex to follow or to abstract with no specific details. > > I would like to find a simple example

Re: [GENERAL] PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting

2011-02-05 Thread Pavel Stehule
2011/2/5 Adam PAPAI : > Pavel Stehule wrote: >> Hello >> >> You should to initialize database with correct locale. You can't to >> change locale after database is created. >> >> /usr/local/pgsql91/bin/createdb test --locale=cs_CZ.utf-8 -e UTF-8 >> CREATE DATABASE test LC_COLLATE 'cs_CZ.utf-8' LC_CT

Re: [GENERAL] PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting

2011-02-05 Thread Adam PAPAI
Pavel Stehule wrote: > Hello > > You should to initialize database with correct locale. You can't to > change locale after database is created. > > /usr/local/pgsql91/bin/createdb test --locale=cs_CZ.utf-8 -e UTF-8 > CREATE DATABASE test LC_COLLATE 'cs_CZ.utf-8' LC_CTYPE 'cs_CZ.utf-8'; > COMMENT

[GENERAL] Database Design - Which design should I use? Two options.

2011-02-05 Thread Andre Lopes
Hi, I'm designing a database, but I'm with some doubts in the design. I have posted a question in stackoverflow because of the use of images. Can someone give some clues about which design should I use? The link to the question is here: http://stackoverflow.com/questions/4909105/database-design-

Re: [GENERAL] set theory question

2011-02-05 Thread Vincent Veyron
Le vendredi 04 février 2011 à 19:08 +0100, Yeb Havinga a écrit : > On 2011-02-03 18:41, Wappler, Robert wrote: > > On 2011-02-02, matty jones wrote: > > > >> I am looking for a good book on the math and/or theory behind > >> relational databases and associated topics.. I am looking > >> some works

Re: [GENERAL] PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting

2011-02-05 Thread Pavel Stehule
Hello 2011/2/5 Adam PAPAI : > I have a PgSQL node on a FreeBSD 8.1-RELEASE. > > (PostgreSQL) 9.0.3 client/server. > > pkg_info | grep 'postgresql' > postgresql-client-9.0.3 > postgresql-server-9.0.3 > > > I have a lots of UTF8 database with hu_HU.UTF8 COLLATE and LC_CTYPE > > For example: > > test

[GENERAL] Looking for Suggestion on Learning

2011-02-05 Thread ray
I have built a few databases with MS Access and I would like to learn how to use pgsql. I have found some examples but they have been too complex to follow or to abstract with no specific details. I would like to find a simple example that would take me from an open source design tool to a simple

[GENERAL] PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting

2011-02-05 Thread Adam PAPAI
I have a PgSQL node on a FreeBSD 8.1-RELEASE. (PostgreSQL) 9.0.3 client/server. pkg_info | grep 'postgresql' postgresql-client-9.0.3 postgresql-server-9.0.3 I have a lots of UTF8 database with hu_HU.UTF8 COLLATE and LC_CTYPE For example: test | pgsql | UTF8 | hu_HU.UTF-8 | hu_HU.UT

[GENERAL] unable to publish layer

2011-02-05 Thread gargdevender74
i have got .img and .rrd file and it is read by the geoserver but unable to publish in layer. plz help me out -- View this message in context: http://postgresql.1045698.n5.nabble.com/unable-to-publish-layer-tp3372409p3372409.html Sent from the PostgreSQL - general mailing list archive at Nabble.