i've got two systems, one a pentium 233 with adaptec 2940, scsi, using vinum
running a big postgresql database, and a new one, dual pentium 550, dual adaptec
29160, not using vinum, and another big postgresql database.
the first system runs 3.4-stable and gets spontaneous reboots infrequently,
a
On Tue, Mar 21, 2000 at 12:06:05PM +0100, Pawe³ Dubin wrote:
> > the first system runs 3.4-stable and gets spontaneous reboots infrequently,
> > and there are no messages (dmesg, console or syslog) indicating why it rebooted.
> > the new system runs 4.0-stable, doesn't have vinum, and is spontaneo
Hi,
I have some problems using LIKE within strings which have brackets.
For example if i do:
select code from codes where code like '(4)' ;
i do not obtain nothing. But in the DB indeed there is a row whose code
is '(4)'.
I have tried to escape the brackets with '\\(4\\)' or with ' \(4\)' but
Hi,
please remember I had increased the -N value to 64.
The only different is the time between the crashes is
two days longer.
Is this a bug? Should I go bach to 6.4.2 or should
I try 7.0beta?
Uwe
Hi All:
Working with :
-W98
-Delphi 4.0
-Linux Red Hat
6.0
-Postgresql
6.5.3
-ODBC Driver
6.40
When I try to execute a query
against a table (125000 registers , 45 columns )
I get next
message:
Read Failure
Error while executing the
query
It seems to work in version 6.5.2 but not in version 6.5.3 what's happened
with
-E parameter ?
from man psql:
...
PSQL(UNIX)
PostgreSQL
PSQL(UNIX)
-E Echo
the actual query generated by \d and other
backslash commands
-f filena
Gabriel,
If you defined column "code" as a CHAR(n), you will need to have a "%"
wildcard at the end of your search string to allow for padding.
select code from codes where code like '(4)%' ;
Example:
business=> create table foo ( mytext char(10) );
CREATE
business=> insert into foo values ('4'
Hi Ed...
Well...I have installed 7.0b1 as well...and I'm using it personally...but I
can't recommend moving a project to a beta...
I don't want to have to do two migrations, as I'm already moving our system from
MySQL to postgres...so if I can wait a little while and move directly from MySQL
to a
Hmm. I had also tried with "code" as a VARCHAR and it worked properly on my
system.
business=> create table foo ( mytext varchar(10) );
CREATE
business=> insert into foo values ( '4' );
INSERT 120521 1
business=> insert into foo values ( '(4)' );
INSERT 120522 1
business=> select *
> Hi,
> please remember I had increased the -N value to 64.
> The only different is the time between the crashes is
> two days longer.
> Is this a bug? Should I go bach to 6.4.2 or should
> I try 7.0beta?
I would try that as a test. 7.0beta2 is quite stable.
--
Bruce Momjian
Gabriel Fernandez wrote:
>
> Hi,
>
> I have some problems using LIKE within strings which have brackets.
>
> For example if i do:
>
> select code from codes where code like '(4)' ;
>
> i do not obtain nothing. But in the DB indeed there is a row whose code
> is '(4)'.
>
> I have tried to esc
Gabriel Fernandez wrote:
> Hi,
>
> I have some problems using LIKE within strings which have brackets.
>
> For example if i do:
>
> select code from codes where code like '(4)' ;
>
> i do not obtain nothing. But in the DB indeed there is a row whose code
> is '(4)'.
>
> I have tried to escape the
set digest
Had this rebooting problem before for a while and it drove me NUTZ! Installed RedHat
and FreeBSD and both rebooted periodically. Don't know if my solution will help or
not,
but what was causing my reboots was the system BIOS. The options for Power Management
in the system BIOS should have some
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi Ed...
>
> Well...I have installed 7.0b1 as well...and I'm using it personally...but I
> can't recommend moving a project to a beta...
> I don't want to have to do two migrations, as I'm already moving our system from
> MySQL to postgres
How can I check an empty string field with a query?
If I make a select ... where fieldname ='' then I get no result!! What is
the right way?
Mit freundlichen Grüßen / Best regards
Robert Esser
mit Consulting München
[EMAIL PROTECTED] (please remove no_spam_)
Hello,
Does anyone have any experience using postgresql with coda? What I would
like to do is use 2 coda servers for replication on a 2 node cluster. If
the primary node running postgresql goes down, than the secondary node
would take over and start a postgresql server on the replicated coda
file
Robert Esser wrote:
>
> How can I check an empty string field with a query?
>
> If I make a select ... where fieldname ='' then I get no result!! What is
> the right way?
If you mean a field with a null value (nichts drin) then use
where fieldname IS NULL
>
> Mit freundlichen Grüßen / Best
Hi!
As the digest of the general mailing list now (nearly) works perfectly
for me, i have a question:
Is it in the users hand to decide the size of the digest? I receive
digests 3-4 times a day but would be more happy receiving them only once
a day (which was true as long majordomo was ruling)
Jim,
We have postgresql 6.5.3 (and before that 6.4) running on a low end pentium
intel architecture with BSDI3.0 for our devel environment. We experience
sponteous reboots less than once per month but we are convinced that this is
a hardware/OS issue nothing to do with Postgresql.
Just my $0.02
Jo
Is it possible to unlink large objects using SQL? I see import and export and
I can unlink from a program, but is it possible to use a query to unlink them?
Was wondering if there was a way to use an aggregate value in a single
select query to make a calculation within that query...
Example:
Table has column bool of type boolean with various random boolean
values.
Want to see if it is possible (in a single select query) to find the
percentage of ent
Arthur,
I suspect you could create an aggregate function to do it the same way that
avg() works more or less.
John Henderson
>Was wondering if there was a way to use an aggregate value in a single
>select query to make a calculation within that query...
>
>Example:
>Table has column bool of type
23 matches
Mail list logo