"admin" <[EMAIL PROTECTED]> writes:
> But on the alpha i got no error message no worning and inserts a wrong
> number if the number is bigger than 10^13 .
10^13? But values > 2^31 work? Man, that's really weird ... I was
expecting a failure at 2^31 if int8 wasn't compiled correctly.
I can't thi
Hi,
I have intalled Postgres 7.0.2 recently on 3 normal PC with RedHat and
Slackware to try its behavior
but its working good.
int8 thakes number much bigger then 10^13.
And if the number is to big (about 10^19 ) it generate an error message
(ERROR: int8 value out of range: ...) and don't insert i
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "admin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 26 septembrie 2000 16:31
Subject: Re: [GENERAL] Int8 problem
I send you the outputs maybe you will find an answer.
Thanks.
Hanos Felix
> "admin" <[EMAIL PROTECTE
>One of our competitors sunk well over a million bucks into Sun/Oracle
> hardware, and thought they'd be "cutting-edge" by doing all of their
> back-end programming in Java. The end result is that our $20,000 cluster
> using Linux, Postgres, and Perl out-performs their setup by a very
> signi
Just received the email on Replication server.
Based on the threads this last week, the sooner it's out there the
better..
Fantastic, yah yah yah!!!
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR) http://www.icr
Wolfville, Nova Scotia PostgreSQL, Inc.
For Release 9 p.m. EDTPO Box 1648
Tuesday, September 26th, 2000 Wolfville, Nova Scotia
Canada, B0P 1
I installed the postgresql-7.0.2-2 RPM downloaded from postgres.org, but \l+
always dumps core:
% psql
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or t
Seems Informix is having more troubles.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
.
Can the max size of the tuples be enlarged, currently they are 8128 bytes ( I
believe). Is there a macro or option that can be set to increase this?
I have a table with quite a few constraints (and the field names are large also), and
the tuple size is being exceeded, and the table can't be crea
On Tue, Sep 26, 2000 at 09:17:43AM -0400, Adam Lang wrote:
> As far as perl goes, I know some web develoeprs for a consulting firm that
> use Solaris and they are pretty tight in the industry. Their advice to me
> was that if I already don't know Perl, don't learn it. They said to take
> the Jav
* Bruce Momjian <[EMAIL PROTECTED]> [000926 13:55] wrote:
> > Alfred Perlstein wrote:
> > >
> > [snipped thread]
> >
> > OK, if I'm reading it right, the general concensus seems to be - it'll
> > work, but there is a possibility of data loss in event of system
> > crashalthough everything sh
Soft updates make file creation/destruction faster. My BSDI system uses
it, and it is clearly faster for interactive use. I never tested
PostgreSQL.
> Bruce Momjian wrote:
> >
> >
> > No, softupdates to not affect recovery. Standard PostgreSQL flushes all
> > stuff to disk on transaction com
Bruce Momjian wrote:
>
>
> No, softupdates to not affect recovery. Standard PostgreSQL flushes all
> stuff to disk on transaction commit, and this it not affected by the
> file system softupdate status.
>
AAahhh...
yes I see (light goes on in head), this was sort of aluded to in on of
the re
At 09:28 AM 9/26/00 -0400, you wrote:
>On Tue, 26 Sep 2000, J. Atwood wrote:
>
> > Zope. http://www.zope.org
> >
> > Been using PostgreSQL behind Zope for a couple of sites for over 8
> > months now and it has been a pleasure.
> >
> > Cheers,
> > J
I also use Zope and PostGres intensively over 9
On Tue, Sep 26, 2000 at 04:43:02PM -0400, Andrew Sullivan wrote:
> Have I done something wrong here, or have I stumbled on a bug?
> Shouldn't this cause an error and a rollback?
Sorry, forgot to include the usual stuff :
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2
This is th
> Alfred Perlstein wrote:
> >
> [snipped thread]
>
> OK, if I'm reading it right, the general concensus seems to be - it'll
> work, but there is a possibility of data loss in event of system
> crashalthough everything should be OK 99.9% of the time.
>
> yep, this is about what I thought.. I
Hi,
I'm new to PostgreSQL, but have installed it on a RedHat 6.2 box. We are
currently trying to migrate our existing MySQL applications to PostgreSQL,
but the differences in syntax are presenting a few problems.
My main stumbling block is the apparent lack of a function to form a hash
(or other
On Tue, 26 Sep 2000, J. Atwood wrote:
> Zope. http://www.zope.org
>
> Been using PostgreSQL behind Zope for a couple of sites for over 8
> months now and it has been a pleasure.
>
> Cheers,
> J
Hi J and Michelle.
I'm curious to try this also - I have a friend who has done alot
of work with Z
Well, I only want them to access it through a front end. No one is actually
going to be running straight out queries, creating tables, etc.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Danny" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECT
I use PHP with my Postgresql and haven't hit a limitation yet.
As far as perl goes, I know some web develoeprs for a consulting firm that
use Solaris and they are pretty tight in the industry. Their advice to me
was that if I already don't know Perl, don't learn it. They said to take
the Java r
Zope. http://www.zope.org
Been using PostgreSQL behind Zope for a couple of sites for over 8
months now and it has been a pleasure.
Cheers,
J
At 9:15 PM -0400 9/25/2000, Michelle Murrain wrote:
>Hi folks,
>
>I thought (now that I've solved my DBD::Pg problem) that I'd ask a
>fairly generic o
I've been using PostgreSQL with Lutris Enhydra for my web apps and am quite
happy with the combination. Enhydra is open source and Java-based. One of its
centerpiece components is XMLC -- an XML compiler.
For more info on Enhydra itself, see: http://www.enhydra.org/software/enhydra
For a quic
On Mon, Sep 25, 2000 at 09:15:53PM -0400, Michelle Murrain wrote:
> 1) I'm getting better and better at perl - and it's a much more
> mature language than php.
I've used perl just as a sysadmin till now, but I'm learning DBI/mod_perl
at the moment.
I found that they are very powerfull tools; th
On Tue, Sep 26, 2000 at 03:20:31AM -0700, Alfred Perlstein wrote:
> It can cause problems because softupdates makes meta data changes
> (in this case file creation/removal) asyncronously, the same actually
> happens with most other logging filesystems that don't support
> transactions.
I've been
Hi
I have intalled Postgres 7.0.2 on a Compaq Alpha with DigitalUnix.
If I insert a bigger number like 10^13 in an int8 type field i'm getting no
error messages, no warnings, but if I check the value inserted i receive
totaly wrong number like 2543
If you have any suggestions please let
I am trying to create a class for my application that handles
postgres access via the C interfaces.
My question is the following:
Will be PGresult also deleted when I close a connection with
PQfinish(PGconn), or am I supposed to delete the handle on
PGresult by myself after closing connection
ID shouldn't contain any additional informations (like order). It's ID. Use
another field for sorting.
At 16:33 22.9.2000 , Abe Asghar wrote:
>Hi everyone,
>
>I have built a database that uses int4 as the unique identifier for a news
>database.
>
>Therefore an article has a identifier 1, the next
* Dale Walker <[EMAIL PROTECTED]> [000926 01:02] wrote:
>
> Just a quick q.
>
> Does anyone know what effects FreeBSD's 'softupdates' would have
> on the /usr/local/pgsql/data filesystem.
>
> Would this help performance, or would it be a shot in the foot??
It can cause problems because softup
Just a quick q.
Does anyone know what effects FreeBSD's 'softupdates' would have
on the /usr/local/pgsql/data filesystem.
Would this help performance, or would it be a shot in the foot??
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retail
Hello,
it is possible to save the transaction log of PostgreSQL?
I would like to store daily logs and sync a second server
with this daily log (it is enough for this purpose).
Kind regards
Andreas.
30 matches
Mail list logo
