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", "GMT");
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 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 object.
On Wednesday, March, 2001-03-28 at 16:55:55, will trillich wrote:
On Thu, Mar 29, 2001 at 12:17:31AM +0200, Marek Ptlicki 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 root -p file.sql
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
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
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
On Wed, Mar 28, 2001 at 11:46:42PM -0800, Soma Interesting wrote:
blah blah blah snip
...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
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)
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;
'
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.
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
--- 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 if I do
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
around.
oh, in
From: "Martn Marqus" [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 need to
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
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
need to
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 think
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 posted
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
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:
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 per-table
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
23 matches
Mail list logo