ssage-
From: [EMAIL 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
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
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 org.postgresql.fastpath.Fastpa
'accessor_group': 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 m
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?
http://www.postgresql.org/users-loung
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]>
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, gr
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
hello.
i am trying to develop a relatively clean process for creating/populating a
new database. i have all of the table creation scripts and am about to
start writing scripts to populate the db with the necessary default data (an
admin user, a guest user, default application info, default prefe
: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
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
LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL 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 i
NEW
variable is 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 someon
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 proc
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?
thanks
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
s
16 matches
Mail list logo
