Dear Tom,
Thanks for your hints; it is indeed funny (as mentioned by Guillaume) how
indexes and constraints are being mixed up -- mentioned either in the
Indexes or in Constraints department. Pgsql and PgAdmin make different
choices here. And well, given their implementation these choices can
I can tell the changes I have done in the code if you want.
On Tue, Dec 28, 2010 at 12:30 PM, aaliya zarrin aaliya.zar...@gmail.comwrote:
Sorry, My application is using the postgres DB but the another application
is giving the command to run in standby or active mode.
I can't use gdb I
Hello!
I would like to get more flexible tool for database management that EMS of
pgadmin. So now I'm trying to use PD 15 with Postgres 8.4.1. It's very exciting
:)
So what can I say?
It seems to be there are no problems with tables, sequences, FK... But there
are some difficulties with:
1.
SOLVED: I should use the CREATE UNIQUE INDEX ... ON ... command, on an
existing table. This cannot be done inline within the CREATE TABLE command.
Thanks all, for your help.
Rob
2010/12/28 InterRob rob.mar...@gmail.com
Dear Tom,
Thanks for your hints; it is indeed funny (as mentioned by
Hi,
I am unable to run the postgres using gdb.
I am getting error as no debugging symbols found.
How to proceed?
On Tue, Dec 28, 2010 at 11:32 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin aaliya.zar...@gmail.com
wrote:
I am new to postgres. I
28 декабря 2010 г. 13:02 пользователь el dorado do_ra...@mail.ru написал:
Hello!
I would like to get more flexible tool for database management that EMS of
pgadmin. So now I'm trying to use PD 15 with Postgres 8.4.1. It's very
exciting :)
So what can I say?
It seems to be there are no
Is it possible (and how) to implement a data path on another partition (linux)
for an existing system? And then if I do not gain anything, merging it to the
production /data path?
Scenario of what I want to achieve (/mnt/data is already running)
/mnt/data resides on an NFS share
On 28/12/2010 14:56, Ozz Nixon wrote:
Is it possible (and how) to implement a data path on another
partition (linux) for an existing system? And then if I do not gain
anything, merging it to the production /data path?
I think tablespaces will do what you want:
Ozz Nixon ozzni...@gmail.com wrote:
Is it possible (and how) to implement a data path on another partition
(linux) for an existing system? And then if I do not gain anything,
merging it to the production /data path?
I think, you should read our docu about tablespaces:
Hello,
I'm working on a small app, which receives a list of 20 players in XML format.
The initial version works ok and I use there just 1 SQL statement and thus
it is easy for me to fetch results row by row and print XML at the same time:
select u.id,
On Tue, Dec 28, 2010 at 7:56 AM, Ozz Nixon ozzni...@gmail.com wrote:
Is it possible (and how) to implement a data path on another partition
(linux) for an existing system? And then if I do not gain anything, merging
it to the production /data path?
Scenario of what I want to achieve
New versions of Devart ADO.NET Data Providers with improved capabilities of
ORM solution and advanced Model-First and Database-First support in ORM
model designer.
Devart has recently announced the release of the new versions of dotConnect
Data Providers, the database connectivity solutions
I think this is not the right forum for such announcements.
Consider http://archives.postgresql.org/pgsql-announce/ . I think Postgres
weekly news will pick it up automatically from there.
Regards,
On Tue, Dec 28, 2010 at 8:45 AM, Devart sub...@devart.com wrote:
New versions of Devart
I'm trying:
create or replace function pref_money_stats(_id varchar)
returns varchar as $BODY$
begin
declare stats varchar;
for row in select yw, money from pref_money where id=_id order
by yw desc limit 20 loop
stats := stats || ; || row.id || :
Alex,
create or replace function pref_money_stats(_id varchar)
returns varchar as $BODY$
begin
declare stats varchar;
for row in select yw, money from pref_money where id=_id order
by yw desc limit 20 loop
stats := stats || ; || row.id || : ||
2010/12/28 Alexander Farber alexander.far...@gmail.com
Hello,
I'm working on a small app, which receives a list of 20 players in XML
format.
The initial version works ok and I use there just 1 SQL statement and thus
it is easy for me to fetch results row by row and print XML at the same
2010/12/28 Dmitriy Igrishin dmit...@gmail.com
2010/12/28 Alexander Farber alexander.far...@gmail.com
Hello,
I'm working on a small app, which receives a list of 20 players in XML
format.
The initial version works ok and I use there just 1 SQL statement and thus
it is easy for me to
-Original Message-
From: Alexander Farber [mailto:alexander.far...@gmail.com]
Sent: Tuesday, December 28, 2010 10:33 AM
To: pgsql-general@postgresql.org
Subject: Concatenating several rows with a semicolon
Hello,
I'm working on a small app, which receives a list of 20
In response to Igor Neyman iney...@perceptron.com:
-Original Message-
From: Alexander Farber [mailto:alexander.far...@gmail.com]
Sent: Tuesday, December 28, 2010 10:33 AM
To: pgsql-general@postgresql.org
Subject: Concatenating several rows with a semicolon
Hello,
Hello Bill and others,
I don't agree about yw being a bad thing
since I have weekly raings in my app,
but your XML suggestion -
On Tue, Dec 28, 2010 at 9:29 PM, Bill Moran wmo...@potentialtech.com wrote:
If there are multiple entries for pref_money, then each one should be
a container inside
2010/12/29 Alexander Farber alexander.far...@gmail.com
Hello Bill and others,
I don't agree about yw being a bad thing
since I have weekly raings in my app,
but your XML suggestion -
On Tue, Dec 28, 2010 at 9:29 PM, Bill Moran wmo...@potentialtech.com
wrote:
If there are multiple
On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
user id=bla bla bla ...
pref_money date=2010-52 money=760 /
pref_money date=2010-51 money=3848 /
... etc ...
/user
Well, generally storing data in attributes should be avoided:
user id=id
pref_money
2010/12/29 Alexander Farber alexander.far...@gmail.com
On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin dmit...@gmail.com
wrote:
user id=bla bla bla ...
pref_money date=2010-52 money=760 /
pref_money date=2010-51 money=3848 /
... etc ...
/user
Well, generally storing
In response to Alexander Farber alexander.far...@gmail.com:
Hello Bill and others,
I don't agree about yw being a bad thing
since I have weekly raings in my app,
but your XML suggestion -
Do as you like, but I'll bet my reputation that decision will become
an unnecessary limitation for the
Hello Dmitriy,
I think this combination of attributes and children:
user id=bla bla bla ...
pref_money date=2010-52 money=760 /
pref_money date=2010-51 money=3848 /
... etc ...
/user
will be a good balance between size and my original problem
(combining user data and their
Using 8.4, seeing min/max doing sequential scans for partitioned tables and
noticed similar posts. It wasn't clear to me if 9.0 addressed this. Wondered
what the state of this was.
Thanks
Tom
--
View this message in context:
Hi
I have restored a database using psql to windows version 8.4.
During the restore the trigger code became jumbled.
I now have a great number of lines that have moved so that they are now
included in lines the have been commented out – not to mention that the code
is hard to read.
Is
On Tue, Dec 28, 2010 at 6:06 PM, Bob Pawley rjpaw...@shaw.ca wrote:
Hi
I have restored a database using psql to windows version 8.4.
During the restore the trigger code became jumbled.
I now have a great number of lines that have moved so that they are now
included in lines the have
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
Hi
I have restored a database using psql to windows version 8.4.
During the restore the trigger code became jumbled.
I now have a great number of lines that have moved so that they are now
included in lines the have been commented
tmoore tmo...@ttitech.net writes:
Using 8.4, seeing min/max doing sequential scans for partitioned tables and
noticed similar posts. It wasn't clear to me if 9.0 addressed this. Wondered
what the state of this was.
Fixed for 9.1:
In the docs at http://www.postgresql.org/docs/9.0/static/sql-createindex.html,
I see that you can build indexes that include ordering.
Eg. create index t_col_idx on t (col DESC NULLS LAST);
Does that mean that the initial creation of the index acts like the
CLUSTER command? If so, what happens to
Thank you for responsing the problem.
Although you suggested, I had needed to prepare for version7 on AIX 5.2L.
Thus, i tried to build v7.4.6 not v7.4.30, and it was successfly. Thanks.
Tsutomu
bricklen brick...@gmail.com writes:
In the docs at http://www.postgresql.org/docs/9.0/static/sql-createindex.html,
I see that you can build indexes that include ordering.
Eg. create index t_col_idx on t (col DESC NULLS LAST);
Does that mean that the initial creation of the index acts like the
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 4:21 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
Hi
I have restored a database using psql to windows version
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 4:21 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
Yes I was just looking at it.
It seems that it was dumped in that form.
Any thoughts on how that could happen?? Not that it will help in this
instance.
Bob
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc:
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent:
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
Bob
--
Adrian Klaver
adrian.kla...@gmail.com
This is the plain text dump file through pg_admin dump. But the plain
text dump fie through psql restored in the same way.
I am not following. psql cannot create a dump file.
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
Bob
--
Adrian Klaver
adrian.kla...@gmail.com
This
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
Bob
--
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
On 12/28/2010 07:16 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message-
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message-
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:33 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
On 12/28/2010 07:40 PM, Bob Pawley wrote:
Open the file in Wordpad and see if it looks better.
I downloaded an sql editor and it looks the same in it as well.
At least the editor will make it easier to fix the problem. However I
would like to know what happened so I can avoid it in the
On December 28, 2010, Adrian Klaver adrian.kla...@gmail.com wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
Open the file in Wordpad and see if it looks better.
I downloaded an sql editor and it looks the same in it as well.
At least the editor will make it easier to fix the problem.
On 2010-12-28, at 5:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
bricklen brick...@gmail.com writes:
In the docs at
http://www.postgresql.org/docs/9.0/static/sql-createindex.html,
I see that you can build indexes that include ordering.
Eg. create index t_col_idx on t (col DESC NULLS LAST);
-Original Message-
From: Alan Hodgson
Sent: Tuesday, December 28, 2010 8:12 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On December 28, 2010, Adrian Klaver adrian.kla...@gmail.com wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
Open the file in
On Tue, Dec 28, 2010 at 8:05 PM, Bob Pawley rjpaw...@shaw.ca wrote:
What program are you using to look at the plain text file?
Notepad
Did you at some point open the backup file with notepad, make a change
and then save it? If so notepad may have permanently mangled the
backup. If so, do
On December 28, 2010, Bob Pawley rjpaw...@shaw.ca wrote:
It's often a good idea to maintain function definitions outside the
database,
under version control, and apply them to the database from there.
I would appreciate a more detailed explanation of this.
Treat them like source code.
2010/12/29 Alexander Farber alexander.far...@gmail.com
Hello Dmitriy,
I think this combination of attributes and children:
user id=bla bla bla ...
pref_money date=2010-52 money=760 /
pref_money date=2010-51 money=3848 /
... etc ...
/user
will be a good balance between
Le 29/12/2010 05:28, Bricklen a écrit :
On 2010-12-28, at 5:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
bricklen brick...@gmail.com writes:
In the docs at
http://www.postgresql.org/docs/9.0/static/sql-createindex.html,
I see that you can build indexes that include ordering.
Eg. create index
53 matches
Mail list logo