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
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
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
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
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
-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
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
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
-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
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
> -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
>
>
-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
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
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
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
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
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 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
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
-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
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
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
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
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
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,
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
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
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
> 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
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)---
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
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
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 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
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
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
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
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
-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.
>
39 matches
Mail list logo
