Hi, All
Where can I get a PostGreSQL 7.1 lattest beta version with RPM installation?
JACK
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
> > I am pretty sure that pg_dump produces a consistent snapshot, using
> > the same transaction isolation mechanism (MVCC) as the database
> > itself. If one of the gurus posts and says otherwise, believe him,
> > not me. ;)
>
> My impression from reading the source was that it was consitant pe
> SELECT sum(grade) / count(grade) As GPA FROM grades;
> (bad juju if 0)
No kidding... that kid totally failed ALL his classes! And before someone
points it out, yes I saw the DBZ.
Greg
---(end of broadcast)---
TIP 1: sub
You didn't mention which version either of those machines are running. I
believe in 7.1 Postgres the database filenames changed to a numerical
database id of some sort. Prior to that, they were named the same as the
database. I don't know the reasoning behind the switch, but I'm fairly sure
it was
On Thu, 29 Mar 2001, Richard Huxton wrote:
> From: "Martín Marqués" <[EMAIL PROTECTED]>
>
> > Is it a bad idea to put tables of different aplications, even if they have
> > somethings in comun, in the same database?
>
> Plus points :
> Minus points :
As I have not received an answer to my pos
On Thu, Mar 29, 2001 at 08:25:30AM +, Phuong Ma wrote:
> I'm using PostgreSQL version 7.1, and I'm having trouble with the LIKE
> statement. How would I find the value "a\bc"? I tried using the
> backslash to escape it: LIKE 'a\\b%';
>
> If I specify: LIKE 'a\\bc', then it works, but if I w
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Actually, this used to work, but for some reason it's called 'set
> random_seed' now. I seem to be responsible for this, although I can't
> imagine what the motivation might have been. Should I change it back?
If "set seed" worked in 7.0.* then I t
Tom Lane writes:
> Alexey Borzov <[EMAIL PROTECTED]> writes:
> > The development docs state that one can use SET SEED to seed the
> > random number generator
>
> Where? I see no such claim. If there's something that leads you
> to think that SET SEED and not setseed() is correct, then the docs
I gave up from using ODBC... to much problems with blobs and other stuff...
and really very low speed under Delphi. Try Zeos Database Components for
Postgre(http://www.marms.com/zeos). I've been using for 6 mounths and its
great. Blobs greater than 8Kb still are a big problem, but you will see thi
From: "Martín Marqués" <[EMAIL PROTECTED]>
> Hi
> Is it a bad idea to put tables of different aplications, even if they have
> somethings in comun, in the same database?
>
> Saludos... :-)
Plus points :
+ If you need to join between tables you will *need* to do this
Minus points :
- You will
Hi,
Richard Huxton wrote:
>
> > CREATE TABLE referer (
> >id SERIAL,
> >referer varchar(2048) NOT NULL PRIMARY KEY
> >);
[...]
>
> Why have you got id as a serial if referer is your primary key? Oh - I
> suppose it's easier to reference a serial of course, less data to carry
> aroun
--- Sean Harding <[EMAIL PROTECTED]> wrote:
> I have a table, 'mesg_headers', which holds headers from email
>
> messages. Each message has a unique integer ID within the
> system,
> 'mesgid'. mesgid is the primary key for mesg_headers, so it
> has index
> mesg_headers_pkey. This index is used i
On Wed, Mar 28, 2001 at 10:27:36PM -0600, will trillich wrote:
> more generally, what changes are possible to enhance performance
> of select queries? forcing indexes vs. seqential scans, using
> different joins that don't need sorting, etc. what's available?
You're not going to know what your q
Alexey Borzov <[EMAIL PROTECTED]> writes:
> The development docs state that one can use SET SEED to seed the
> random number generator
Where? I see no such claim. If there's something that leads you
to think that SET SEED and not setseed() is correct, then the docs
need to be fixed.
Soma Interesting <[EMAIL PROTECTED]> writes:
> Why does the following code return the exact same value each time, instead
> of a value based on the current time?
> CREATE FUNCTION memb_num () RETURNS INT4 AS '
> BEGIN
> RETURN date_part(''epoch'', CURRENT_DATE);
> END;
i am seeing NullPtrExs with the following stack trace:
java.lang.NullPointerException
at org.postgresql.Connection.ExecSQL(Connection.java:312)
at org.postgresql.jdbc2.Connection.commit(Connection.java:173)
at
com.commnav.sbh.framework.persist.JDBCConnection.disconnect(JDBCConnection.j
ava:416)
a
On Wed, Mar 28, 2001 at 11:46:42PM -0800, Soma Interesting wrote:
>
> >blah blah blah
> >
> >...and that all meant what? The postgres manual is open to much
> >interpretation to anyone new trying to understand its contents. Combine
> >that with documentation that's still not written, or broken
Hi everybody,
I have a little question about string types in PostgreSQL: it seems I don't
understood well how string data are stored in the database, from a recent
post by Tom Lane I feel encouraged to think that VARCHAR and TEXT are
treated the same way by PG, i.e. they occupy ony the space neede
Upon further review... :-)
I had a look at the ntp website, and there is a bunch of links at the
bottom. http://www.eecis.udel.edu/~ntp/ is the main ntp page.
http://www.bsdi.com/date/date?PRC is pretty interesting. It appears that
someone has already figured out the time in the various timezon
Hi
Is it a bad idea to put tables of different aplications, even if they have
somethings in comun, in the same database?
Saludos... :-)
--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-
Martin Marques
On Wednesday, March, 2001-03-28 at 16:55:55, will trillich wrote:
> On Thu, Mar 29, 2001 at 12:17:31AM +0200, Marek Pętlicki wrote:
> > On Tuesday, March, 2001-03-27 at 21:42:39, markus jais wrote:
> > >
> > > in MySQL I can type something like in Bash on my linux box:
> > >
> > > $ mysql -u roo
At 07:56 28/03/01 -0500, chris markiewicz wrote:
>Hello.
>
>I am occasionally (seemingly randomly) seeing the following error when I try
>to load a large object.
>
>FastPath call returned ERROR: lo_close: invalid large obj descriptor (0)
You must setAutoCommit(false) before using any large objec
On Wed, Mar 28, 2001 at 04:13:19PM -0800, Soma Interesting wrote:
> I have the following trigger/stored procedure:
>
> CREATE FUNCTION memb_num () RETURNS opaque AS '
> BEGIN
> NEW.member_num := date_part(''epoch'', timestamp ''now'');
At 09:43 16/03/01 -0500, Raymond Chui wrote:
Delayed as I only read General once in a while - jdbc mails should go to
the jdbc list.
>I have PostgreSQL jdbc7.0-1.2.jar JDBC drive.
>
>I found out if a column of a table is Timestamp data type
>
>Properties p = new Properties();
>p.put("PGTZ", "GM
24 matches
Mail list logo