>>In article <[EMAIL PROTECTED]>, Bruce Momjian
><[EMAIL PROTECTED]> writes:
>> Could someone enlighten me here? He seemed absolutely positive that
>> a disconnect is as good as a commit and always has been.
> Disconnect should abort the transaction. It does in PostgreSQL, and I
> _hope_ ever
Hi,
I would like to do something like
select attr from table
where
oneof list1 IN list2;
such as
select attr from table where
oneof ('apple', 'orange', 'banana') IN ('mango','coconut','banana');
list1 and list2 are attributes in some table(s).
I have three options:
1) There is actually some S
Phil Culberson wrote:
> I ran a couple of tests against an Oracle 7.3.4 database.
Thanks!
> I inserted a row into a table, then immediately typed exit. The insert was
> committed automatically.
>
> I also did an insert and then killed SQL*Plus with a SIGKILL from another
> window. The tra
Here is a thought.
Even if your CLASSPATH is correct, unless you pass this information into
the program:
java -Djdbc.drivers=postgresql.Driver myclass
-or-
Class.forName("postresql.Driver");
{in the program}
you'll get that error.
Chris
Andreas Jerke wrote:
>
> Hello Postgres User,
>
I have been trying to get a colleague to update a database on my server
using a form I sent him for MS Access. The form was developed using
Access'97 and seems to work just fine on my PC. I just emailed the .mdb
file.
Everything worked well for the first couple of iterations of the form.
I added
Chris Sutton wrote:
>
> I would like to use the oid as a unique key for a table but in creating
> a test table and playing around with inserts, things don't seem to be
> working as I thought they would.
>
> Where am I going wrong?
There is a hidden column named 'oid'. Try "select oid, desc fr
What is the correct way to create a table column that timestamps itself
whenever an insert OR update occurs.
Here is my guess
create table (
x int2
modtime timestamp current()
);
but from reading the docs on the website, it seems that current() gives
you a timestamp when
Your problem probably has nothing to do with Postgres. It looks like your
java program cannot find the driver classes. Make sure that the driver is in
your classpath. If you are using Apache+Jserv, add the driver to Jserv's
classpath as well.
> Hello Postgres User,
>
> I can not get a DataBase C
Andreas,
Not to go too far out of the scope of this list, but what does your connection
code look like? are you trying to import the driver via an "import" statement
(don't do this). Also, did you build the JDBC driver for JDK 1.1, or JDK1.2,
there's some documentation in the source directory
[EMAIL PROTECTED] wrote:
> This is probably the best way to do this sort of thing, however as an addition,
> for the benefit of the writer of the question, I'd like to warn him that it's
> not exactly the same behavior that a default value gives you.
>
> insert into t1 (a,b) values (1, NULL) will
I ran a couple of tests against an Oracle 7.3.4 database.
I inserted a row into a table, then immediately typed exit. The insert was
committed automatically.
I also did an insert and then killed SQL*Plus with a SIGKILL from another
window. The transaction was NOT committed.
So, by default, SQ
I would like to use the oid as a unique key for a table but in creating
a test table and playing around with inserts, things don't seem to be
working as I thought they would.
create table test (
key oid,
desc varchar(30));
Then I do an insert
insert into test (desc) values ('inf
How can I find out size in bytes of a large object?
Hello Postgres User,
I can not get a DataBase Connection over JDBC.
I have configured the pg_hba.conf (host all 127.0.0.1 255.255.255.255 trust), so
that all local processes like Jserv are able to connect to the DB over TCP/IP.
I have installed the latest JDBC driver and JAVA finds the
class po
Mike Mascari wrote:
> So, apparently, your friend is assuming that since SQL*Plus is
> performing a COMMIT when the user exits normally, all
> transactions are being committed on disconnect. This is most
> definitely NOT true. You're right to feel your friend's
> statements were completely backwa
I believe what you want is called a "left outer join": include all records
in one table (projects) and records that match it on the joined tables
(all the others). Try something like this (UNTESTED):
SELECT p.project_id, p.project_title,
SUM(t.timespent)
FROM project p, subproject s, timelog t
W
> I am very much a self taught sql programmer, and I only use it for a
> few small projects at home. Work requires just a bit of db work on my
> part, there are others who do the heavy lifting :-)
>
> I was surprised when one of my heavy lifting co-workers told me that
> when a transaction is be
[EMAIL PROTECTED] wrote:
>
> I am very much a self taught sql programmer, and I only use it for a
> few small projects at home. Work requires just a bit of db work on my
> part, there are others who do the heavy lifting :-)
>
> I was surprised when one of my heavy lifting co-workers told me tha
Maybe you didn't send the right snippet from your SQL, but your example
shows you building an index on "ref_ref_inspec", and the query you are
having a problem with has a WHERE clause referencing "ref_ref_article".
-Original Message-
From: Peter Haworth [mailto:[EMAIL PROTECTED]]
Sent: T
I am very much a self taught sql programmer, and I only use it for a
few small projects at home. Work requires just a bit of db work on my
part, there are others who do the heavy lifting :-)
I was surprised when one of my heavy lifting co-workers told me that
when a transaction is begun, if the
20 matches
Mail list logo