Alvaro,I wonder if we could replace the elephant logo with a female elephant logo.That could work wonders ... among the elephant community at least.Are there many elephants among decision makers?
Asking
On Tue, Sep 19, 2006 at 02:15:03PM -0400, Jonathan Vanasco wrote:
Hi,
I'm hoping someone on this list can save me some unnecessary
benchmarking today
snip
a)one table with everything in it
pro:
simple
possible con:
when i had something
Hello there!
Are there any good and recommendable books about PL/PGSQL programming?
Covering new features of PostgreSQL 8.x is no must but would be nice to
have.
Best regards,
Matthias
---(end of broadcast)---
TIP 1: if posting/reading through
On Wednesday 20 September 2006 09:59 pm, Brian Maguire
[EMAIL PROTECTED] thus communicated:
-- To all involved in this project,
--
-- I justed wanted to let you know how impressed and pleased I have been
with postgres over the past 5 years . The timeliness and quality of the
releases are
Brian Maguire schreef:
To all involved in this project,
I justed wanted to let you know how impressed and pleased I have been with postgres over the past 5 years . The timeliness and quality of the releases are always robust and stable. Every release has a very nice mix of admin,
Hi,
I am utterly confused now. Running the attached script on Debian:
postgresql:
Installiert:7.5.21
Mögliche Pakete:7.5.21
Versions-Tabelle:
*** 7.5.21 0
990 ftp://ftp.gwdg.de testing/main Packages
100 /var/lib/dpkg/status
7.4.7-6sarge3 0
500
On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:
I am utterly confused now. Running the attached script on Debian:
postgresql:
Installiert:7.5.21
Mögliche Pakete:7.5.21
Versions-Tabelle:
*** 7.5.21 0
990 ftp://ftp.gwdg.de testing/main Packages
100
On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:
gives the result below. It seems inconsistent to me with
regard to the FOUND variable. I would expect FOUND to always
be false regardless of whether I use EXECUTE or PERFORM. I
certainly do not expect it to be true for the third
On Thu, Sep 21, 2006 at 01:15:46PM +0200, Karsten Hilbert wrote:
Assuming EXECUTE does not touch FOUND at all the EXECUTE
part behaves consistently (namely default FOUND=FALSE at the
beginning and later whatever it was after the PERFORM).
So, what about the PERFORM ? Why does it set FOUND
On Thu, Sep 21, 2006 at 01:32:02PM +0200, Martijn van Oosterhout wrote:
So, what about the PERFORM ? Why does it set FOUND to true?
I beleive that since PERFORM doesn't return anything, it sets the FOUND
variable to at least indicate whether it did something.
The docs say that it sets
On Thu, Sep 21, 2006 at 01:32:02PM +0200, Martijn van Oosterhout wrote:
I beleive that since PERFORM doesn't return anything, it sets the FOUND
variable to at least indicate whether it did something.
The weird thing is that in the example it sets FOUND to true
even if it did NOT do anything.
gives the result below. It seems inconsistent to me with
regard to the FOUND variable. I would expect FOUND to always
be false regardless of whether I use EXECUTE or PERFORM. I
certainly do not expect it to be true for the third EXECUTE
even assuming that PERFORM may have a bug. What is it
On Thu, Sep 21, 2006 at 02:50:08PM +0200, Marcin Mank wrote:
With:
perform cmd;
raise notice ''found (perform): %'', found;
You effectively do:
select 'select 1 from test where fk_item=1324314' ;
Try:
perform 1 from test where fk_item=1324314
Marcin, you saved my day. I knew I
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the more they think it is what
they need :-)
I think
In response to Brad Nicholson [EMAIL PROTECTED]:
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the
Bill,Suing someone is not the real reason.It's the excuse given to one'sboss.The real reason is the Nobody ever got fired for using IBM
mentality. Nobody ever got fired for using IBM - today it is translated to (Oracle|Microsoft)And it may still be true. But it gives you only half the story: IF
they need :-)
I think that description is false. At a certain point in the
management hierarchy, the only way anyone has the ability to evaluate
something is on the basis of reputation.
I think that description is false. At a certain point in the management
hierarchy, the only way anyone has
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/21/06 09:28, Bill Moran wrote:
In response to Brad Nicholson [EMAIL PROTECTED]:
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto
wrote:
[snip]
Suing someone is not the real
Karsten Hilbert [EMAIL PROTECTED] writes:
The docs do hint at how to do it properly:
PERFORM create_mv(''cs_session_page_requests_mv'', my_query);
but this might be helpful to be pointed out explicitely:
PERFORM create_mv(''cs_session_page_requests_mv'', my_query);
Note that the PERFORM
On Wed, 2006-09-20 at 16:29, Johan wrote:
Hi,
I encountered a strange problem while trying to solve a bug. I use a
postgresql 8.x database and a jdbc driver from
postgresql-8.1dev-400.jdbc3.jar. The following is happening
The table is created like
create table test (
field1 int8 not
Hi,
I got executing the script;
(creates table on master,slave1,slave2 but
does it matter to have connection to only node1 or all nodes in script,
it did the same thing with connection to only node1 and I tried to connection to
all nodes ?
node 1 admin conninfo = 'dbname=development
Hi ...
I have been trying to find a replication to a payment system at the
company I work, and Slony-I is of cause the first thing that game into
my attention. But when reading chapter 23.3 in the PG manual, there is
this comment of PITR used as a replication tool.
I also saw the pgpitrha
In response to Bo Lorentsen [EMAIL PROTECTED]:
Hi ...
I have been trying to find a replication to a payment system at the
company I work, and Slony-I is of cause the first thing that game into
my attention. But when reading chapter 23.3 in the PG manual, there is
this comment of PITR
On Thu, 2006-09-21 at 08:47, Brad Nicholson wrote:
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the more they think it is what
they need :-)
I think that
Cons:
- No reliability. On slow days, WAL logs could take a long time to
rotate, so small but important transactions might not be replicated
for a long time.
That's gone with 8.2, it will be possible to stream the last
modifications, or force a WAL recycle periodically, whatever fits
In response to Csaba Nagy [EMAIL PROTECTED]:
Cons:
- No reliability. On slow days, WAL logs could take a long time to
rotate, so small but important transactions might not be replicated
for a long time.
That's gone with 8.2, it will be possible to stream the last
modifications,
I am seeking wording for a procedure that will initiate a
trigger only after another trigger has completed its function. In this case I
want to drop a table that iscreated and usedby the first
trigger.
Could someone point me to documentation?
Bob Pawley
On Thu, 2006-09-21 at 17:30 +0200, Bo Lorentsen wrote:
Hi ...
I have been trying to find a replication to a payment system at the
company I work, and Slony-I is of cause the first thing that game into
my attention. But when reading chapter 23.3 in the PG manual, there is
this comment of
On Thursday 21 September 2006 12:44 pm, Bob Pawley [EMAIL PROTECTED] thus
communicated:
-- I am seeking wording for a procedure that will initiate a trigger only
after another trigger has completed its function. In this case I want to
drop a table that is created and used by the first trigger.
I know that in PostgreSQL, there is no performance
difference between character and character varying.
Is there any penalty in either performance or disk space for
not specifying a length on char and varchar fields? Is it really just there only
as a basic check constraint for the
Am 2006-09-19 21:26:16, schrieb Naz Gassiep:
The scratch your own itch line can only be pushed so far, if it is
being said by a developer who works on a project that desires to be
taken seriously by professionals in industry. For minor features, yes,
perhaps it could be argued that the
Brandon Aiken wrote:
I know that in
PostgreSQL, there is no performance
difference between character and character varying.
Is there any penalty in
either performance or disk space for
not specifying a length on char and varchar fields? Is it really just
there only
Csaba Nagy wrote:
Cons:
- No reliability. On slow days, WAL logs could take a long time to
rotate, so small but important transactions might not be replicated
for a long time.
That's gone with 8.2, it will be possible to stream the last
Thank you for Mac OSX Universal support at last ! Now the last PowerPc
application is gone Universal on my Mac.
Pgadmin now 4 times faster as Universal on Intel!
Thanks for your great work!
On 9/14/06, Dave Page dpage@vale-housing.co.uk wrote:
I'm pleased to announce the first beta version of
Hi, I have a table with 8M rows and one of the fields is a bit (1024
bits) field. I am trying to dump the bit field for 8M rows to a file:
psql -U cicc3 -A -F -t -o pubchem.fp -c select cid,gfp from
pubchem_compound;
However I get
out of memory for query result
I am surprised since I did an
I have a field that is varchar(15) type and an example of data I'm working with is (PROJ-0001-06)
I can make these two select statements work but not together.
select cast((max(substring(test.test from 6 for 4))) AS INTEGER) + 1 FROM test;select max(substring(test.test from 11 for 2)) FROM
Hi!
I have a fairly large database tables (say an average of 3Million
to 4Million records). Using the pg_dump utility takes forever to
dump the database tables. As an alternative, I have created a program
that gets all the data from the table and then put it into a text file.
I was also
I have a table with over 6 million rows in it that I do a dump on every night. It takes less than 2 minutes to create a file that is around 650 MB.Are you maybe dumping this file in 'insert' mode?--Mike Nolan
On 9/21/06, Charles Ambrose [EMAIL PROTECTED] wrote:
Hi!
I have a fairly large database
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Brad Nicholson)
belched out:
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle
select cast((max(substring(test.test from 6 for 4))) as integer) + 1
FROM test where max(substring(test.test from 11 for 2));
This where clause is just returning a number but not comparing it to
anything. Normally it would be something like WHERE test.test =
max(substring(test.test from 11
Hi!I encounter errors in dumping the database using pg_dump. The database i think is corrupt. It was looking for triggers and stored procedures that are now longer in the database. This is also the reason why I opted to create a program to dump the database.
On 9/22/06, Michael Nolan [EMAIL
On 22/9/2006 2:14, Bob Pawley [EMAIL PROTECTED] wrote:
I am seeking wording for a procedure that will initiate a trigger only after
another trigger has completed its function. In this case I want to drop a
table that is created and used by the first trigger.
Sounds like you should use a
Are you dumping the whole database or just a single table? If it's
the former, try the latter and see if you still get errors.
If pg_dump is not working, maybe some system table is hosed. What
errors are you getting?
If you can get in via psql, log in as a superuser and execute:
COPY
On Sep 13, 2006, at 12:13 PM, Andrus wrote:
I use ODBC driver to access PostgresSQL 8.1 servers from Windows 98
computer
from Microsoft Visual FoxPro 9 application.
In a number of client and servers, it is not possible to send data to
server.
PostgreSQL log file shows shows that garbage
On Sep 14, 2006, at 11:15 AM, Russ Brown wrote:
We recently upgraded our trac backend from sqlite to postgres, and I
decided to have a little fun and write some reports that delve into
trac's subversion cache, and got stuck with a query optimisation
problem.
Table revision contains 2800+ rows
On Sep 13, 2006, at 10:39 AM, Fabi Avilés wrote:
Hi, I had an application in which I used postgres 7.4, and then
only thing refering to date was:
datestyle = 'ISO,European'
everything else was commented. Now I have had to change the OS and
I've installed postgres 8.1.3, but this
On Sep 13, 2006, at 9:05 AM, Michelle Konzack wrote:
Majordomo2 support a nomail option as well ...
I know, since some Mailinglist I am on are migrated to Majordomo2.
Afaik does Mailman not support the nomail Option.
BTW, majordomo may not support 'nomail', but it does allow you to add
On Sep 14, 2006, at 4:40 PM, Poul Møller Hansen wrote:
I have some troubles getting Sun Java Studio Creator Sun Java
Application Server to work with
PostgreSQL.
Trying different syntaxes for the SQL statement (schema or no
schema) in the session bean
I get either the error: No columns in
On Sep 13, 2006, at 9:46 PM, David Link wrote:
I'm looking at replacing an Oracle database that only has a few
tables, but that is accessed by many programs in the company via
oracle jdbc drivers, oracle odbc drivers and python database
interface.
Is there a way to intercept the calls to
On Sep 15, 2006, at 2:01 AM, Najib Abi Fadel wrote:
i was searching for a load balancing solution for postgres, I found
some ready to use software like PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is the best
taking in consideration that i have an
51 matches
Mail list logo