Am Donnerstag, den 20.10.2005, 14:56 -0700 schrieb Chris Travers:
Martijn van Oosterhout wrote:
..
OTOH, this idea might be really kinda cool. Maybe a good idea for
client applications Or are there other programs out there that can
save db queries to static (stand-alone) Gnumeric
Am Donnerstag, den 20.10.2005, 15:46 -0700 schrieb Roger Hand:
On Thursday, October 20, 2005 1:01 PM, Martijn van Oosterhout wrote:
...
I would argue against outputting this one specific OpenDoc format,
even though it is the flavor of the month right now.
Actually its near standardized. And
On 2005-10-20 15:46, Roger Hand wrote:
On Thursday, October 20, 2005 1:01 PM, Martijn van Oosterhout wrote:
On Thu, Oct 20, 2005 at 09:28:25AM -0700, Dean Gibson (DB Administrator) wrote:
I just find it surprising that XML is not one of the formats provided,
considering that XML is
i have a stored procedure
insert_table(integer)
which does "insert into table (x) value ($1)";
now in my client i call the stored procedure as
select insert_table("3");
it works fine and inserts 3 into the table
but suppose i give
select insert_table("");
it gives an error ...saying "
On Fri, 21 Oct 2005, surabhi.ahuja wrote:
i have a stored procedure
insert_table(integer)
which does insert into table (x) value ($1);
now in my client i call the stored procedure as
select insert_table(3);
it works fine and inserts 3 into the table
but suppose i give
select
On 20.10.2005 23:02, John G. Eggert wrote:
I've also tried downloading the source with no success either.
We do it all the time, we have at least 4 FreeBSD machines running 8.0.4
here. Never had a problem installing / compiling. I didn't use the ports
system though..
--
Regards,
Hannes
Are there known limits to how many rows can be inserted by one
transaction, or does that just reflect the already documented row,
table and database limits?
On Thursday 20 October 2005 23:48, Tom Lane wrote:
Give us a test case to demonstrate this assertion. It works as expected
AFAICT.
Indeed it does. I forgot to mention that the first function to be called was
language plruby. Maybe that has anything to do with it.
I'll try to come with
Am Donnerstag, 20. Oktober 2005 19:59 schrieb David Fetter:
On Thu, Oct 20, 2005 at 06:04:53PM +0200, Janning Vygen wrote:
By the way: What i really miss is a troubleshooting document in the
docs.
That's a great idea. Please post a doc patch with some of the
troubleshooting tips you
I don't know whether I should be posting to Hacker Win 32 or General,
but I wanted to ask if anyone else has experienced troubles restoring a
DB on windows to 8.1 from 8.0.x when the DB contains GIS tables.
As far as I can see I don't have the postgis dll files or sql script,
but other parts
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be able to roll back the transaction, so
at some point your system will grind to a
On 10/21/05, Richard Huxton dev@archonet.com wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be able to roll back the
On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote:
On 10/21/05, Richard Huxton dev@archonet.com wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one
transaction,
Well, the system will need to be able to roll back the transaction,
Nicolas Barbier wrote:
On 10/21/05, Richard Huxton dev@archonet.com wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be
On Thursday 20 October 2005 23:48, Tom Lane wrote:
Give us a test case to demonstrate this assertion. It works as expected
AFAICT.
Ok, it has to do with C functions:
#include postgres.h
#include fmgr.h
#include sys/time.h
PG_FUNCTION_INFO_V1(plg_cfie);
Datum
plg_cfie(PG_FUNCTION_ARGS)
{
On Fri, Oct 21, 2005 at 11:41:15AM +0200, Janning Vygen wrote:
I really would like to start it! Two reasons for me not to do it: I don't
speak english very well, technical writing is even worse as my native
language is german. Second: i have experience with postgresql for 5 years,
but i
In article [EMAIL PROTECTED],
Roger Hand [EMAIL PROTECTED] wrote:
% If pg outputs a simple xml format, it can easily be transformed via xslt
% into OpenDoc table format, alternate html formats, or the alternate xml
% format of your choice.
Well, pg does output a simple xml format, which can be
Hi.
I was installing postgresql 8.0 and let it generate a password for me,
then i changed my mind and went back to change the password, but then i
was stuck. How do i find the password it generated for me? How do i
change it? How can i start over and install postgresql somehow? Thanks!
/Mike
jeff sacksteder [EMAIL PROTECTED] writes:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Offhand I think the only limit that might concern you is the CID limit
of 2^32 SQL commands per
What
platform? Solaris, FreeBSD, Linux, Windows
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Michael
UvhagenSent: Friday, October 21, 2005 6:10 AMTo:
pgsql-general@postgresql.orgSubject: [GENERAL]
passwordHi.I was installing
Hi,
We have a postgresql database which we would like to clusterize. By
clusterize, i mean be able to use multiple servers to read and write in
the database. Simple replication is not enough. (However if you have any
suggestion for replication which are fit for production environements, i
would
Hi.
I was installing postgresql 8.0 and let it generate a
password for me, then i changed my mind and went back to
change the password, but then i was stuck. How do i find the
password it generated for me? How do i change it? How can i
start over and install postgresql somehow? Thanks!
Patrick TJ McPhee schrieb:
In article [EMAIL PROTECTED],
Roger Hand [EMAIL PROTECTED] wrote:
% If pg outputs a simple xml format, it can easily be transformed via xslt
% into OpenDoc table format, alternate html formats, or the alternate xml
% format of your choice.
Well, pg does output a
[EMAIL PROTECTED] writes:
On Thursday 20 October 2005 23:48, Tom Lane wrote:
Give us a test case to demonstrate this assertion. It works as expected
AFAICT.
Ok, it has to do with C functions:
create or replace function plg_cfie() returns void as '/tmp/plg_cfie.so'
language c immutable;
It appears that casting to a char() causes spaces to be stripped (ignored) from the string:
mls=# select length('123 '::char(8));
length
3
(1 row)
mls=# select length('123 '::char(8)::varchar(8));
length
3
(1 row)
but:
mls=# select length('123 '::varchar(8));
length
On Fri, 2005-10-21 at 03:14, Hannes Dorbath wrote:
On 20.10.2005 23:02, John G. Eggert wrote:
I've also tried downloading the source with no success either.
We do it all the time, we have at least 4 FreeBSD machines running 8.0.4
here. Never had a problem installing / compiling. I didn't
i have a fiels - varchar(100)
to this fiels i am trying to insert
"abc\def\xyz'
but it is not inserting the whole thing
...
how can i ensure that the whole string including
the backslashes get inserted into the table
thanks
regards
surabhi
On Fri, 2005-10-21 at 11:01, Franck Coppola wrote:
Hi,
We have a postgresql database which we would like to clusterize. By
clusterize, i mean be able to use multiple servers to read and write in
the database. Simple replication is not enough. (However if you have any
suggestion for
double the backslashes. They are an escape
character.
--Larry
Rosenman
http://www.lerctr.org/~lerPhone: +1
972-414-9812
E-Mail: ler@lerctr.orgUS Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611
US
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
surabhi.ahujaSent:
On Fri, Oct 21, 2005 at 08:29:44PM +0530, surabhi.ahuja wrote:
i have a fiels - varchar(100)
to this fiels i am trying to insert
abc\def\xyz'
but it is not inserting the whole thing ...
See String Constants in the documentation and take particular
note of what it says regarding
First, you should not quote an integer value going into an integer column -
bad habit to get into.
Second, empty string is not an integer.
Susan
Hello,
I was reading release notes for 8.1 and there is
something about changes concerning replacing ::text with ::regclass in default clauses. There is a query in Release
notes,that should be executed to update dump from previos
versions.
But, even without it, I see that all serial
fileds
e any tools to do this ? (I would prefer opensource, but if
there is a well proven and affordable commercial app to do it, why
not).
What is your application written in?
Sincerly,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting,
Alex Turner [EMAIL PROTECTED] writes:
It appears that casting to a char() causes spaces to be stripped (ignored)
from the string:
mls=# select length('123 '::char(8));
length
3
(1 row)
I'm not sure about anyone else, but I would personaly consider that a bug?
No, it's a feature, as
How to write a WHERE clause which selects e-mail addresses which
are surely wrong ?
... WHERE email !~ '...insert previously mentioned regex here...';
Steve,
thank you.
I tried
SELECT email FROM customer
WHERE email !~
'/[EMAIL PROTECTED]@(?:[EMAIL
On Fri, Oct 21, 2005 at 04:01:12PM +, Franck Coppola wrote:
would be interested too : i don't feel very confident with slony).
Why don't you? (The Slony developers would like to know, I think.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my
I need suggestion to backup my postgresql server. The database is growing 1/2 Gb a day and I am looking for a solution that would push the data off to the backup server periodically with minimal amount of load to the server (I am trying to avoid table locking). I am thinking to use rsync to sync
Hrm, I thought there was something equivalent to an is_number()
function, which would have made this easy:
CASE WHEN is_number(x) THEN x ELSE NULL END;
But I can't seem to find one. Is there a historic reason such functions
don't exist?
On Mon, Oct 17, 2005 at 01:05:17PM -0700, TJ O'Donnell
Apu Islam [EMAIL PROTECTED] writes:
I need suggestion to backup my postgresql server. The database is growing
1/2 Gb a day and I am looking for a solution that would push the data off
to the backup server periodically with minimal amount of load to the
server (I am trying to avoid table
Am Freitag, den 21.10.2005, 12:22 -0500 schrieb Apu Islam:
I need suggestion to backup my postgresql server. The database is
growing 1/2 Gb a day and I am looking for a solution that would push
the data off to the backup server periodically with minimal amount of
load to the server (I am
* Apu Islam ([EMAIL PROTECTED]) wrote:
I need suggestion to backup my postgresql server. The database is growing
1/2 Gb a day and I am looking for a solution that would push the data off to
the backup server periodically with minimal amount of load to the server (I
am trying to avoid table
On 10/21/05, Zlatko Matić [EMAIL PROTECTED] wrote:
I was reading release notes for 8.1 and there is something about changes
concerning replacing ::text with ::regclass in default clauses. There is a
query in Release notes, that should be executed to update dump from previos
versions.
But,
On Fri, 2005-10-21 at 12:22, Apu Islam wrote:
I need suggestion to backup my postgresql server. The database is
growing 1/2 Gb a day and I am looking for a solution that would push
the data off to the backup server periodically with minimal amount of
load to the server (I am trying to avoid
On Fri, Oct 21, 2005 at 08:15:23PM +0300, Andrus wrote:
How to write a WHERE clause which selects e-mail addresses which
are surely wrong ?
... WHERE email !~ '...insert previously mentioned regex here...';
Steve,
thank you.
I tried
[snip]
SELECT email FROM customer
WHERE
On Fri, Oct 21, 2005 at 08:15:23PM +0300, Andrus wrote:
I tried
SELECT email FROM customer
WHERE email !~
'/[EMAIL PROTECTED]@(?:[EMAIL
I don't know whether I should be posting to Hacker Win 32 or
General, but I wanted to ask if anyone else has experienced
troubles restoring a DB on windows to 8.1 from 8.0.x when the
DB contains GIS tables.
That really should go on the pginstaller list. Copying there.
As far as I can
Hi all,
I'm looking into PostgreSQL. Coming from a MySQL
background, I have made heavy use of its very useful
GROUP_CONCAT function. You can read about the function
here:
http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
Is there a PostgreSQL alternative to GROUP_CONCAT?
Thanks,
On Fri, 2005-10-21 at 13:38, Scott Marlowe wrote:
On Fri, 2005-10-21 at 12:22, Apu Islam wrote:
I need suggestion to backup my postgresql server. The database is
growing 1/2 Gb a day and I am looking for a solution that would push
the data off to the backup server periodically with minimal
Seems like WAL backup is the way to go with PITR. database will not have to be exhaused over and over with pg_dump and if I do rsync hourly, I could minimize the network traffic significantly as well. I already like the term 'hot standby' from the doc already.
Thanks for your help.
-apu
On
Hi all,
I'm looking into PostgreSQL. Coming from a MySQL background,
I have made heavy use of its very useful GROUP_CONCAT
function. You can read about the function
here:
http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
Is there a PostgreSQL alternative to
Tom Lane wrote:
Alex Turner [EMAIL PROTECTED] writes:
It appears that casting to a char() causes spaces to be stripped
(ignored) from the string:
mls=# select length('123 '::char(8));
length
3
(1 row)
I'm not sure about anyone else, but I would personaly consider that a
bug?
On Fri, Oct 21, 2005 at 11:49:54AM -0700, Steve Atkins wrote:
SELECT email FROM customer
WHERE email !~*
'[EMAIL PROTECTED]@(?:[EMAIL
[EMAIL PROTECTED] writes:
I'm looking into PostgreSQL. Coming from a MySQL
background, I have made heavy use of its very useful
GROUP_CONCAT function. You can read about the function
here:
http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
Is there a PostgreSQL alternative to
Guy Rouillier [EMAIL PROTECTED] writes:
Tom Lane wrote:
No, it's a feature, as per extensive discussion some time ago when we
made it do that. The general rule is that trailing spaces in a
char(n) are semantically insignificant.
How did you reach the opposite conclusion for varchar? If
On Fri, Oct 21, 2005 at 11:58:07AM -0700, [EMAIL PROTECTED] wrote:
Hi all,
I'm looking into PostgreSQL. Coming from a MySQL background, I have
made heavy use of its very useful GROUP_CONCAT function. You can
read about the function here:
MaXX [EMAIL PROTECTED] writes:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one
transaction, or does that just reflect the already documented row, table
and database limits?
An error string in the source code stands:
cannot have more than 2^32-1
Chris Browne [EMAIL PROTECTED] writes:
MaXX [EMAIL PROTECTED] writes:
An error string in the source code stands:
cannot have more than 2^32-1 commands in a transaction
That means you couldn't do more than 2^32-1 INSERT statements.
Right.
But that wouldn't (in principle) prevent having each
On Mon, Oct 17, 2005 at 04:42:15PM -0700, Jared Evans wrote:
Is there a way for me to quickly calculate the maximum size of a row
for a table? I wanted to know if there was an automatic way to do it
before I do it manually.
Well, if the table is well-vacuumed, SELECT relpages*8192/reltuples
Another thing I've always wondered about ;), as I use
numerics far more than floats. From the docs:
However, arithmetic on numeric values is very slow
compared to the integer types, or to the
floating-point types
How much slower are numerics? And why (I guess it has
to do with potentially
CSN [EMAIL PROTECTED] writes:
Another thing I've always wondered about ;), as I use
numerics far more than floats. From the docs:
However, arithmetic on numeric values is very slow
compared to the integer types, or to the
floating-point types
How much slower are numerics? And why (I guess
I'm running the latest stable version of PostgreSQL on a Debian Linux box running Gnome 2.0. I've just started setting up my first database with PostgreSQL and I've got a few newbie questions:
[1] Is there a way to determine where all the parts of my defualt PostgreSQL installation are located?
On Wed, Oct 19, 2005 at 08:23:35AM +0900, Michael Glaesemann wrote:
On Oct 19, 2005, at 2:29 , vittorio wrote:
Using psql how can I ask postgresql to show the actual number of
rows of a
table?
For table foo,
select count(*) from foo;
An up-to-date count of the number of actual
Title: RE: [GENERAL] How much slower are numerics?
-Original Message-
From: [EMAIL PROTECTED] on behalf of CSN
Sent: Fri 10/21/2005 5:30 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How much slower are numerics?
Another thing I've always wondered about ;), as I use
Redefined Horizons [EMAIL PROTECTED] writes:
I'm running the latest stable version of PostgreSQL on a Debian Linux box
running Gnome 2.0. I've just started setting up my first database with
PostgreSQL and I've got a few newbie questions:
I'm going to assume you installed the Debian packages
Changed your email format from HTML to plain text, which is preferred on
most mailing lists.
Redefined Horizons wrote:
I'm running the latest stable version of PostgreSQL on a Debian Linux
box running Gnome 2.0. I've just started setting up my first database
with PostgreSQL and I've got a few
unsubscribe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
The problem described below in 7.4.x, does not occur in 8.0.4, even with
near-simultaneous VACUUMs and updating. Previously, if one VACUUM was
run within a minute or two of the other, the problem below occurred.
-- Dean
On 2005-09-19 09:26, Dean Gibson (DB Administrator) wrote:
Simultaneous
Magnus,
I have replied to general as well as the only mailing list I could find
on PG Foundry for pginstaller was the Devel list.
I actually do have all those files - the trouble is that the name
changes make pg_restore fail on a dump from a 8.0.3 Database with
spatial (postgis) tables.
List,
I've got a problem where I need to make a table that is going to grow by an average of 230,000 records per day. There
are only 20 columns in the table, mostly char and integer. It's FK'd in two places to another table for import/export
transaction id's and I have a serial primary key
On Fri, Oct 21, 2005 at 05:25:22PM -0700, Edoceo Lists wrote:
[summary of situation]
Some queries take more than five minutes to complete and I'm sad
about that. How can I make this faster?
You might get more help on pgsql-performance, which is specifically
for discussions of performance
On 22 Oct 2005, at 01:25, Edoceo Lists wrote:
List,
I've got a problem where I need to make a table that is going to
grow by an average of 230,000 records per day. There are only 20
columns in the table, mostly char and integer. It's FK'd in two
places to another table for
Jim C. Nasby [EMAIL PROTECTED] writes:
The only way I know of to get row length info for certain is vacuum full
verbose:
See also contrib/pgstattuple.
regards, tom lane
---(end of broadcast)---
TIP 1: if posting/reading
Scott Marlowe [EMAIL PROTECTED] writes:
How much slower are numerics? And why (I guess it has
to do with potentially different sizes)?
I think that there was a time when numerics were MUCH slower than =
floats, but looking at a very simple benchmark I just threw together, =
I'd say they're
73 matches
Mail list logo