On Mon, 6 Mar 2000, JB wrote:
> [SNIP]
> CREATE TABLE info (
> lastname char(50),
> street_name char(50),
> street_number char(5),
> ... (a bunch of other stuff that works fine with '=')
> );
>
> CREATE INDEX nx_info1 ON info (lastname);
> CREATE INDEX nx_info2 ON info (street_name);
>
Thanks a million to you all. Finally, as someone in the list suggested, i'm
using the double backslash (\\) and it seems it works ok.
The only problem i have is when i want to escape a single quote (') or the
backslash (\).
For example: i have one row with the value 'ONE\SECOND'
I try to recove
Bruce Momjian wrote:
>Oliver Elphick wrote:
>
>> Andrzej Mazurkiewicz wrote:
>> >> And what is MATCH FULL?
>> >[Andrzej Mazurkiewicz] I would not like to speculate perhaps
>> >somebody else knows exact answer.
>>
>> MATCH FULL:
>> Either all referencing columns m
Hi all:
I'm using Postgres-6.5.3 with Red Hat 6.0 and I've a problen using
LC_TYPE and LC_COLLATE ...
I compiled Postgres --wiht-locale --with-mb=LATIN1.
I did initdb -e LATIN1
And finally I createdb -E LATIN1 test.
I also have defined
LC_TYPE=LATIN1 and
L
On Tue, 7 Mar 2000, Gabriel Fernandez wrote:
> The problem is that I do not get the result sorted as I would.
> What's wrong? What should I do?
First, test your locale. Look int src/test/locale directory. There
you'll find some test. You should create similar test for your locale (and
I'd
Hi
I am trying to create a trigger for a detail table to check that value
what
is entered exists in master table.
For example into CustomerOrder table could not be enterd order for
Customer what does not exists.
How is it best done in PostgreSQL?
I believe a trigger is what I must do.
I looked
Hi
I am trying to create a trigger for a detail table to check that value
what is entered exists in master table.
For example into CustomerOrder table could not be enterd order for
Customer what does not exists.
How is it best done in PostgreSQL?
I believe a trigger is what I must do.
I looked
Switch to v7.0 beta1 and use FOREIGN KEY. You will save a lot of time.
Before you really finish your development there will be 7.0 production (this
is my private estimation).
Andrzej Mazurkiewicz
> -Original Message-
> From: Raigo Lukk [SMTP:[EMAIL PROTECTED]]
> Sent: 7 marca 2000 13:55
>
* Raigo Lukk <[EMAIL PROTECTED]> [000307 05:36] wrote:
> Hi
>
> I am trying to create a trigger for a detail table to check that value
> what is entered exists in master table.
> For example into CustomerOrder table could not be enterd order for
> Customer what does not exists.
>
> How is it bes
Hi
On Tue, 7 Mar 2000, Andrzej Mazurkiewicz wrote:
> Switch to v7.0 beta1 and use FOREIGN KEY. You will save a lot of time.
> Before you really finish your development there will be 7.0 production (this
> is my private estimation).
> Andrzej Mazurkiewicz
I am now using PostgreSQL 6.5.3 in RedHa
JB,
The 20 seconds definitely sounds excessive. Have you done the following?
1) Run "vacuum analyze info"? If you have not, Postgres will not make use
of any indices.
2) Run an explain plan on your query to see what Postgres thinks it's going
to do?
In another post, Howie suggested more RAM
On Mon, 6 Mar 2000, Ron Atkins wrote:
> > > Does somebody know some REALLY working accounting or inventory system on LAN
> > > (not via Internet)??? - where server is PostgreSQL .Because I have feeling that
>PostgreSQL
> > > is used only with regards to Internet.
>
> Sure, Kontor... it's GPLe
Hi,
Has anyone managed to compile the 7.0 beta on a Solaris 2.6 system?
I keep getting errors. Lots of warnings concerning ecpglib.c and
finally:
ecpglib.c:1259: `ECPG_UNKNOWN_DESCRIPTOR' undeclared (first use in this function)
gmake[3]: *** [ecpglib.o] Error 1
I used this:
april:postgre
> Switch to v7.0 beta1 and use FOREIGN KEY. You will save a lot of time.
> Before you really finish your development there will be 7.0 production (this
> is my private estimation).
> Andrzej Mazurkiewicz
>
> > I am trying to create a trigger for a detail table to check that value
> > what is ente
Thank you both for the suggestions. I did not realize that 'vacuum
analyse' was nesessary to get the indexes working. That alone cut the
search time almost in half. I'll do the ram bit as well.
cheers
jb
"Culberson, Philip" wrote:
>
> JB,
>
> The 20 seconds definitely sounds excessive. Have y
Gabriel Fernandez <[EMAIL PROTECTED]> writes:
> The only problem i have is when i want to escape a single quote (') or the
> backslash (\).
>
> For example: i have one row with the value 'ONE\SECOND'
>
> I try to recover it doing (from psql frontend):
>
> select field1 from table1 where field1
Bryan Henderson wrote:
> So just specify wildcards for the IP address: *.*.*.* .
I'll have to include that, looks like a nice blanket statement. I will also
look into the password stuff. My intention is to switch to DHCP so I can
test this stuff myself.
Thank you for your help.
-Ron
**
*** IMPORTANT NOTE *** : I made an error, Kontor is not GPL'ed it is LGPL'ed...
commercial
developers might be interested in that :-)
[EMAIL PROTECTED] wrote:
> > Sure, Kontor... it's GPLed and picking up steam! Go pick up a copy here:
> > http://www.Linux-Kontor.de/en/
> you did not put i
The example you give, LIKE 'MAIN%', should be able to use the index, but I'm
not that expert on the internals of PostgreSQL. I was speaking from a general
knowledge of SQL. I was supposing you were trying to do something, such as,
LIKE '%BLVD%'. In this latter case, an index will bring you no bene
On Tue, 7 Mar 2000, Ron Atkins wrote:
> *** IMPORTANT NOTE *** : I made an error, Kontor is not GPL'ed it is LGPL'ed...
>commercial
> developers might be interested in that :-)
>
> [EMAIL PROTECTED] wrote:
>
> > > Sure, Kontor... it's GPLed and picking up steam! Go pick up a copy here:
> > >
> CREATE INDEX nx_info1 ON info (lastname);
> CREATE INDEX nx_info2 ON info (street_name);
>
> The select is as simple as this in most cases...
>
> SELECT * FROM info WHERE street_name LIKE 'MAIN%';
>
> .,,the table about 50MB worth, about 70,000 records. I have an index on
> 'lastname' and 'st
I've been shuffling thru the 'LIKE' code in pg, but whilst perusing, it
occurred to me that I could use a function for this thing. Since i'm
only looking at the first part of the string I use...
SELECT * FROM info WHERE substring(street_name from 1 to 4) = 'MAIN'
...and the query completes in u
Is there any such thing as a standard schema for international
addresses? Maybe I'm grasping at straws, but one can always hope. I
can find information about individual countries easily enough. But how
about a general solution? Or is this just pie in the sky?
Ron Peterson
[EMAIL PROTECTED]
*
> I've been shuffling thru the 'LIKE' code in pg, but whilst perusing, it
> occurred to me that I could use a function for this thing. Since i'm
> only looking at the first part of the string I use...
>
> SELECT * FROM info WHERE substring(street_name from 1 to 4) = 'MAIN'
>
> ...and the query com
Drop index and recreate.
> Hi, all.
>
> I'm relatively new to PostgreSQL, but I've been quite impressed with
> it so far. This may be due to too much experience with MySQL. :)
>
> I'm currently getting this error on my nightly vacuum. These two
> indices (as you may have guessed already) ar
25 matches
Mail list logo
