-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nick Bower wrote:
> We're considering using Postgresql for storing gridded metadata - each point
> of our grids has a variety of metadata attached to it (including lat/lon,
> measurements, etc) and would constitute a record in Postgresql+Postgis.
>
hellow everyone,
how to add postgresql service by command on windows?
thanks.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mes
from a running
oracle DB, but I have not ORACLE running. I just have old ORACLE/SQL
sources that I need parser to SQL or PostgSQL.
3. About the ambitious project "protopg", I success to compile this
projects but the parser fall. The parse have a problem with a word
"CONSTRAI
For the record:
Those are the records in my locale.gen
# cat /etc/locale.gen.old
en_US ISO-8859-1
he_IL UTF-8
he_IL ISO-8859-8
I found out that by removing "he_IL ISO-8859-8" i fixed the problem.
Why ? i have no idea ( maybe some collisions because the double he_IL ? ).
Cheers
Michael B
Hi all,
Well my problem was
that I didn't know if Tsearch2 can work on hebrew data without a
fitting stemmer, my current solution is to use the 'simple' dictionary
so no lexem is returned.
I wonder if there is an hebrew stemmer which I can use but I can't seem
to find one, so sadly one of the
On Tue, Sep 05, 2006 at 02:56:21PM +0300, Michael Ben-Nes wrote:
> For the record:
>
> Those are the records in my locale.gen
>
> # cat /etc/locale.gen.old
> en_US ISO-8859-1
> he_IL UTF-8
> he_IL ISO-8859-8
Yeah, that's wrong. The first column is the identifier, so the last
entry should somethi
On 9/5/06, gustavo halperin <[EMAIL PROTECTED]> wrote:
Chris Mair wrote:
>> I need to porting many old ORACLE-oriented-SQL files and I have many
>> problem with this code. Sometimes the code use some types not supported
>> in PosgSQL like "number" or "varchar2", there fore, can I write some
>> t
On 9/5/06, aBBISh <[EMAIL PROTECTED]> wrote:
hellow everyone,
how to add postgresql service by command on windows?
look at pg_ctl command. specifically, the 'register' option.
merlin
---(end of broadcast)---
TIP 6: explain analyze is your frien
er fall. The parse have a problem with a word
"CONSTRAINT", see below:
protopg-20060905 : ./ora_parser < tes.sql
-- syntax error, unexpected "CONSTRAINT", expecting ORA_ID on line 6 --
-- BEGIN OF UNRECOGNIZED STATEMENT
CREATE TABLE v5templates . cmt_items
Merlin Moncure 写道:
On 9/5/06, aBBISh <[EMAIL PROTECTED]> wrote:
hellow everyone,
how to add postgresql service by command on windows?
look at pg_ctl command. specifically, the 'register' option.
merlin
thank you ~ :)
---(end of broadcast)---
> 3. About the ambitious project "protopg", I success to compile this
> projects but the parser fall. The parse have a problem with a word
> "CONSTRAINT", see below:
> protopg-20060905 : ./ora_parser < tes.sql
> -- syntax error, unexpected &q
On Tue, 5 Sep 2006, Yonatan Ben-Nes wrote:
Hi all,
Well my problem was that I didn't know if Tsearch2 can work on hebrew data
without a fitting stemmer, my current solution is to use the 'simple'
dictionary so no lexem is returned.
I wonder if there is an hebrew stemmer which I can use but I
gustavo halperin <[EMAIL PROTECTED]> writes:
> 1. The orafce from www.pgfoundry.org doesn't pass the make step, is
> looking for some files that doesn't exist, see below:
> orafce : make
> Makefile:16: ../../src/Makefile.global: No such file or directory
> Makefile:17: /contrib/contri
No, I didn't thought
that it will be useful if it won't be accompanied by an hebrew stemmer
which will work with it... I'm wrong?
Oleg Bartunov wrote:
On Tue, 5 Sep 2006, Yonatan Ben-Nes wrote:
Hi all,
Well my problem was that I didn't know if Tsearch2 can work on hebr
On Tue, 5 Sep 2006, Yonatan Ben-Nes wrote:
No, I didn't thought that it will be useful if it won't be accompanied by an
hebrew stemmer which will work with it... I'm wrong?
ispell and stemmer are doing the same job, so you may use
ispell,simple configuration instead of "ideal" one: ispell,
Oleg Bartunov wrote:
On Tue, 5 Sep 2006, Yonatan Ben-Nes wrote:
No, I didn't thought that it will be useful
if it won't be accompanied by an hebrew stemmer which will work with
it... I'm wrong?
ispell and stemmer are doing the same job, so you may use
ispell,simp
Perhaps you should look at EnterpriseDB -- It's an Oracle-compliant wrapper
for postgreSQL
"gustavo halperin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello
>
> I need to porting many old ORACLE-oriented-SQL files and I have many
> problem with this code. Sometimes t
It's generally considered bad form to use reserved words as column names
""Frank Church"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I am trying to create a view based on this query
>
> 'select *, "timestamp"::timestamp from ccmanager_log'
>
>
> This is the error I get to
Could you run the unix command 'top' and figure out where your performance
degradation is before you assume it is a database issue...
"Toffy" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> as i put Postrgesql and Mysql in the same server Linux (Fedora core 5),
> is it poss
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eliminating 21 line .signatures would be nice, too.
codeWarrior wrote:
> Perhaps you should look at EnterpriseDB -- It's an Oracle-compliant wrapper
> for postgreSQL
>
>
>
>
> "gustavo halperin" <[EMAIL PROTECTED]> wrote in message
> news:[E
Does anybody has a clue?
Somebody experienced similar problem?
Should I be logged to Windows as regular user
(administrator) or as "postgres" service account?
Thanks.
- Original Message -
From:
Zlatko Matić
To: pgsql-general@postgresql.org
Sent: Tuesday, September 05
On Mon, 2006-09-04 at 16:54, gustavo halperin wrote:
> Hello
>
> I need to porting many old ORACLE-oriented-SQL files and I have many
> problem with this code. Sometimes the code use some types not supported
> in PosgSQL like "number" or "varchar2", there fore, can I write some
> type of decla
On Tue, 2006-09-05 at 12:20, Zlatko Matić wrote:
> Does anybody has a clue?
> Somebody experienced similar problem?
> Should I be logged to Windows as regular user (administrator) or as
> "postgres" service account?
>
> Thanks.
> - Original Message -
> From: Zlatko Matić
On 9/1/06, Randall Lucas <[EMAIL PROTECTED]> wrote:
On Fri, Sep 01, 2006 at 09:30:57AM -0400, Merlin Moncure wrote:
> A key tenet of relational thinking is to reduce all information to its
> functional dependencies, and to try and avoid as much as possible
> keeping information state in the data
No, nothing changed.
I am the only user of this computer (personal computer). It is the same
account I was using for installing PostgreSQL server.
In fact I had the same problem with upgrading from PostgreSQL 8.0 to 8.1,
then from 8.1 to 8.2...In all theses cases I had to uninstall old version
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eliminating 21 line .signatures would be nice, too.
How about your 16 lines ;)
Sincerely,
Joshua D. Drake
codeWarrior wrote:
Perhaps you should look at EnterpriseDB -- It's an Oracle-compliant wrapper
for postgreSQL
Hi,
How do I enable kerberos support? I have run configure with --with-krb5, but when I try to run psql, it still returns "Kerberos 5 authentication not supported".
Thanks,
Terry
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joshua D. Drake wrote:
> Ron Johnson wrote:
> Eliminating 21 line .signatures would be nice, too.
>
>> How about your 16 lines ;)
??? It's 8 lines.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is "common sense" really valid?
For example, it is "common
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
> Sent: 05 September 2006 20:36
> To: pgsql-general@postgresql.org
> Subject: [OT] sig sizes (was Re: [GENERAL] Porting from ...)
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
On Tue, 2006-09-05 at 13:59, Zlatko Matić wrote:
> No, nothing changed.
> I am the only user of this computer (personal computer). It is the same
> account I was using for installing PostgreSQL server.
> In fact I had the same problem with upgrading from PostgreSQL 8.0 to 8.1,
> then from 8.1 to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave Page wrote:
>
>
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
>> Sent: 05 September 2006 20:36
>> To: pgsql-general@postgresql.org
>> Subject: [OT] sig sizes (was Re: [GENERAL] P
Hi,
The most general problem that may be a design problem (and I'm not asking to do
my homework even if well, you may still help ) is I've a "temporary
relation" and a permanent relation.
A typical situation is the one of session in a web app and temporary basket.
Once the user log in, the temp
On 9/5/06, codeWarrior <[EMAIL PROTECTED]> wrote:
It's generally considered bad form to use reserved words as column names
I am aware of that - in this case the column names are chosen to
reflect exactly the names of the attributes of the event being
recorded.
""Frank Church"" <[EM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank Church wrote:
> On 9/5/06, codeWarrior <[EMAIL PROTECTED]> wrote:
>> It's generally considered bad form to use reserved words as column
>> names
>>
>
> I am aware of that - in this case the column names are chosen to
> reflect exactly the n
I've run across another GIN index issue - using postgresql 8.1.4 on
Window/Linux with the GIN/tsearch2 patch.
I have two tables like this:
CREATE TABLE maps
(
id serial,
query tsearch2.tsquery
)
CREATE TABLE features
(
id serial,
vector tsearch2.tsvector
)
CREATE INDEX idx_features_t
Sorry, mistyped the query causing the problem. It is:
select *
from maps, features
where maps.query @@ features.tags_vector;
Thanks,
Charlie
Charlie Savage wrote:
I've run across another GIN index issue - using postgresql 8.1.4 on
Window/Linux with the GIN/tsearch2 patch.
I have two tabl
Charlie Savage <[EMAIL PROTECTED]> writes:
> Sorry, mistyped the query causing the problem. It is:
> select *
> from maps, features
> where maps.query @@ features.tags_vector;
In that case it's fair to ask what query values you have stored in maps.
In particular I imagine that you'll find that a
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
Sent: 05 September 2006 20:36
To: pgsql-general@postgresql.org
Subject: [OT] sig sizes (was Re: [G
Hi Tom,
Thanks for the quick reply.
>> Sorry, mistyped the query causing the problem. It is:
>
>> select *
>> from maps, features
>> where maps.query @@ features.tags_vector;
>
> In that case it's fair to ask what query values you have stored in maps.
> In particular I imagine that you'll find
39 matches
Mail list logo
