Thom Brown schrieb:
initdb creates a database cluster, not a database. [..]
Now i'm feeling like fool - this is so obviously. -.- I will stop
posting stressed to the Usenet.
I'm sorry. Thanks for your replies and time!
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der
Hi Tahir,
Can you please send out output of following command:
ls -l installer_file
also send the command which you are running to run the installer.
Regards,
From: Tahir Tamba tahi...@hotmail.com
Date: Tue, Oct 19, 2010 at 6:15 AM
Subject: [GENERAL] install PostgreSQL 9 .0.1 issue using
Hi there,
I have a database with statistical tables which look like this:
id|year_start |value
3 1960 736.1
3 1961 723.3
4 1960 123.4
Years can cover 40 years for each of the countries (ID) and each
1. Tuning wizard adds autovacuum = trueline even if
autovacuum is turned on:
#autovacuum = on # Enable autovacuum subprocess? 'on'
# NOTE: This parameter is been added by EnterpriseDB's Tuning Wiard on
2010/10/18 11:19:56
autovacuum = true # Enable autovacuum subprocess? 'on'
2.
PGDay.EU is by far the largest PostgreSQL conference in Europe. This year it
will be held at the Millennium Hotel in Stuttgart, Germany. PGDay.EU is
a unique chance for developers to learn and network with fellow professionals
that use and work with PostgreSQL. The event attracts developers,
i was wondering if anybody is providing postgres services comparable
to http://aws.amazon.com/rds/ ?
Aljosa Mohorovic
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Oct 19, 2010 at 08:48:13AM +0200, Torsten Zühlsdorff wrote:
Thom Brown schrieb:
initdb creates a database cluster, not a database. [..]
Now i'm feeling like fool - this is so obviously. -.- I will stop
posting stressed to the Usenet.
Yay, an NNTP user :)
We've all been there.
Ravi Katkar ravi.kat...@infor.com writes:
Is there any feature to drop the view with out cascading the dependents.
No. But why don't you use CREATE OR REPLACE VIEW?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Folks,
Postgree is the most amazing DB, even more it will be the only one that will
remain free (the good ones) as MySQL has been taken. In order to move on
with this project, as an Java Senior Architect, I am recomming to you guys
to have an special Section for Audit tables. As we separate
On Tue, Oct 19, 2010 at 3:12 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Ravi Katkar ravi.kat...@infor.com writes:
Is there any feature to drop the view with out cascading the dependents.
No. But why don't you use CREATE OR REPLACE VIEW?
only caveat is, it won't work if he adds/removes any
That's true . it wont work if we add remove the columns.
I wanted to add column to view and change the data type to existing column
-Original Message-
From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com]
Sent: Tuesday, October 19, 2010 7:50 PM
To: Tom Lane
Cc: Ravi Katkar;
On 10/19/2010 03:07 AM, Stefan Schwarzer wrote:
For one of the countries, I have a value for 2007, but not for 1960.
When using only the inner query, than I see one line: Andorra - 2007
- 539 But when running the whole SQL, the value for year 2007 get's
allocated to the year 1960. The table
Hey Folks-
I've got 2 projects out that I'm finding useful, so I thought I'd share with
the wider postgres community.
The first is PgPartition [0]. This (python) tool eliminates the monotony of
dealing with partitions. It generates SQL to create/index/remove/alter
partitions.
The second is
dp...@pgadmin.org (Dave Page) writes:
On Tue, Oct 12, 2010 at 2:58 AM, Peter C. Lai pe...@simons-rock.edu wrote:
On 2010-10-11 05:57:37PM -0600, David Boreham wrote:
On 10/11/2010 5:46 PM, Carlos Mennens wrote:
Just wondering how you guys feel about NoSQL and I just wanted to
share the
On Tue, Oct 19, 2010 at 8:12 AM, Mauricio Chamati mcham...@gmail.com wrote:
Folks,
Postgree is the most amazing DB, even more it will be the only one that will
remain free (the good ones) as MySQL has been taken.
On a side note, MySQL is GPL licensed and cannot simply be taken. The
On Tue, Oct 19, 2010 at 12:36:44PM -0400, Chris Browne wrote:
dp...@pgadmin.org (Dave Page) writes:
On Tue, Oct 12, 2010 at 2:58 AM, Peter C. Lai pe...@simons-rock.edu wrote:
On 2010-10-11 05:57:37PM -0600, David Boreham wrote:
On 10/11/2010 5:46 PM, Carlos Mennens wrote:
Just
Scott Marlowe wrote:
On a side note, MySQL is GPL licensed and cannot simply be taken. The
commercially licensed version is owned by Oracle / Sun, but the GPL
code is quite free to be hacked and released and use according to the
GPL.
As the MySQL documentation is not GPL licensed, such hacks
From: Dharmendra Goyal dharmendra.go...@enterprisedb.comTo:
tahi...@hotmail.comcc: pgsql-gene...@postgresql.orgsubject: Re: install
PostgreSQL 9 .0.1 issue using linux binary package .binDate: Tue, 19 Oct 2010
14:51:36 +0530Message-id:
Hi Tahir,
Can you please try the following command?
sudo installation_path
NOTE: The 'sh' is removed from this command.
--
Thanks Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Companyhttp://www.enterprisedb.com
mcham...@gmail.com (Mauricio Chamati) writes:
Postgree is the most amazing DB, even more it will be the only one that will
remain free (the good ones) as MySQL has been taken. In order to move on with
this project, as an Java Senior Architect, I am recomming to you guys to have
an special
Hello
There is a table with user reviews about hotels, every row has columns:
time_of_travel_begin and time_of_travel_end. User can select date range
(interval), for example 15 June - 10 July and DB request should return
all reviews for any years (for 15 June - 10 July 2010, 15 June - 10 July
2009
On Tue, Oct 19, 2010 at 1:17 PM, Greg Smith g...@2ndquadrant.com wrote:
Scott Marlowe wrote:
On a side note, MySQL is GPL licensed and cannot simply be taken. The
commercially licensed version is owned by Oracle / Sun, but the GPL
code is quite free to be hacked and released and use
You can always recreate the dependent views in the same process, since you
won't lose any data. If there are also linked tables you could use COPY
before deleting and recreating, it's fairly fast.
But..does the structure of your data really need to change? Just guessing,
but it just sounds a
I've posted a short guide on how to get Movable Type 5, Postgres 9, and Tomcat
7.0 working together.
http://www.greenskagitvalley.com/blog/movable-type-5-with-tomcat-70x-and-postgres-90.html
-M@
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 19/10/2010 10:12 PM, Mauricio Chamati wrote:
I am recomming
to you guys to have an special Section for Audit tables. As we
separate sequence in another seq, we should do the same for Audit
tables. They have their own behavior, are less used, and so on.
As a senior software architect, you
Hi Ashesh,
Thank you for pointing me out the right synthax to install PostgreSQL 9.0.1
binary version on Ubuntu. I try it right away and i'll get back to you to tell
you if everything is ok
Regards
Tahir Tamba
6632, Avenue de Gaspé
Montréal, H2S 2Y2
From: ashesh.va...@enterprisedb.com
Hi
Please count me out of the list of your subscription.
Best Regards
JY Wang
Senior Consultant / SDPS Korea Professional Services
T: +822-2185-1026 | M: +82-10-4308-1562 | F: +822-2185-1050
www.gxs.com
-Original Message-
From: pgsql-announce-ow...@postgresql.org
Have a look at PL/R.
You can embed a command to generate a graphic using R via a user defined SQL
function,
This example from
http://www.varlena.com/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html
HTH
Brent Wood
Craig Ringer wrote:
Now, personally, if we're talking database innovation what I'd like to
see is a built-in way to get query results straight from the database as
graphs of tuples and their relationships. Tabular result sets are poorly
suited to some kinds of workloads, including a few
On 10/20/2010 12:35 PM, Brent Wood wrote:
Have a look at PL/R.
You can embed a command to generate a graphic using R via a user defined
SQL function,
In this case, when I say graph or tree I'm referring to the concept
in the graph theory sense, not the plot sense. object graph not
image
On 20/10/10 13:12, Darren Duncan wrote:
Never mind JSON. You can fix the outer joins problem and other issues
simply by supporting relation-valued attributes, or in other words, row
field values that are rowsets.
You can for trees/forests yes. How would you handle more general graphs
with
31 matches
Mail list logo