PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of chris markiewicz
Sent: Thursday, April 12, 2001 9:36 AM
To: 'Peter Mount'; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [JDBC] RE: fastpath error?
Regarding the fastpath error (ERROR: lo_close: invalid large obj descriptor
(0
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)
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)
at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:141)
at
hello
i am trying to remove a foreign key that i placed on a database. what is
the easiest way to find/delete the constraint?
thanks
chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
': 6 Triggers
were expected, but got 4.
is there any way that i can re-insert them?
if i'm screwed, then how do i drop this table?
i really appreciate your help.
chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of chris markiewicz
Sent: Tuesday, March
hello
i received an error when someone ran an input stmt with a very long sting.
the field is of type 'text'. The error (along with the statement) are shown
below. what is the proper way do execute this insert?
The SQL Statement is too long - INSERT INTO accessor_group ( groupid,
groupname,
i am using jdbc7.0-1.2...postgres 7.0.2.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 10:28 AM
To: Gavin Sherry
Cc: chris markiewicz; [EMAIL PROTECTED]
Subject: Re: [GENERAL] length of insert stmt?
Gavin Sherry [EMAIL PROTECTED] writes
hello
i want to find the differences between two database schemas...is there a
function for this or do i just pg_dump both of them and do a diff in unix?
thanks
chris
:36 PM
To: chris markiewicz
Cc: [EMAIL PROTECTED]
Subject: Re: performance...
First thing to try is to do
explain select * from weather where weatherid = 12372;
and see if it's doing a sequential scan on your table.
If it is, the index and table stats may be out of date
and I think you fix those
Sorry, too many clients already
hello. i am getting the above message when i try to connect. where do i
find documentation about connection management? i want to be able to see
all current connections and kill some of them. how do i do that?
thanks
chris
hello.
i have been trying to create a trigger or trigger/function combination but i
have so far been unsuccessful. my task is simple, when someone inserts a
row in the PERSON table, create a row in the RESOURCE table (note that i
have to pass parameters). details below...
first, the basic
s returned (NEW represents the row that is being inserted and so
fired the trigger)
Nelson
chris markiewicz wrote:
hello.
i have been trying to create a trigger or trigger/function combination but
i
have so far been unsuccessful. my task is simple, when someone inserts a
row in the PERSON tab
L LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
LANCOMPILER 'PL/pgSQL';
Nelson
chris markiewicz wrote:
Gotcha. So what's the story on pl/pgsql? The documentation says:
"PL/pgSQL is a loadable procedural language for the Postgres database
system."
What does
hello.
can anyone recommend a windows ui tool for viewing data in postgres?
essentially i want to use something other than the command line for looking
at results. as an emample, i'm looking for the equivalent of TOAD for
Oracle. is the easiest approach to connect in MS Access via odbc?
could this be a servlet/thread issue? i cannot tell from the code snippet,
but remember that variables in a servlet with class scope are essentially
static. (i am guessing that query, rs, stmt, etc are all class scope. this
is very dangerous, in the programming sense of the word...) i've had
15 matches
Mail list logo
