Sean <[EMAIL PROTECTED]> wrote:
> I am using PostgreSQL version 7.0.2 with RedHat 6.1. When I start up the
> postmaster at the prompt, I get the following response and the session hangs
> and doesn't return to the prompt but I am able to use my databases and
> PostgreSQL. Is this normal or correc
How does one escape parenthesis in a regular expression in Postgres?
An example is:
select * from subcategories where subcategory ~* '401(k)';
Which does not work. I've tried:
select * from subcategories where subcategory ~* '401\(k\)';
That still didn't work. Any advice would be much
This solved my problem...
Thank-you
Sean.
_
You are probably not telling Postgres to run in the background. You should
use the -S parameter. IE: postgres -S -i -D /usr/local/pgsql/data
For full info on the startup o
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> If you've got a CVS tree handy, there's a nifty perl script at:
> http://www.red-bean.com/~kfogel/cvs2cl.shtml
> that generates a GNU style ChangeLog directly from the cvs logs.
Ah, I thought someone somewhere must have written something like thi
On Thu, Jul 13, 2000 at 04:58:54PM -0400, Tom Lane wrote:
> Ed Loehr <[EMAIL PROTECTED]> writes:
> > Can anyone point me to a list of changes and bug-fixes *by release* for
> > 7.0.1 and 7.0.2 over 7.0?
>
> The only really accurate info is in the CVS logs. Bruce usually
> prepares a summary for
You are probably not telling Postgres to run in the background. You should
use the -S parameter. IE: postgres -S -i -D /usr/local/pgsql/data
For full info on the startup options, do a man postmaster from your
shell. Or take a look at the administration docs.
At 01:05 PM 7/14/00, Sean Alpho
Pressing enter doesn't solve the problem.
Sean.
___
On Fri, Jul 14, 2000 at 10:04:04AM -0500, Sean Alphonse wrote:
> Hello.
> I am using PostgreSQL version 7.0.2 with RedHat 6.1. When I start up the
> postmaster at
"Sean Alphonse" <[EMAIL PROTECTED]> writes:
> I am using PostgreSQL version 7.0.2 with RedHat 6.1. When I start up the
> postmaster at the prompt, I get the following response and the session hangs
> and doesn't return to the prompt but I am able to use my databases and
> PostgreSQL. Is this norma
While using RedHat 6.1 with PostgreSQL 7.0.2, if I use the following command
at the prompt allowing for the postmaster to run
[root@cd480405-a sean]# /etc/rc.d/init.d/postgresql start
will this allow me to connect to my databases across the internet?
Thank-you for your time.
Sean.
Hello.
I am using PostgreSQL version 7.0.2 with RedHat 6.1. When I start up the
postmaster at the prompt, I get the following response and the session hangs
and doesn't return to the prompt but I am able to use my databases and
PostgreSQL. Is this normal or correct? If not, what should I do to fix
On Fri, 14 Jul 2000, Thomas Lockhart wrote:
> (My mailer was fouled up; I had sent this a few days ago...)
>
> > > The documentation of Postgresql 7.0.2 says that the statement:
> > > SET DATESTYLE TO 'Postgres';
> > > would led to an output of the form:
> > > Wed Dec 17 07:37:16 1997 PST
> > >
> ... I know all the stats show the MySQL is faster...
A story which, if and when true, stays true only for cases with one or a
very few users. We used to just accept MySQL's claims in this regard
without question, but it is finally dawning on us that they are not
doing representative tests for
Arg! Thanks to everyone for their help. I followed a few suggestions I
got from here, and installed Time::HiRes on my box (that part was my
idea actually ;)), to monitor how long the query's take. I know all the
stats show the MySQL is faster, but in my situation, postgres is really
kicking ass
(My mailer was fouled up; I had sent this a few days ago...)
> > The documentation of Postgresql 7.0.2 says that the statement:
> > SET DATESTYLE TO 'Postgres';
> > would led to an output of the form:
> > Wed Dec 17 07:37:16 1997 PST
> > but I can't reproduce this behavior!!!
>
> lockhart=# sele
On Fri, Jul 14, 2000 at 12:33:20AM +0200, Peter Eisentraut wrote:
> Patrick Welche writes:
>
> > .. of course for me it's in libedit:
> >
> > % nm -g /usr/lib/libedit.a | grep using_history
> > 028c T using_history
>
> Is libedit readline compatible now?
On a NetBSD-1.5B/i386 box, accordin
> I thought that wouldn't work because PHP > doesn't substitute variables
> between single quotes :-(
You're right, it doesn't. But you don't _have_
single quotes in this case; the single quotes
are simply chars _inside_ the double_quoted
PHP string:
database = pg_Connect ("host=db.example.c
Title: VS: [GENERAL] performance question
>Tom Lane wrote:
>>
>> ernie cline <[EMAIL PROTECTED]> writes:
>> > Quick question. I am using postgres 7.0. When running a select query,
>> > does postgres lock the row (or table) while doing a select? Only on an
>> > insert/update/delete, right?
17 matches
Mail list logo
