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
style
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!
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
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
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
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 language? In C
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
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 'select $1'
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 AUTHORIZATION
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 of
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:
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
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
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
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
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
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]:
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
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);
=
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 did
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
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
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
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
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, which are
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 for
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 Linux server.
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)';
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 FoxPro7 tables
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
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 updateable and
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)[2098]:
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
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
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 select * from
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
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.
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
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
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
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't want to
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
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
Hi,
When I run the following on my server:
SELECT * FROM pg_stat_activity
I get back command string not enabled 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
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
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
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 command string not enabled for the field current_query.
I have stats enabled in my config file, is there some other setting that
I missed so I
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 command string not
48 matches
Mail list logo