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
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 objec
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
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 timezon
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
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
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
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 q
--- 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
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
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
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
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
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
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
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
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
> 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
> > 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
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
24 matches
Mail list logo
