Hi,
I have it working now, I must have missed the stats_command_string
setting in the conf file.
Thanks,
Tony
Michael Fuhr wrote:
On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote:
When I run the following on my server:
SELECT * FROM pg_stat_activity
I get back for the field current
On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote:
> When I run the following on my server:
> SELECT * FROM pg_stat_activity
>
> I get back for the field current_query.
>
> I have stats enabled in my config file, is there some other setting that
> I missed so I can see the current qu
On Wed, Jan 12, 2005 at 11:49:12AM -0700, Ed L. wrote:
>
> Is it possible via SQL query to tell how long a transaction has been open?
I'm not aware of a way to find out when a transaction started, but
if you have stats_command_string enabled then you can query
pg_stat_activity to see when a sessi
Would anyone be interested in beta testing it?
If so please respond directly to me and I will get back to you with details.
It has a really advanced function editor complete with code completion
and parameter hinting.
It also has a tabbed Enterprise Manager where each database opens in
it's own t
Hi,
When I run the following on my server:
SELECT * FROM pg_stat_activity
I get back for the field current_query.
I have stats enabled in my config file, is there some other setting that
I missed so I can see the current query?
I also thought that in 7.x it would say idle if the connection was j
One final pgEdit beta before the release of PostgreSQL 8.0. In addition
to bug fixes and usability improvements, 1.0b6 includes the following
new features:
* Direct execution of SQL and psql commands without including them in
the document. Commands can be executed at the bottom of the editor
w
Ahh, ok. Misunderstood what your method was.
Is there a setting in your ODBC driver for memo as text or something
like that? It's been a while since I played with pgsql from a windows /
odbc box, so I am a bit rusty here. It's just a wild guess.
On my Windows box the Postgresql ODBC driver
On Wed, 2005-01-12 at 18:12 -0500, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > I'm wondering if the function under = is an SQL function being inlined.
>
> Bingo --- that's surely it. After inlining, the expression would no
> longer look like it matched the index.
>
> You don'
Margaret,
Josue,
Are you using Postgresql on a Windows Server or on a Linux Server?
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
Both platforms, I'm developing with VFP for Postgresql 7.4.3 running on
RH Linux 8 and also work in another app for Postgresql 8.0 RC4 win32.
I guess you
The date on the ODBC driver I have is 10/8/2004. Running on WinXP Pro.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 12, 2005 5:23 PM
To: Josué Maldonado
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgresql Text field / Visual F
> El 12/01/2005 4:40 PM, [EMAIL PROTECTED] en su mensaje
escribio:
> > I just downloaded and installed the lastest PGADMIN III, but I didnt'
get a
> > new ODBC driver. The only file in the download was pgadmin3.msi.
> >
> > The driver I have is ODBC version 7.03.02.00 dated 10-22-2003. That is
the
Stephan Szabo <[EMAIL PROTECTED]> writes:
> I'm wondering if the function under = is an SQL function being inlined.
Bingo --- that's surely it. After inlining, the expression would no
longer look like it matched the index.
You don't want to use SQL functions to define indexable operators
anyway.
OK, to answer my own question (typo's possible, works here ;-)):
CREATE TYPE abonnementartikelheader AS (col1 int4, col2 int4);
CREATE OR REPLACE FUNCTION getabonnementartikelheader(int4)
RETURNS SETOF abonnementartikelheader AS
'
select
(SELECT COUNT(klantnummer)::int4 FROM abo_klt WHER
On Wed, 12 Jan 2005, Tom Lane wrote:
> Jeff Davis <[EMAIL PROTECTED]> writes:
> > I think I created a type that was compatible with the btree index, and
> > everything seems fine, except that it doesn't actually use the index. I
> > created the operators and the opclass as well.
>
> > => explain s
On Wed, Jan 12, 2005 at 04:43:13PM -0500, Tom Lane wrote:
> Jeff Davis <[EMAIL PROTECTED]> writes:
> >
> > => explain select * from test where t = '(2)';
> > QUERY PLAN
> > -
> > Seq Scan on test (cos
El 12/01/2005 4:40 PM, [EMAIL PROTECTED] en su mensaje escribio:
I just downloaded and installed the lastest PGADMIN III, but I didnt' get a
new ODBC driver. The only file in the download was pgadmin3.msi.
The driver I have is ODBC version 7.03.02.00 dated 10-22-2003. That is the
newest driver I se
On Wed, 12 Jan 2005 17:08:26 -0300 (ART), Clodoaldo Pinto
<[EMAIL PROTECTED]> wrote:
> There was a power failure and then the postgresql service didn't start on
> system restart:
>
> System restart after power failure:
> Jan 12 16:49:06 s1 syslogd 1.4.1: restart.
> Jan 12 16:49:18 s1 su(pam_unix)[
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
Josué Maldonado <[EMAIL PROTECTED]> wrote on 01/12/2005 01:50:07 PM:
> El 12/01/2005 3:38 PM, [EMAIL PROTECTED] en su mensaje
escribio:
>
> > I am using updatable cursors. I set up the cursor and set the cursor
> > properties to updateab
Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:36:34 PM:
> On Wed, 2005-01-12 at 15:28, [EMAIL PROTECTED] wrote:
> > Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:06:30
PM:
> >
> > > On Wed, 2005-01-12 at 14:59, [EMAIL PROTECTED] wrote:
> > > > I am using ODBC to move Visual
El 12/01/2005 3:38 PM, [EMAIL PROTECTED] en su mensaje escribio:
I am using updatable cursors. I set up the cursor and set the cursor
properties to updateable and set the key field property so it knows the key
on the Postgresql table. The cursors are managed by a VFP class written by
a programmer n
Jeff Davis <[EMAIL PROTECTED]> writes:
> I think I created a type that was compatible with the btree index, and
> everything seems fine, except that it doesn't actually use the index. I
> created the operators and the opclass as well.
> => explain select * from test where t = '(2)';
>
On Wed, 2005-01-12 at 15:28, [EMAIL PROTECTED] wrote:
> Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:06:30 PM:
>
> > On Wed, 2005-01-12 at 14:59, [EMAIL PROTECTED] wrote:
> > > I am using ODBC to move Visual FoxPro7 tables (windows 2000 client)
> into
> > > Postgresql 7.x on a Redhat L
Josué Maldonado <[EMAIL PROTECTED]> wrote on 01/12/2005 01:14:39 PM:
> Hello,
>
> El 12/01/2005 2:59 PM, [EMAIL PROTECTED] en su mensaje
escribio:
> > I am using ODBC to move Visual FoxPro7 tables (windows 2000 client)
into
> > Postgresql 7.x on a Redhat Linux server. All is working well except f
Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:06:30 PM:
> On Wed, 2005-01-12 at 14:59, [EMAIL PROTECTED] wrote:
> > I am using ODBC to move Visual FoxPro7 tables (windows 2000 client)
into
> > Postgresql 7.x on a Redhat Linux server. All is working well except for
> > Memo fields, whic
Hello,
El 12/01/2005 2:59 PM, [EMAIL PROTECTED] en su mensaje escribio:
I am using ODBC to move Visual FoxPro7 tables (windows 2000 client) into
Postgresql 7.x on a Redhat Linux server. All is working well except for
Memo fields, which are Text fields in PostgreSql. I query the Postgresql
table and
On Wed, 2005-01-12 at 14:59, [EMAIL PROTECTED] wrote:
> I am using ODBC to move Visual FoxPro7 tables (windows 2000 client) into
> Postgresql 7.x on a Redhat Linux server. All is working well except for
> Memo fields, which are Text fields in PostgreSql. I query the Postgresql
> table and get a cur
I am using ODBC to move Visual FoxPro7 tables (windows 2000 client) into
Postgresql 7.x on a Redhat Linux server. All is working well except for
Memo fields, which are Text fields in PostgreSql. I query the Postgresql
table and get a cursor, update the cursor with the data, and send it back.
The co
Hi,
Is it possible to return the following (parameterized) qyery from a sql or
plpsql function, and if so, what is the syntax?
SELECT{ (SELECT COUNT(klantnummer) FROM abo_klt WHERE
abonnement = $1),
(SELECT SUM(aantal_abonnementen)FROM abo_klt WHERE
On Wednesday January 12 2005 1:08, Clodoaldo Pinto wrote:
> There was a power failure and then the postgresql service didn't start on
> system restart:
>
> The last activity before power failure was a vacuum full and after that
> nothing at all for more than one hour.
> Is there anyway to know why
I think I created a type that was compatible with the btree index, and
everything seems fine, except that it doesn't actually use the index. I
created the operators and the opclass as well.
=> create type type2 as (i int);
=> create operator = (leftarg=type2,rightarg=type2,procedure=type2_eq);
=>
We, that is, Geoffrey, applied the patch and rebuilt the rpm's. I have
installed the new rpm and the problem is resolved. We are in the process of
converting a transportation package from a commercial database product to
Postgres. On at least two occassions, I have reported bugs to that software
There was a power failure and then the postgresql service didn't start on
system restart:
System restart after power failure:
Jan 12 16:49:06 s1 syslogd 1.4.1: restart.
Jan 12 16:49:18 s1 su(pam_unix)[2098]: session opened for user postgres by
(uid=0)
Jan 12 16:49:18 s1 su(pam_unix)[2098]: session
On Wednesday January 12 2005 11:10, Scott Marlowe wrote:
>
> I believe the problem is occurring if the open transaction is older than
> the tuples that could be vacuumed. The MVCC system means that as long
> as a transaction that started X hours ago is still open, the tuples that
> have been freed
On Wed, Jan 12, 2005 at 12:00:22PM -0600, Tony Caduto wrote:
> Does anyone know if such functions have been added to version 8?
See the 8.0 Release Notes in the development documentation:
* Add function to send cancel request to other backends (Magnus)
See also the "System Administration Func
The cancel function is implemented. See
http://developer.postgresql.org/docs/postgres/functions-admin.html#FUNCT
IONS-ADMIN-SIGNAL-TABLE.
Kill function was considered too dangerous.
//Magnus
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tony Ca
On Wed, 2005-01-12 at 11:59, Ed L. wrote:
> I'm looking at some 7.3.4 vacuum output, and at first glance it does not
> appear that vacuum is reclaiming any dead tuple space if there is even a
> single open transaction, even if the open transaction does not in any way
> reference the table being
I'm looking at some 7.3.4 vacuum output, and at first glance it does not
appear that vacuum is reclaiming any dead tuple space if there is even a
single open transaction, even if the open transaction does not in any way
reference the table being vacuumed. Is that correct? Is the behavior
dif
Does anyone know if such functions have been added to version 8?
I saw lots of discussion while searching google and saw references to
patches applied and docs.
Google link:
http://groups-beta.google.com/group/comp.databases.postgresql.patches/browse_thread/thread/8dc627fdbe4b830d/2b4364d42a95b88
Greg Stark <[EMAIL PROTECTED]> writes:
>> but since that's not the default mode anymore anyway, I'm not very
>> concerned.
> What's not the default mode? I'm just running "pg_dump -U postgresql -s db"
As of 8.0, I meant.
regards, tom lane
---(end
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > It seems the spurious SET SESSION AUTHORIZATION commands appear after any
> > REVOKE/GRANT pair.
>
> Oh, right. In order to handle grants with GRANT OPTION, the dump data
> may need to include SET SESSION AUTHORIZ
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> What I find somewhat interesting is every other database I've used that
> exposes some kind of 'object ID' has a set of functions to map between
> an object name and it's ID, and vice-versa.
regression=# create function myfunc(int) returns int as 'selec
Hi all,
We have a postgresql server running on a Linux machine. Our aim is to develop a bunch of SPI stored procedures to automate a production process.
We use Eclipse with CDT plugin for C programming.
Is there a mean to debug SPI functions with Eclipse (or any other tool) as it is possible wi
On Wed, Jan 12, 2005 at 04:08:28PM +0100, Thomas Hallgren wrote:
> Jim C. Nasby wrote:
> >Is there an easy way to get the OID of the currently running function?
> >(IE: the function you're in when you execute the code to see what
> >function you're in, if that makes any sense).
>
> In what languag
Greg Stark <[EMAIL PROTECTED]> writes:
> It seems the spurious SET SESSION AUTHORIZATION commands appear after any
> REVOKE/GRANT pair.
Oh, right. In order to handle grants with GRANT OPTION, the dump data
may need to include SET SESSION AUTHORIZATION commands; so the code
assumes that it doesn't
Jim C. Nasby wrote:
Is there an easy way to get the OID of the currently running function?
(IE: the function you're in when you execute the code to see what
function you're in, if that makes any sense).
In what language? In C you can use:
Datum your_function(PG_FUNCTION_ARGS)
{
Oid funcOid
On Tue, 11 Jan 2005, Tom Lane wrote:
Greg Stark <[EMAIL PROTECTED]> writes:
7.4.6 pg_dump seems to be inserting a lot more SET SESSION
AUTHORIZATION lines than previously.
By "previously" do you mean 7.4.5 or thereabouts? I can't recall any
late-7.4.* changes that might affect this. pg_dump is su
Is there an easy way to get the OID of the currently running function?
(IE: the function you're in when you execute the code to see what
function you're in, if that makes any sense).
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.dist
On Tue, 11 Jan 2005, Geoffrey wrote:
Tom Lane wrote:
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
Apparently, if DateStyle is set to Sql, it always returns the absolute
value.
Is this due to some Sql standard or is it a bug?
It's a bug in interval_out. Looks like it gets it wrong for GERMAN
styl
48 matches
Mail list logo
