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 both
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 wrote:
> 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 beleive.
> Can you suggest
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. St
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
> Dear Tom,
>
> Thanks for your hints; it is indeed funny (as mentioned by Guillaume) how
> i
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 wrote:
> On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin
> wrote:
> > I am new to postgres. I am using 9.0.1 of postgres.
> > I am usi
28 декабря 2010 г. 13:02 пользователь el dorado написал:
> 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
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:
http://www.postgresql.org/docs/
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, you should read our docu about tablespaces:
http://www.postgresql.org/docs/current/
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 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 (/mnt/data is already
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 built
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 wrote:
>
> New versions of Devart ADO.NET Data Providers
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 || ":" || row
2010/12/28 Alexander Farber
> 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:
>
>
2010/12/28 Dmitriy Igrishin
>
>
> 2010/12/28 Alexander Farber
>
> 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 p
> -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 2
In response to "Igor Neyman" :
>
>
> > -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
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 wrote:
>
> If there are multiple entries for pref_money, then each one should be
> a container inside user, i.e.:
>
>
>
>
2010/12/29 Alexander Farber
> 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
> wrote:
> >
> > If there are multiple entries for pref_money, then each one shoul
On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin wrote:
>> >
>> >
>> > ... etc ...
>> >
>
> Well, generally storing data in attributes should be avoided:
>
>
>
> ...
> ...
>
> ...
>
> is a better.
Attributes give me smaller size...
Regards
Alex
--
Sent via pgsql-genera
2010/12/29 Alexander Farber
> On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin
> wrote:
> >> >
> >> >
> >> > ... etc ...
> >> >
> >
> > Well, generally storing data in attributes should be avoided:
> >
> >
> >
> > ...
> > ...
> >
> > ...
> >
> > is a better.
>
> Attribut
In response to Alexander Farber :
> 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 application at some p
Hello Dmitriy,
I think this combination of attributes and children:
>> >> >
>> >> >
>> >> > ... etc ...
>> >> >
will be a good balance between size and my original problem
(combining user data and their stats in 1 chunk of information).
And I don't use JSON, because it is not natively
supp
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:
http://postgresql.1045698.n5.nabble.com/Min-Max-for-partitioned-table
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 there
On Tue, Dec 28, 2010 at 6:06 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 commen
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 comm
tmoore 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:
http://archives.postgresql.org/pgsql-committers/2010-11/msg00028.php
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 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
> CLUSTER comm
-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 w
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: pgsql-general@postgresql.or
-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: Tuesday
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 cre
-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
>
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
>
> --
> A
-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 28
-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 28
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- From:
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- From:
-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 28
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 future
On December 28, 2010, Adrian Klaver 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. However
On 2010-12-28, at 5:22 PM, Tom Lane wrote:
> bricklen 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 i
-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 wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
>> Open the file in Wordpad and see if it looks
On Tue, Dec 28, 2010 at 8:05 PM, Bob Pawley 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 you have an ori
On December 28, 2010, "Bob Pawley" 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.
>
> Bob
>
>
2010/12/29 Alexander Farber
> Hello Dmitriy,
>
> I think this combination of attributes and children:
>
> >> >> >
> >> >> >
> >> >> > ... etc ...
> >> >> >
>
> will be a good balance between size and my original problem
> (combining user data and their stats in 1 chunk of information).
>
> A
Le 29/12/2010 05:28, Bricklen a écrit :
> On 2010-12-28, at 5:22 PM, Tom Lane wrote:
>
>> bricklen 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
53 matches
Mail list logo
