I am trying to call PL/pgSQL functions from JDBC via the Fastpath
interface. The function is executing but none of the arguments to the
function are getting set.
here is a simple example:
create function testcall (int4) returns int4 as '
begin
return $1;
end;
' language 'plpgsql';
In java I
I noticed the reference to pgacctng, an "ISP accounting package", in the
cvsup file but the collection isn't available via postgresql.org. Is this
available anywhere? Just curious.
Also, where can I find a list of cvs tags? Is there a "stable" branch
similar to FreeBSD?
Thanks,
Tim
Hi,
Suppose there is a table that's being shared among 5
computers at the same time.
Suppose I've created a CURSOR for a SELECT * FROM
that table GROUP BY column1.
Suppose I have fetched the 3rd record and am going
to fetch the 4th and in the meantime someone at
another computer just
Marcos Barreto de Castro wrote:
Hi,
Suppose there is a table that's being shared among 5
computers at the same time.
Suppose I've created a CURSOR for a SELECT * FROM
that table GROUP BY column1.
Suppose I have fetched the 3rd record and am going
to fetch the 4th and in the
Marcos Barreto de Castro [EMAIL PROTECTED] writes:
computers at the same time.
Suppose I've created a CURSOR for a SELECT * FROM
that table GROUP BY column1.
Suppose I have fetched the 3rd record and am going
to fetch the 4th and in the meantime someone at
another computer just DELETED
Barry Lind [EMAIL PROTECTED] writes:
I am trying to call PL/pgSQL functions from JDBC via the Fastpath
interface. The function is executing but none of the arguments to the
function are getting set.
Looks like fastpath.c is passing a garbage isNull flag to the function
it calls :-(. None of
I would just like to check an assumption. I "vacuum analyze" regularly. I
have always assumed that this did a plain vacuum in addition to gathering
statistics. Is this true? The documentation never states explicitly one
way or the other but it almost suggests that they are independant
"Bryan White" [EMAIL PROTECTED] writes:
I would just like to check an assumption. I "vacuum analyze" regularly. I
have always assumed that this did a plain vacuum in addition to gathering
statistics. Is this true?
Yes. There are some poorly-worded places in the docs that make it sound
I would just like to check an assumption. I "vacuum analyze" regularly. I
have always assumed that this did a plain vacuum in addition to gathering
statistics. Is this true? The documentation never states explicitly one
way or the other but it almost suggests that they are independant
{bug reports please to pgsql-bugs}
planx plnetx writes:
but if I run initdb it tell me:
***
This user will own all the data files and must also own the server process.
Creating database system directory /home/SQL/sdp
Creating database system directory /home/SQL/sdp/base
Hi,
I also have another problem.. I exported a table from access to my pg7
DB but whenever I try to do ANYTHING with that table in pgsql it tells
me Error: Relation mytablehere doesn't exist.
What the heck is up with that?!
Help! :)
Craig
I thought I'd pass along a work-around I came up with for the limits
in 'ww' support (7.0 final). Maybe this would be a useful example for
the docs? They're a little lean on date/time examples, IMO. So is the
new book.
Task:
Select a count of records from a table, grouped by the week of the
On Thu, 25 May 2000, J.R. wrote:
mkdir /home/postgres/testdata
export PGDATA2=/home/postgres/testdata
initlocation PGDATA2
createdb testdb -D 'PGDATA2'
You need to set the PGDATA2 environment variable in the environment of the
postmaster. That is, shut it down, export xxx, restart. Not
Stephane Bortzmeyer wrote:
Help me I don't wanna run the debian whith his diabolique
dselect apt-get
I run PostgreSQL on Debian without problems, it's much simpler than on Tru64, it
works fine and I seize the opportunity to congratulate the Debian maintainer of the
package, Oliver
On Fri, 26 May 2000, Bill Barnes wrote:
Connected to template1 as user 'postgres'.
Creating a new user reported an error in SQL parsing.
Found that I could create a new user by omitting any password.
Was able to edit that new user to super user privileges.
Attempting to add a password again
Hello;
when running a daily vacuum, my cron regularly reports this
message from Pg (7.0 RC1 / RH5.2 with glibc2.1 / compiled
with gcc 2.5.2):
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
Does anyone know what it means exactly ?
The
16 matches
Mail list logo