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 allo
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
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 S
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
le:-
test=# 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;
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
bleStatement cs = 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, b
gards,
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 that they could return multiple (and varie
et objects 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
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"
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("
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 v
and thought it should at least be
documented.
Regards,
Grant
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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
-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
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
output
definition 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:
[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
.
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
(
foo integer,
bar text
);
Now, the declare block has 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
>
> 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 o
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 search
> 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 o
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
me
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
> > > 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
> > 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 re
--
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 t
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 YourEm
hat Hiroshi thought I broke a couple days ago.
> Let me 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:[EMA
test
You 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
also, and this may actually the source of the problem,
> while scanning my full (schema and data) dump, I
> noticed that the contents of table pga_layout also had
> the old values of columns that I have renamed.
>
> I'm very frightened right now, because I'm rather
> depe
also, and this may actually the source of the problem,
> while scanning my full (schema and data) dump, I
> noticed that the contents of table pga_layout also had
> the old values of columns that I have renamed.
>
> I'm very frightened right now, because I'm rather
> depe
34 matches
Mail list logo
