On Mon, Oct 5, 2009 at 11:00 PM, Alvaro Herrera
wrote:
Stuart Bishop wrote:
On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys
wrote:
> A similar issue was discussed just recently here:
> http://archives.postgresql.org/pgsql-general/2009-09/msg01219.php
>
> That issue involved cursors though
On Tue, Oct 6, 2009 at 12:20 AM, Nurzhan Kirbassov wrote:
> Good day.
>
> I may be misunderstanding the NUMERIC type description in the manual,
> so can anyone please help me with this? Description says:
>
> "The scale of a numeric is the count of decimal digits in the
> fractional part, to the ri
On Oct 5, 2009, at 11:20 PM, Nurzhan Kirbassov wrote:
So, does the precision part of the numeric type really means number of
digits to the left of the decimal point, or what ?
NUMERIC is behaving as documented. The way to think of it is when you
are inserting:
INSERT INTO test.te
Good day.
I may be misunderstanding the NUMERIC type description in the manual,
so can anyone please help me with this? Description says:
"The scale of a numeric is the count of decimal digits in the
fractional part, to the right of the decimal point. The precision of a
numeric is the total count
How I cant optain de SQL (if is posible) of any STATEMENT in an AFTER Trigger
Function in C?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
does anyone know what this is?
Trying to start postgres version:
PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian
4.3.2-1.1) 4.3.2
2009-10-06 15:17:21 EST 3757 FATAL: XX000: could not open directory
"pg_tblspc": Unknown error 530
2009-10-06 15:17:21 EST 3757 LOCATION
On Mon, Oct 5, 2009 at 7:34 AM, Martijn van Oosterhout
wrote:
> That said, why are you doint this anyway. A better solution may be to
> install a trusted language (like plperlu or plpython) and do the system
> call from there.
>
If you just want system(3) you might as well use plsh...
--
greg
On Monday 05 October 2009 10:36:04 am Chun-fan Ivan Liao wrote:
> Thank you, Oosterhout and Lane.
>
> The code is not written by me. The previous DB admin is not reachable.
> I was just the present-stage DB (newbie) admin, and I never touched
> PostgreSQL before :(
>
> On Mon, Oct 5, 2009 at 10
I wrote:
> I guess we're going to have to rewrite that code to not store the cooked
> defaults in string form. If they were node trees then equal() would do
> the right thing.
The attached patch should fix this.
regards, tom lane
Index: src/backend/commands/tablecmds.c
=
Guy Rouillier wrote:
The IBM implementation provided language libraries (usually COBOL)
that also supported packed decimal, so precision was maintained
throughout the entire application stack.
IBM 360/370/390/etcetc/Zsystem has BCD op codes in the instruction set
architecture. microcoded
Bruce Momjian wrote:
Guy Rouillier wrote:
Christophe Pettus wrote:
On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote:
There is no reason why PG could not support packed decimal.
Is that not NUMERIC?
No, that is not NUMERIC. All numeric types are stored as binary
representations. Packed decim
Tom Lane-2 wrote:
>
> Josh Trutwin writes:
>> Hi - I'm trying to build 8.3.6 on a box recently upgraded from Sarge
>> to Lenny and I get the following error during compile:
>
>> make[4]: Entering directory
>> `/backup/source/db/postgresql-8.3.6/src/backend/utils/adt' gcc -O2
>> -Wall -Wmissin
Ignore that. I now see that I must edit the dump file to change the
directory for the tablespace before running the restore.
Bill
Bill Todd wrote:
I am new PostgreSQL and am about to attempt to upgrade from 8.3 to
8.4.1. I believe I understand the procedure except for my tablespace.
My datab
Hi,
I don't yet properly understand the conforming strings implementation
that came in 8.3 The manual (to me at least) has been a little
imprecise in describing the implications for correctly inserting data
with this enabled without getting back a plethora of warnings, or
having the inser
On 02/10/2009, at 23:47 , Tom Lane wrote:
Preston de Guise writes:
Using Perl to program interfaces to PostgreSQL, and had previously
misunderstood how md5 password authentication worked, so I'm now re-
doing it, but struggling to find out how DBD::Pg might be used to
actually authenticate by
On Oct 5, 2009, at 8:04 AM, Joshua Berry wrote:
Our shop uses postgres for a dozen installations. The applications
have some realtime performance requirements, and are just good enough
to function properly. The problem is that the clients (owners of the
production servers) are using the same se
On Mon, Oct 5, 2009 at 9:04 AM, Joshua Berry wrote:
> Our shop uses postgres for a dozen installations. The applications
> have some realtime performance requirements, and are just good enough
> to function properly. The problem is that the clients (owners of the
> production servers) are using th
I'm planning to work with Andrew Dunstan on some enhancements to PL/Perl
for PostgreSQL 8.5.
I've written up some initial proposals here:
http://blog.timbunce.org/2009/10/05/wishlist-of-plperl-enhancements-for-postgresql-8-5/
I'd welcome any feedback on those, and any other suggestions you ma
I am new PostgreSQL and am about to attempt to upgrade from 8.3 to
8.4.1. I believe I understand the procedure except for my tablespace. My
database is in a tablespace named app. When I restore the database dump
under 8.4.1 I assume that the tablespace will not be created
automatically. Am I
On Mon, Oct 05, 2009 at 01:07:16PM -0700, Christophe Pettus wrote:
> A quick check of the source code (src/backend/utils/adt/numeric.c)
> shows it's base 1, each "digit" represented as an int16.
I was going to note that in my post but thought it was needless detail;
ah well, maybe next time
On Mon, 5 Oct 2009, Gerhard Wiesinger wrote:
I think the problem is, that it is done on checkpoint time (whether
spread or not). I should have been already be done by bgwriter.
This is pretty simple: if you write things before checkpoint time, you'll
end up re-writing a percentage of the blo
A quick check of the source code (src/backend/utils/adt/numeric.c)
shows it's base 1, each "digit" represented as an int16. It's not
strictly speaking BCD, but there's no computational difference.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsq
Guy Rouillier wrote:
> Christophe Pettus wrote:
> >
> > On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote:
> >> There is no reason why PG could not support packed decimal.
> >
> > Is that not NUMERIC?
>
> No, that is not NUMERIC. All numeric types are stored as binary
> representations. Packed
Christophe Pettus wrote:
On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote:
There is no reason why PG could not support packed decimal.
Is that not NUMERIC?
No, that is not NUMERIC. All numeric types are stored as binary
representations. Packed decimal is not. Perhaps an example would
cl
On Mon, 5 Oct 2009, Greg Smith wrote:
On Sun, 4 Oct 2009, Gerhard Wiesinger wrote:
On Fri, 2 Oct 2009, Scott Marlowe wrote:
I found that lowering checkpoint completion target was what helped.
Does that seem counter-intuitive to you?
I set it to 0.0 now.
If you set that to 0.0, the whol
233242661...@mtn.com.gh wrote:
What are the general features and components of PostgreSQL
http://www.postgresql.org/docs/current/static/index.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
NOTE: This e-mail message is subject to the MTN Ghana email disclaimer see
http://www.mtn.com.gh/disclaimer/
What are the general features and components of PostgreSQL
--
Sent via pg
Thank you, Oosterhout and Lane.
The code is not written by me. The previous DB admin is not reachable.
I was just the present-stage DB (newbie) admin, and I never touched
PostgreSQL before :(
On Mon, Oct 5, 2009 at 10:34 PM, Martijn van Oosterhout
wrote:
>
> On Mon, Oct 05, 2009 at 06:07:44P
On Sun, 4 Oct 2009, Gerhard Wiesinger wrote:
On Fri, 2 Oct 2009, Scott Marlowe wrote:
I found that lowering checkpoint completion target was what helped.
Does that seem counter-intuitive to you?
I set it to 0.0 now.
If you set that to 0.0, the whole checkpoing spreading logic doesn't app
Tim Uckun wrote:
> Unfortunately there is nothing anywhere telling me what the problem
> is. The log file is empty, there is nothing in the /var/log/messages
> or /var/log/syslog either. The only output I get is this.
>
> * Starting PostgreSQL 8.3 database server
> * The PostgreSQL server faile
On Mon, 2009-10-05 at 17:16 +0100, Raymond O'Donnell wrote:
> Hello all, and apologies for the cross-posting.
>
> I'm looking to see if there is any interest in starting an Irish
> PostgreSQL user group.
>
> A couple of people have been in touch privately from time to time,
> expressing interest
Hello all, and apologies for the cross-posting.
I'm looking to see if there is any interest in starting an Irish
PostgreSQL user group.
A couple of people have been in touch privately from time to time,
expressing interest in such a group, so I'm like to see if there are
enough people interested
Stuart Bishop wrote:
> On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys
> wrote:
> > A similar issue was discussed just recently here:
> > http://archives.postgresql.org/pgsql-general/2009-09/msg01219.php
> >
> > That issue involved cursors though (and a serializable isolation level, but
> > you ha
Our shop uses postgres for a dozen installations. The applications
have some realtime performance requirements, and are just good enough
to function properly. The problem is that the clients (owners of the
production servers) are using the same server/database for
customizations that are causing pr
Chun-fan Ivan Liao writes:
> STATEMENT: CREATE FUNCTION "system"(cstring) RETURNS integer
> AS '/lib/libc.so.7', 'system'
> LANGUAGE c STRICT;
This hack doesn't work any more --- not that it was ever considered
supported or recommended. If you really need such a thing, I
On Mon, Oct 5, 2009 at 4:22 PM, Alban Hertroys
wrote:
> On 5 Oct 2009, at 8:58, Stuart Bishop wrote:
>
>> I'm running our products test suite against PostgreSQL 8.4.1. The test
>> suite runs fine against 8.3.7.
>>
>> With 8.4.1, some of our tests are failing with the exception
>> 'attempted to loc
On Mon, Oct 05, 2009 at 06:07:44PM +0800, Chun-fan Ivan Liao wrote:
> I used pg_dump to dump the old database out and psql to store the database
> into the new server, but the following two errors occurred:
>
> ERROR: incompatible library "/lib/libc.so.6": missing magic block
> HINT: Extension l
did you install (i should say register) postgres and pg_ctl binaries as
postgres user
are you executing postgres and pg_ctl binaries as postgres user
?
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese N
I want to transport the database server to a new machine.
The OS and the PostgreSQL version of the old machine: FreeBSD 6.1-RELEASE &
psql 8.1.3
And that of the new machine: FreeBSD 7.2-RELEASE & psql 8.4.0
(Using "uname -a" "psql -U pgsql" to check the version)
I used pg_dump to dump the old d
Thanks, you were right - actually the problem was somewhere else. During the
build I had the sql files copied over to another location, feeding them to
ant's -- and it was there actually where the encodings got
mixed up.
(Needless to say, I was looking at the original file and thought it was t
On Mon, 2009-10-05 at 17:39 +1300, Tim Uckun wrote:
> Unfortunately there is nothing anywhere telling me what the problem
> is. The log file is empty, there is nothing in the /var/log/messages
> or /var/log/syslog either. The only output I get is this.
>
> * Starting PostgreSQL 8.3 database serve
Hello,
We're migrating to Greenplum, and in our currently portfolio we base everything
on views.
In our prior system, we could alter tables and then refresh the views, but in
PG/greenplum most alters are blocked because of the dependent objects.
I understand that I can walk the pg_depends table
"Markus Wollny" writes:
> pgsql-general-ow...@postgresql.org wrote:
>> Unfortunately there is nothing anywhere telling me what the
>> problem is. The log file is empty, there is nothing in the
>> /var/log/messages or /var/log/syslog either. The only output
>> I get is this.
>>
>> * Starting Postg
Could it be that a connection may be invoking a newly recreated
function rewritten in C that it had previously called before it's
recreation?
Allan.
On Mon, Oct 5, 2009 at 3:06 PM, Miklosi Attila wrote:
>
> What does the message below mean?
>
> server closed the connection unexpectedly
> This pr
On Mon, Oct 05, 2009 at 03:06:41PM +0200, Miklosi Attila wrote:
> What does the message below mean?
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
It means the server disconnected from the client; as i
What does the message below mean?
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
This message appears sometimes after i send a 'BEGIN' to the server and
the processor load of the application goes up to 99%. T
On Mon, Oct 05, 2009 at 12:03:38AM +, Tim Landscheidt wrote:
> Sam Mason wrote:
> >Tim Landscheidt wrote:
> >> "generate_series(A, B, C)" can also
> >> be written as "A + generate_series(0, (C - B) / C) * C"
> >
> > If you can figure out the limit then it seems easy,
> > though I'm not sure ho
2009/10/5 Markus Wollny
> Hi!
>
> pgsql-general-ow...@postgresql.org wrote:
> > Unfortunately there is nothing anywhere telling me what the
> > problem is. The log file is empty, there is nothing in the
> > /var/log/messages or /var/log/syslog either. The only output
> > I get is this.
> >
> > *
On 5 Oct 2009, at 8:58, Stuart Bishop wrote:
I'm running our products test suite against PostgreSQL 8.4.1. The test
suite runs fine against 8.3.7.
With 8.4.1, some of our tests are failing with the exception
'attempted to lock invisible tuple'. The failures are repeatable -
they crash every tim
Hi!
pgsql-general-ow...@postgresql.org wrote:
> Unfortunately there is nothing anywhere telling me what the
> problem is. The log file is empty, there is nothing in the
> /var/log/messages or /var/log/syslog either. The only output
> I get is this.
>
> * Starting PostgreSQL 8.3 database server
>
50 matches
Mail list logo
