On Apr 1, 2009, at 4:51 PM, Oleg Bartunov wrote:
Grant,
I'm originator of this thread and PostgreSQL is also a big user of the
Snowball project, so we also are very interested in the vital
activity of the project. However, I see issue with license, which is
currently BSD and this allows us
Hi Bernd,
Bernd Helmle wrote:
--On Mittwoch, August 27, 2008 09:35:03 +0200 Grant Finnemore
[EMAIL PROTECTED] wrote:
I have a session pool, where all connections to the database are
obtained as a superuser. On issuing connections to the client, we
invoke either SET ROLE or SET SESSION
Hi Alvaro,
Alvaro Herrera wrote:
Grant Finnemore wrote:
Well, pg_stat_activity isn't really the problem here, because as you
point out, it's just a view, and I could certainly redefine the view.
The limiting factor is that the backend doesn't push the role name
changes to the stats subsystem
Hi Euler,
Euler Taveira de Oliveira wrote:
Grant Finnemore escreveu:
Invoking pg_stat_activity after the SET ROLE is changed will however
leave the usename unchanged.
You're right. Because, as you spotted, usename is synonym of session
usename.
The one problem with this mapping is that per
=# select current_user, session_user;
current_user | session_user
--+--
grant| grant
(1 row)
test=# select usename from pg_stat_activity;
usename
-
grant
(1 row)
test=# set session role bob;
SET
test= select current_user, session_user;
current_user
Hi,
This is on Intel OSX, anon CVS download today.
Build process:-
1. make distclean
2. ./configure --enable-debug --enable-cassert --enable-integer-datetimes
--prefix=/Users/grant/Development/bin/pgsql --enable-depend
3. make all install
The query with no EXPLAIN (ANALYSE) completes fine
to getting the values of output parameters.
Regards,
Grant
Gavin Sherry wrote:
On Thu, 23 Sep 2004, Grant Finnemore wrote:
Hi Gavin,
Although I have not read the SQL 2003 spec, my recollection of other database
products' stored procs differed from your description in one significant way,
namely
= connection.prepareCall(call get_info_for_user ?);
cs.setString(1, test);
if(cs.execute()) {
ResultSet rs = cs.getResultSet();
while(rs != null) {
// Process rs
}
}
Regards,
Grant
Magnus Hagander wrote:
[snip]
Not a user of JDBC, but this is fairly common in the ADO/ADO.NET
are handled using operations inherited
from Statement.
Regards,
Grant
Gavin Sherry wrote:
Hi all,
Following is a proposal to implement what SQL2003 calls 'SQL-Invoked
Procedures' and what most people refer to as stored procedures. Fujitsu
will be funding Neil Conway and I to work on this feature
be
documented.
Regards,
Grant
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
It's happened again, and in both cases seems to be on a call to
VACUUM FULL
Grant Finnemore wrote:
Hi,
I am using a version of PostgreSQL compiled from a CVS update of yesterday,
and compiled with
make clean all
make install
One client connection to the database doing routine and low volume
I'm afraid that I did not get a core dump. Sorry.
My normal configure includes both debug and cassert - is there anything
else I should set to ensure core dumps are generated?
Regards,
Grant
Tom Lane wrote:
Grant Finnemore [EMAIL PROTECTED] writes:
TRAP: FailedAssertion(!(((ntp)-t_data)-t_infomask
Ok, will do. Thanks.
Tom Lane wrote:
Grant Finnemore [EMAIL PROTECTED] writes:
I'm afraid that I did not get a core dump. Sorry.
My normal configure includes both debug and cassert - is there anything
else I should set to ensure core dumps are generated?
Check ulimit -c in the postmaster's
localhost.localdomain 2.6.6-1.435 #1 Mon Jun 14 09:09:07 EDT 2004 i686
i686 i386 GNU/Linux
./bin/postmaster -F
HTH.
Regards,
Grant
-- PRE NESTED XACTS
[EMAIL PROTECTED] pgbench]$ ./pgbench -c 5 -t 1000 bench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 5
RHL 9.0
cvs HEAD, fresh update
make maintainer-clean
./configure --with-java --prefix=/home/grant/bin/pgsql/ \
--with-integer-datetimes --enable-debug --enable-cassert
make
yields:
gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../../src/include
the -d flag, I have no problems
in connecting from psql.
Any ideas?
Regards,
Grant
Necessary info:
. Sources are CVS tip, pulled today
. uname -a
Linux localhost.localdomain 2.4.20-19.9 #1 Tue Jul 15 17:18:13 EDT 2003 i686
i686 i386 GNU/Linux
. gcc --version
gcc (GCC) 3.2.2 20030222 (Red Hat Linux
to not include this line.
I have seen this behaviour in both 7.2 and 7.3. Is it a bug? Or
am I misunderstanding something?
Regards
Grant
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
On Fri, 2003-11-07 at 11:31, Stephan Szabo wrote:
On Thu, 7 Nov 2003, Grant McLean wrote:
So it would seem that if I include the clauses:
on delete restrict on update restrict
Then the 'deferrable' which follows is only applied to creates and
not to updates or deletes
[EMAIL PROTECTED] (Tom Lane) wrote in message news:[EMAIL PROTECTED]...
Manfred Koizar [EMAIL PROTECTED] writes:
better. AFAICS Vivek's problem is that it is hard enough to hold a
good part of the working set in the cache, and still his disks are
saturated. Now a VACUUM not only adds one
.
Regards,
Grant
Neil Conway wrote:
There has been some previous discussion of changing the FE/BE protocol
in 7.4, in order to fix several problems. I think this is worth doing:
if we can resolve all these issues in a single release, it will lessen
the upgrade difficulties for users.
I'm aware
the following:-
DECLARE
rec my_return_type%ROWTYPE
The function definition then becomes:-
CREATE OR REPLACE FUNCTION myfunc(integer) RETURNS SETOF my_return_type ...
Regards,
Grant Finnemore
Masaru Sugawara wrote:
Hi, all
Does 7.3 support SETOF RECORD in plpgsql ?
As far as I test
Hi all. I'm not a good DB admin , thats why I'm posting to this list !
How can I figure out the size of a database or table ???
It was easier in older versions of postgresql to perform a `du -h` on
the directory that corresponded to the database name. However now they
are named by some type of
Hi all. I'm not a good DB admin , thats why I'm posting to this list !
How can I figure out the size of a database or table ???
It was easier in older versions of postgresql to perform a `du -h` on
the directory that corresponded to the database name. However now they
are named by some type of
Possibly create a timeout for psql. pg_dump, pg_restore and other clients.
If they can not connect to a certain host within a certain period it will
quit with an error. I have psql's still running for 6 days from crontab
that could not connect to a bogus IP address.
I checked the idocs and
Is it at all possible to use vim to interact with psql to provide
input? That would be cool!
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Can you see a scenario where a programmer would forget to delete the
data from pg_largeobject and the database becoming very large filled
with orphaned large objects?
Sure. My point wasn't that the functionality isn't needed, it's that
I'm not sure vacuumlo does it well enough to
Is it just me or is an address on the hackers list who's mail is handled
by wmail.metro.taejon.kr not existant?
On Tue, 31 Jul 2001, Mail Delivery Subsystem wrote:
The original message was received at Tue, 31 Jul 2001 14:25:00 +1000 (EST)
from IDENT:[EMAIL PROTECTED]
-- The following
--
Date: Tue, 24 Jul 2001 09:45:01 +1000 (EST)
From: Grant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: vacuumlo.
G'day,
I've recently discovered that LO's do not get deleted when a record
referencing that OID is removed. I'm assuming you created the program and
do you think it is possible to get
Is it possible to get [vacuumlo] included in the main vacuumdb program for
support to vacuum orphaned large objects?
Hmm. I'm not convinced that vacuumlo is ready for prime time...
in particular, how safe is it in the presence of concurrent
transactions that might be adding or removing
When I delete a table that has an OID, the OID does not get deleted
correct? How can I delete the data from the large object?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
know...
Yes, I am running WAL enabled.
regards, tom lane
Regards,
Grant
--
Poorly planned software requires a genius to write it
and a hero to use it.
Grant Finnemore BSc(Eng) (mailto:[EMAIL PROTECTED])
Software Engineer Universal Computer Services
Tel
ou are now connected to database test.
Is it just me?
Regards,
Grant
--
Poorly planned software requires a genius to write it
and a hero to use it.
Grant Finnemore BSc(Eng) (mailto:[EMAIL PROTECTED])
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366PO Box 31266 Braamfo
s of columns that I have renamed.
I'm very frightened right now, because I'm rather
dependent upon my database right now. I don't like
the thought that my database is corrupt at the schema
level.
michael
__
Do You Yahoo!?
Yahoo! Messenger -
33 matches
Mail list logo