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
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
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
>
>
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
-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 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
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 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
-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: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:
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:
-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: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 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 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: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
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
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
-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
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
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
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
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
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
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
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
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
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
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
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
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
> 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
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.:
>
>
>
>
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
> -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
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
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:
>
>
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
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 || "
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
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
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
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,
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/
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/
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
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
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
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
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
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
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
53 matches
Mail list logo
