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 b
2009/11/24 RD黄永卫 :
>
> 发件人: 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黄永卫 :
>> Dear all,
>>
>>
>>
>>
2009/11/24 RD黄永卫 :
> 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 10:22:27 SUC11 postgr
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
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-
--
Sent
On Tue, Nov 24, 2009 at 5:51 PM, Merlin Moncure wrote:
> On Tue, Nov 24, 2009 at 10:13 AM, John Oyler 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
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 vie
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 Lawson
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 aski
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. Rep
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
On Wed, Nov 25, 2009 at 2:00 AM, Konstantin Izmailov 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 could al
On Tue, Nov 24, 2009 at 5:38 PM, Michael Lawson (mshindo)
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 after that the
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 wrote:
> On Wed, Nov 25, 2009 at 1:03 AM,
On Wed, Nov 25, 2009 at 1:03 AM, Konstantin Izmailov 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 (partition by T.sch
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 ta
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:
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
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 wrote:
> On Tue, 24 Nov 2009, Denis Lussier wrote:
>> IMHO the client application is already confused and it'
On Tue, Nov 24, 2009 at 10:13 AM, John Oyler 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 custom
> type
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 wrote:
> In our DB we create partition table for each month (our naming
> convetion is follow , and I would like to create trigger that insert
> d
Kurt 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
transaction boundari
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 in
>
> 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
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
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 wrote:
> On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote:
>> Anyway
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 w
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 vi
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
On Tue, Nov 24, 2009 at 2:07 PM, Kevin Grittner
wrote:
> Tom Lane 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 exi
"Kevin Grittner" writes:
> Tom Lane 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 if the object ownership is different
Pavel Stehule wrote:
2009/11/24 Allan Morris Caras :
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,
Scott Marlowe writes:
> On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane 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 definition of the language.
> But if you'
Tom Lane 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
definition" is behav
On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane 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?).
Robert Haas writes:
> On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane 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 any value in that restriction - s
"Kevin Grittner" writes:
> Tom Lane 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?
If it did so, that would be outs
On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane wrote:
> "Kevin Grittner" 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
Tom Lane 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, of course, but it
In article <4b0bbc8e.6010...@indoakses-online.com>,
Bino Oetomo 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 prefix_range NOT N
"Kevin Grittner" 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 create a maintenance burden
Andrew Dunstan 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'
> and tablenam
> 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
2009/11/23 Alexandra Roy :
> 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
files".
> Thank
Lee Hachadoorian 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:
> SET CLIENT_ENCODING
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 'filena
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 fa
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 capab
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
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, 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 passwo
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
fu
2009/11/24 Allan Morris Caras :
> 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 didn't
> rev
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 inde
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 thorough
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
To: Allan Morris Caras
Cc: pgsql-general@postgresql.org
On Tue, 2009-11-24 at 09:46 +, Thom Brown wrote:
> 2009/11/24 Hannu Krosing
> On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
> > Craig Ringer writes:
> > > I do think this comes up often enough that a built-in
> trigger "update
> > > named column wi
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 p
2009/11/24 Allan Morris Caras :
> 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.
look on http://s
Hi,
No, auto vacuum is not enabled.
- Original Message
From: Pavel Stehule
To: Allan Morris Caras
Cc: "pgsql-general@postgresql.org >> PG-General Mailing List"
Sent: Tue, November 24, 2009 6:14:22 PM
Subject: Re: [COMMITTERS] recover deleted records
Hello
Have you enabled autov
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 :
> I have accidentally / stupidly deleted records from a table.
>
> I tried delete from where exist and it deleted the whole tab
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
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 wrote:
From: Tim Uckun
Subject: [GENERAL] g
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 t
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!
2009/11/24 Hannu Krosing
> On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
> > Craig Ringer 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 o
On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote:
> Craig Ringer 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 already, I believe
67 matches
Mail list logo
