On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
Craig Ringer cr...@postnewspapers.com.au writes:
I do think this comes up often enough that a built-in trigger update
named column with result of expression on insert trigger might be
desirable.
There's something of the sort in contrib
2009/11/24 Hannu Krosing ha...@2ndquadrant.com
On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
Craig Ringer cr...@postnewspapers.com.au writes:
I do think this comes up often enough that a built-in trigger update
named column with result of expression on insert trigger might be
You may use connection pooling for idle connections like pgbouncer or pgpool.
Following link will give you details about pgbouncer pgpool.
https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer
http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html
Hope it may help you!!!
Harald Fuchs wrote:
For larger tables where an index search would be useful, check out
pgfoundry.org/projects/prefix:
...
Wow ... yet another enlightment
Thankyou, I realy appreciate
Sincerely
-bino-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
select procpid, current_query, now() - query_start as duration, backend_start
from pg_stat_activity where current_query not like '%IDLE%' order by duration
desc
limit 10;
Hope it may help you!!!.
--
Thanks
Sam Jas
--- On Mon, 23/11/09, Tim Uckun timuc...@gmail.com wrote:
From: Tim Uckun
Alexandra Roy wrote:
I am still trying to build DBD::Pg but I have another question.
Is it possible to do a 64-build of DBD::Pg ?
I ask this because PostgreSQL 8.3.8 has been compiled in 64 bits mode
and if DBD::Pg expects to find 32 bits library, this can explain my
problem...
I would
Hello
Have you enabled autovacuum?
Pavel
p.s. please, don't use pgsql-commiters mailing list for general questions.
use pgsql-general.
2009/11/24 Allan Morris Caras amsca...@yahoo.com:
I have accidentally / stupidly deleted records from a table.
I tried delete from where exist and it
Hi,
No, auto vacuum is not enabled.
- Original Message
From: Pavel Stehule pavel.steh...@gmail.com
To: Allan Morris Caras amsca...@yahoo.com
Cc: pgsql-general@postgresql.org PG-General Mailing List
pgsql-general@postgresql.org
Sent: Tue, November 24, 2009 6:14:22 PM
Subject: Re:
2009/11/24 Allan Morris Caras amsca...@yahoo.com:
Hi,
No, auto vacuum is not enabled.
ok then don't try to call vacuum in any form. so some undelete is
possible. It was good new. Bad new - nobody wrote any tool for it.
There are pgfsck, but itsn't three years actualised - but you can try
it.
Dear All
Harald Fuchs wrote:
For larger tables where an index search would be useful, check out
pgfoundry.org/projects/prefix:
CREATE TABLE myrecords (
record prefix_range NOT NULL,
PRIMARY KEY (record)
);
COPY myrecords (record) FROM stdin;
1
12
123
1234
\.
I downloaded pgfoundry's
On Tue, 2009-11-24 at 09:46 +, Thom Brown wrote:
2009/11/24 Hannu Krosing ha...@2ndquadrant.com
On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
Craig Ringer cr...@postnewspapers.com.au writes:
I do think this comes up often enough that a built-in
Hi,
I tried to test it but it says couldn't find class 'pg_attribute'
When I tried looking into the table that deleted records from, it didn't revert
back what I've deleted.
Any clues?
- Original Message
From: Pavel Stehule pavel.steh...@gmail.com
To: Allan Morris Caras
On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote:
Anyway, how can I get rid those idle in transaction processes?
Can I just kill -15 them or is there a less drastic way to do it?
Are you crazy? Sure, if you want to destroy all of the changes made to the
database in that transaction and
On 24 Nov 2009, at 24:08, Kris Gale wrote:
Table public.example
Column | Type | Modifiers
-+--+---
body| text |
vectors | tsvector |
user_id | bigint |
I've got btree_gin and btree_gist installed, so I can make a composite index
on
2009/11/24 Allan Morris Caras amsca...@yahoo.com:
Hi,
I tried to test it but it says couldn't find class 'pg_attribute'
It is strange - but this software isn't maintained long time, and it's
not actual.
so it is a bad
Pavel
When I tried looking into the table that deleted records from, it
In our DB we create partition table for each month (our naming
convetion is follow , and I would like to create trigger that insert
data to appropriate partition table accounting.cdr_y2009m05,
accounting.cdr_y2009m06 etc..).
What is the best solution to create such trigger? I can create trigger
On Tue, Nov 24, 2009 at 11:04:58AM +, lee brown wrote:
The following bug has been logged online:
Bug reference: 5211
Logged by: lee brown
Email address: lee_bro...@msn.com
PostgreSQL version: 8.3
Operating system: vista
Description:invalid password
Matthew Wakeling wrote:
On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote:
Anyway, how can I get rid those idle in transaction processes?
Can I just kill -15 them or is there a less drastic way to do it?
Are you crazy? Sure, if you want to destroy all of the changes made to
the database in that
On Tue, 24 Nov 2009, Denis Lussier wrote:
IMHO the client application is already confused and it's in Prod.
Shouldn't he perhaps terminate/abort the IDLE connections in Prod and
work on correcting the problem so it doesn't occur in Dev/Test??
The problem is, the connection isn't just IDLE - it
Hi Laurenz, hi all,
Laurenz, you are right once again !! By default, perl is 32-bit in AIX
5.3 !
The 64-bit and 32-bit versions are packaged together, with the 32-bit
version being the default version. Both versions reside under the
/usr/opt/perl5 directory. Both versions are Perl thread
Alexandra Roy wrote:
= I thought that I was using perl 64-bit but it was not the case :-(
All the builts I did, for DBI, DBD::Oracle, etc..., have been done with
perl 32-bits...
But Oracle is 64 bit and PostgreSQL 8.3.8 has been built in 64 bit too.
If you install 64-bit Oracle (in fact
My database is encoded UTF8. I recently was uploading (via COPY) some
census data which included place names with ñ, é, ü, and other such
characters. The upload choked on the Latin characters. Following the
docs, I was able to fix this with:
SET CLIENT_ENCODING TO 'LATIN1';
COPY table FROM
Lee Hachadoorian lee.hachadoor...@gmail.com writes:
My database is encoded UTF8. I recently was uploading (via COPY) some
census data which included place names with ñ, é, ü, and other such
characters. The upload choked on the Latin characters. Following the
docs, I was able to fix this with:
2009/11/23 Alexandra Roy alexandra@bull.net:
Hi all,
Hi Alexandra,
And what about on the fly please ?
As I encounter compilation problem on AIX 5.3, I am wondering if DBD::Pg is
necessary to use ora2pg...
Josh pointed that out to you 4 days ago. It means w/o having to save
intermediate
Uh, no. You can pretty much assume that LATIN1 will take any random
byte string; likewise for any other single-byte encoding. UTF8 as a
default is a bit safer because it's significantly more likely that it
will be able to detect non-UTF8 input.
regards, tom lane
Andrew Dunstan and...@dunslane.net wrote:
Part of the motivation for allowing inline blocks was to allow for
conditional logic. So you can do things like:
DO $$
begin
if not exists (select 1 from pg_tables
where schemaname = 'foo'
Kevin Grittner kevin.gritt...@wicourts.gov writes:
So we're conceding that this is a valid need and people will now have
a way to meet it. Is the argument against having CINE syntax that it
would be more prone to error than the above, or that the code would be
so large and complex as to
In article 4b0bbc8e.6010...@indoakses-online.com,
Bino Oetomo b...@indoakses-online.com writes:
I downloaded pgfoundry's prefix, postgresql-8.3-prefix_1.0.0-1_i386.deb
I install it using dpkg , and run the prefix.sql
Create database .. named 'prefbino', and
CREATE TABLE myrecords (
record
Tom Lane t...@sss.pgh.pa.us wrote:
The argument against CINE is that it's unsafe.
By no means rhetorically, is that based on the assumption that the
statement would not validate that the existing object (if any) matches
the supplied definition?
The fragment proposed by Andrew is no safer,
On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
So we're conceding that this is a valid need and people will now have
a way to meet it. Is the argument against having CINE syntax that it
would be more prone to error than
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Tom Lane t...@sss.pgh.pa.us wrote:
The argument against CINE is that it's unsafe.
By no means rhetorically, is that based on the assumption that the
statement would not validate that the existing object (if any) matches
the supplied
Robert Haas robertmh...@gmail.com writes:
On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
But actually I thought we had more or less concluded that CREATE OR
REPLACE LANGUAGE would be acceptable (perhaps only if it's given
without any extra args?).
I'm not sure there's
On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
But actually I thought we had more or less concluded that CREATE OR
REPLACE LANGUAGE would be acceptable (perhaps
Tom Lane t...@sss.pgh.pa.us wrote:
If it did so, that would be outside the apparent meaning of the
command, which is to do nothing if an object of that name exists.
That's why we've gone with CREATE OR REPLACE instead.
I think that fail on existence of an object conflicting with given
Scott Marlowe scott.marl...@gmail.com writes:
On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane t...@sss.pgh.pa.us wrote:
The point would be to reduce the risk that you're changing the language
definition in a surprising way. Extra args would imply that you're
trying to install a non-default
Pavel Stehule wrote:
2009/11/24 Allan Morris Caras amsca...@yahoo.com:
Hi,
I tried to test it but it says couldn't find class 'pg_attribute'
It is strange - but this software isn't maintained long time, and it's
not actual.
so it is a bad
Pavel
When I tried looking into the table that
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Tom Lane t...@sss.pgh.pa.us wrote:
Yes, I'd expect the user to custom-code it, because it's not clear
exactly which properties the script would be depending on and which
ones it's okay to allow to vary. To take just one example, is it
okay
On Tue, Nov 24, 2009 at 2:07 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
If it did so, that would be outside the apparent meaning of the
command, which is to do nothing if an object of that name exists.
That's why we've gone with CREATE OR REPLACE
Lorenzo Allegrucci escribió:
Matthew Wakeling wrote:
On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote:
Anyway, how can I get rid those idle in transaction processes?
Can I just kill -15 them or is there a less drastic way to do it?
Are you crazy? Sure, if you want to destroy all of the changes
Hi list,
I'm using Gambas to access a PG DB (only through views and functions)
and I can't find a way to escape my string to fit into a BYTEA field;
does anybody have an idea about this?
JY
--
Don't drop acid -- take it pass/fail.
-- Seen in a Ladies' Room at Harvard
--
Sent
hi !
While i'm searching on google :-P , to find a software to replicate
a postgres database, i love read your suggestion about the
replication, so i can shrink my research, no matter if the replication
software isn't free, by the way the version of postgres is 8.2.
i don't
IMHO the client application is already confused and it's in Prod.
Shouldn't he perhaps terminate/abort the IDLE connections in Prod and
work on correcting the problem so it doesn't occur in Dev/Test??
On 11/24/09, Matthew Wakeling matt...@flymine.org wrote:
On Mon, 23 Nov 2009, Lorenzo
Dear list,
I'd like to ask, whether there is a way to exclude a table from the
regular transaction rollback.
Background:
I want to log all exceptions caused by my plpgsql-functions in a certain
log-table. To do this, instead of raising an exception directly, i call
a function that writes a record
John Oyler wrote:
I can create one or more domains, and use those to create the
composite type from. But each domain can only be constrained in its
own value, I can't constrain element #1's value based on what element
#2's value is.
If I create a domain from a composite, it
On Nov 24, 2009, at 7:25 AM, Kurt wrote:
I'd like to ask, whether there is a way to exclude a table from the
regular transaction rollback.
Nope, there is not.
The only solution I came up with till now, is
to put the log data into the exception's error message, parse the
pgsql-logging-file
Kurt wazke...@gmx.net writes:
I'd like to ask, whether there is a way to exclude a table from the
regular transaction rollback.
No.
I want to log all exceptions caused by my plpgsql-functions in a certain
log-table.
You could use dblink to connect to another session that has its own
How about:
IF date_trunc('month',NEW.effective_date)=date_trunc('month',now()) THEN
.
On Tue, Nov 24, 2009 at 7:22 AM, Michal Szymanski dy...@poczta.onet.pl wrote:
In our DB we create partition table for each month (our naming
convetion is follow , and I would like to create
On Tue, Nov 24, 2009 at 10:13 AM, John Oyler john.m.oy...@gmail.com wrote:
For now you have to put all checks in custom constructor functions.
Scott
I must not be looking in the right place... the only thing I can find that
seems remotely related, is the page on input/output functions for
Bouncing the app will roll back the transactions. If there were any
pending updates/inserts, wouldn't he be able to see them in one of the
system tables...
On 11/24/09, Matthew Wakeling matt...@flymine.org wrote:
On Tue, 24 Nov 2009, Denis Lussier wrote:
IMHO the client application is already
Hi,
We have a problem with a relatively small database at the moment that is
resulting in delays times between insertions and retrievals. An update is
applied to a single entry in a table and almost straight after that the same
record is read.
The problem we are encountering is a delay before we
Today I was contacted by a Microsoft (!) developer Kamil who was working on
issues in Linked Servers to PostgreSQL. He brought the following scenario:
if a column is dropped then ordinal positions of remaining columns are
reported incorrectly.
Here is test scenario:
1) create a table in PGAdmin:
On Nov 24, 2009, at 4:38 PM, Michael Lawson (mshindo) wrote:
The problem we are encountering is a delay before we can read the
updated value. This delay can be up to 15 seconds in some cases.
Is the delay a block (that is, you insert the value, and then the
SELECT that should retrieve it
On Wed, Nov 25, 2009 at 1:03 AM, Konstantin Izmailov pgf...@gmail.com wrote:
My question: can pg_attribute.attnum be used to determine the sequential
ordinal positions of columns in a table? What is a right way to get the
ordinal numbers?
You could use something like:
row_number() over
Greg,
this is brilliant - thank you very much!
Is partition by compatible to PostgreSQL 8.0/8.2? I could not find
compatibility information. It works fine with PG 8.3/8.4 and Greenplum 3.3
thou.
Konstantin
On Tue, Nov 24, 2009 at 6:30 PM, Greg Stark gsst...@mit.edu wrote:
On Wed, Nov 25, 2009
On Tue, Nov 24, 2009 at 5:38 PM, Michael Lawson (mshindo)
mich...@sphinix.com wrote:
Hi,
We have a problem with a relatively small database at the moment that is
resulting in delays times between insertions and retrievals. An update is
applied to a single entry in a table and almost straight
On Wed, Nov 25, 2009 at 2:00 AM, Konstantin Izmailov pgf...@gmail.com wrote:
Greg,
this is brilliant - thank you very much!
Is partition by compatible to PostgreSQL 8.0/8.2? I could not find
compatibility information. It works fine with PG 8.3/8.4 and Greenplum 3.3
thou.
It's 8.4 only.
You
Oops, the server that I thought was 8.3 was recently upgraded to 8.4.
I'm going to generate the ordinals on the client then. The nature of the
query is that it can request columns information for all or several tables
as well. The ordinals generation algorithm can reset counter to 1 each time
the
There's an introduction to PostgreSQL replication at
http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling
and a work in progress to provide more up to date information about each
of them at http://wiki.postgresql.org/wiki/Clustering I'd suggest
starting with.
2009/11/24 Jean-Yves F. Barbier 12u...@gmail.com:
Hi list,
I'm using Gambas to access a PG DB (only through views and functions)
and I can't find a way to escape my string to fit into a BYTEA field;
does anybody have an idea about this?
I can't help you with Gambas, but if you are asking how
I suspect the issue is with the memories.
Is it possible for you to send us the following details.
(1) size of database you are managing on cluster ?
(2) postgresql.conf file
(3) Total RAM/ SHMMAX
(4) query which is taking more time.
--
Thanks
Sam Jas
--- On Wed, 25/11/09, Michael
Brian Modra a écrit :
The PB comes from Gambas: I think I'm gonna throw the towel and back to Python
(too bad, boa is a real piece of shit compared to gambas GUI builder :(
2009/11/24 Jean-Yves F. Barbier 12u...@gmail.com:
Hi list,
I'm using Gambas to access a PG DB (only through views and
On Tue, Nov 24, 2009 at 5:51 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Tue, Nov 24, 2009 at 10:13 AM, John Oyler john.m.oy...@gmail.com wrote:
For now you have to put all checks in custom constructor functions.
Scott
I must not be looking in the right place... the only thing I can
Dear Harald
Harald Fuchs wrote:
At least in prefix 1.0.0 unique indexes seem to be broken. Just drop
the primary key and add a separate index:
CREATE INDEX myrecords_record_ix ON myrecords USING gist (record);
Yup .. it works now.
Thankyou for your enlightment
Sincerely
-bino-
--
Dear all,
I have a table as below:
Table public.t_sfh_history
Column|Type | Modifiers
-+-+---
idno| character(10) | not null
lo_date | character(8)| not
2009/11/24 RD黄永卫 yongwei_hu...@gtmc.com.cn:
Dear all,
When reindex operation do,this error occurred:
Nov 22 10:22:27 SUC11 postgres[14145]: [2-1] ERROR: could not create unique
index
Nov 22 10:22:27 SUC11 postgres[14145]: [2-2] DETAIL: Table contains
duplicated values.
Nov 22
2009/11/24 RD黄永卫 yongwei_hu...@gtmc.com.cn:
发件人: Scott Marlowe [mailto:scott.marl...@gmail.com]
发送时间: 2009年11月25日 14:44
收件人: RD黄永卫
抄送: pgsql-b...@postgresql.org; pgsql-general@postgresql.org
主题: Re: [GENERAL] How duplicate data produce when a UNIQUE index exite ?
2009/11/24 RD黄永卫
Scott Marlowe wrote:
My postgreSQL version is :
PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-56)
You are aware that 8.1.x is up to 8.1.18, right, that's 14 or so
updates you're missing. Could one of them have fixed a bug that
67 matches
Mail list logo