Mitesh51 wrote:
If I move any file from the \PostgreSQL\8.4\data\pg_xlog\ then postgres
services are stopped & I cannot start them. I need to reinstall the
postgres.
well, then don't move any file from pg_xlog while postgres is running!
(was there a question here?)
--
Sent via pgsql-ge
On Mon, Oct 12, 2009 at 8:02 PM, Ivan Sergio Borgonovo wrote:
> On Mon, 12 Oct 2009 19:26:55 +0530
> Gaini Rajeshwar wrote:
>
> > Ivan,
> > If i create a tsvector as you mentioned with concatenation
> > operator, my search query will search in any of these fields which
> > are concatenated in my
On Tue, Oct 13, 2009 at 11:00 AM, Christophe Pettus wrote:
>
> On Oct 12, 2009, at 9:59 PM, Gaini Rajeshwar wrote:
>
>> From the readings and documentation, i understood that there are 4 weights
>> A,B,C,D (1.0, 0.4, 0.2, 0.1 are the defalut values, which can be changed) to
>> rank the search resu
On Oct 12, 2009, at 9:59 PM, Gaini Rajeshwar wrote:
From the readings and documentation, i understood that there are 4
weights A,B,C,D (1.0, 0.4, 0.2, 0.1 are the defalut values, which
can be changed) to rank the search results.
But using just these 4 weights is too less to rank the search
When I set
archive_mode = on # allows archiving to be done
# (change requires restart)
archive_command = 'copy "%p" "C:\\archivedir\\%f"' # command to
use to
archive a logfile segment
in postgres...WAL files are created.
But I am not
If I move any file from the \PostgreSQL\8.4\data\pg_xlog\ then postgres
services are stopped & I cannot start them. I need to reinstall the
postgres.
--
View this message in context:
http://www.nabble.com/Cannot-start-the-postgres-service-tp25867194p25867194.html
Sent from the PostgreSQL - gener
On Mon, Oct 12, 2009 at 5:18 PM, Bill Todd wrote:
> Scott Marlowe wrote:
>
> On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd wrote:
>
>
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
> ...more stuff...
> COMMIT;
> COMMIT;
>
>
> Postgresql u
Hi,
>From the readings and documentation, i understood that there are 4 weights *
A,B,C,D *(*1.0, 0.4, 0.2, 0.1* are the defalut values, which can be changed)
to rank the search results.
But using just these 4 weights is too less to rank the search results, as i
have many fields to use for ranking.
On Thu, 2009-09-24 at 07:33 -0700, Ms swati chande wrote:
> LOG: server process (PID 3304) was terminated by exception
> 0xC005
>
> The execution for this and other queries has been fine so
> far.
>
> What is exception 0xC005?
0
On Sun, 2009-10-04 at 17:12 +0100, Sam Mason wrote:
> > There is an open source library by IBM that I use in my C++ code to do
> > this, and may be it can be incorporated into PG
> >
> > it is called decNumber
> > http://speleotrove.com/decimal/decnumber.html
>
> How would this help over PG's exi
On Mon, 2009-10-12 at 10:36 -0700, Erik Jones wrote:
> On Oct 11, 2009, at 10:51 AM, Naoko Reeves wrote:
>
> > Could you tell me if there is a way to know if trigger is invoked by
> > the code from another trigger?
> > For instance, table A Trigger deletes table B record. While in table
> > B
Yeah, the problem is when I test large join, the plan considered by geqo is
large than path. (3000+ vs 500+). However, the time used in optimizer of
geqo is 1/4 of path. By the way, I use the same query.
Another thing is for the join of 2 tables, geqo consider 60-90 plans.
In general, I think for l
Thanks again.
On Mon, 2009-10-12 at 21:14 -0400, Stephen Frost wrote:
> > Seems like the way to go, though it will be significantly slower
> than
> > psql or superuser reads (a couple of tables have ~10s-100sM rows).
>
> Erm, really? You've tested that and found it to be that much slower?
Sorry
* Dan Kortschak (dan.kortsc...@adelaide.edu.au) wrote:
> On Mon, 2009-10-12 at 20:21 -0400, Stephen Frost wrote:
> > > Does anyone have any suggestions (the least bad of the options above
> > > seems to be to use psql, but I think that is ugly)?
> >
> > perldoc DBD::Pg
> >
> > Read the 'COPY supp
On Tue, Oct 13, 2009 at 11:10:12AM +1030, Dan Kortschak wrote:
> On Mon, 2009-10-12 at 20:21 -0400, Stephen Frost wrote:
> > Read the 'COPY support' section.
>
> Seems like the way to go, though it will be significantly slower than
> psql or superuser reads (a couple of tables have ~10s-100sM rows
Thanks for that.
On Mon, 2009-10-12 at 20:21 -0400, Stephen Frost wrote:
> * Dan Kortschak (dan.kortsc...@adelaide.edu.au) wrote:
> > $dbh->do("COPY chromosome_data FROM '".chromosomes(\%options)."' CSV");
>
> > Does anyone have any suggestions (the least bad of the options above
> > seems to be
* Dan Kortschak (dan.kortsc...@adelaide.edu.au) wrote:
> $dbh->do("COPY chromosome_data FROM '".chromosomes(\%options)."' CSV");
> Does anyone have any suggestions (the least bad of the options above
> seems to be to use psql, but I think that is ugly)?
perldoc DBD::Pg
Read the 'COPY support' se
Hi,
I'm using the perl DBI module to interface with Pg, generating a number
of tables and then loading them into a postgres database (this is to
automate a previously psql-based setup).
One instance of loading the data looks like this, but I am only able to
do this as a superuser (this is possibl
Jeff Davis escribió:
> On Mon, 2009-10-12 at 16:18 -0700, Bill Todd wrote:
> > Savepoints do not provide the same functionality as nested or parallel
> > transactions because you cannot commit a savepoint.
>
> What does it mean to "commit" a subtransaction or savepoint? What can
> you do with a su
On Mon, 2009-10-12 at 16:18 -0700, Bill Todd wrote:
> Savepoints do not provide the same functionality as nested or parallel
> transactions because you cannot commit a savepoint.
What does it mean to "commit" a subtransaction or savepoint? What can
you do with a subtransaction that you can't do wi
Scott Marlowe wrote:
On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd wrote:
Does PostgreSQL support nested transactions as shown below?
BEGIN;
...do some stuff...
BEGIN;
...more stuff...
COMMIT;
COMMIT;
Postgresql uses savepoints.
Savepoints do not provide the same functionality
On Mon, Oct 12, 2009 at 03:36:47PM -0500, Dave Huber wrote:
> > Surely, there are valid cases of having a function create a
> > function. Suppose (just off the top of my head), you create a
> > helper function that generates triggers on a table for record
> > archiving.
>
> My application is for
> Surely, there are valid cases of having a function create a function.
> Suppose (just off the top of my head), you create a helper function
> that generates triggers on a table for record archiving.
My application is for archiving. I'm using partitioned tables (each 10
records) to keep a ro
On Mon, Oct 12, 2009 at 3:41 PM, David Fetter wrote:
> On Mon, Oct 12, 2009 at 02:12:35PM -0500, Dave Huber wrote:
>> Is it possible to execute a CREATE OR REPLACE FUNCTION with another
>> function or even have a function modify itself?
>
> Yes, but doing any of that is a sign that you're working
On Mon, Oct 12, 2009 at 02:12:35PM -0500, Dave Huber wrote:
> Is it possible to execute a CREATE OR REPLACE FUNCTION with another
> function or even have a function modify itself?
Yes, but doing any of that is a sign that you're working with a broken
design. That, or you're looking to make an ent
Is it possible to execute a CREATE OR REPLACE FUNCTION with another function or
even have a function modify itself?
Dave
This electronic mail message is intended exclusively for the individual(s) or
entity to which it is addressed. This message, together with an
On Oct 9, 2009, at 9:57 AM, Takeichi Kanzaki Cabrera wrote:
Hi everybody, I need your help. I have a hierarchy of tables, and
other table that has a foreign key with the top table of the
hierarchy, can I insert a value into the "other" table where the value
it reference is not on the parent tab
PostgreSQL Conference West is set to start this Friday. Online
registration for PostgreSQL Conference West will be closing October
14th.
If you have not yet registered now is the time. You can register online
here:
http://www.postgresql.us/purchase
Review the schedule here:
http://www.postgresq
On Oct 11, 2009, at 10:51 AM, Naoko Reeves wrote:
Could you tell me if there is a way to know if trigger is invoked by
the code from another trigger?
For instance, table A Trigger deletes table B record. While in table
B trigger, I want to know whether this was triggered from table A.
Nothi
On Mon, 12 Oct 2009 20:02:16 +0530
Gaini Rajeshwar wrote:
> > inputquery := setweight(cfg, inputtitle, 'A', '&');
> > inputquery := inputquery && setweight(cfg, inputsummary, 'B',
> > '&');
> I didn't understand why did u use '&' operator in setweight
> function. is that going to help in any wa
On Sun, Oct 11, 2009 at 07:41:54PM -0700, Bill Todd wrote:
> Does PostgreSQL support nested transactions as shown below?
>
> BEGIN;
> ...do some stuff...
> BEGIN;
>...more stuff...
> COMMIT;
> COMMIT;
It depends what you want to have happen when the outer transaction
rolls back. If you wan
"utsav" writes:
> I am using postgres 7.3. on RHEL 4.0
7.3.what? If it's not 7.3.21 then an update would probably be worth
your time. In particular there were fixes in 7.3.14 and 7.3.20 that
could possibly explain this.
If it is 7.3.21, then I think an upgrade to a newer major release series
I understood , thanks.
--- 09年10月12日，周一, Martijn van Oosterhout 写道：
发件人: Martijn van Oosterhout
主题: Re: [GENERAL] table full scan or index full scan?
收件人: "Peter Hunsberger"
抄送: "Scott Marlowe" , " ??"
, pgsql-general@postgresql.org
日期: 2009年10月12日,周一,下午2:25
On Sun, Oct 11, 2009 at 10:01
Dear All ,
I am using postgres 7.3. on RHEL 4.0
I have table on which there are duplicate rows even though there is a primary
key constraint.I dont know how the rows got duplicate , because in my s/w there
is no such possibility.
Wel till now i used to delete the row duplicate row with the he
Dunno, if it was a documented behavior it should fail both on on 8.1 Linux
and on 8.4 Windows, but it only fails on 8.4 Windows.
I will try to create a clear test.
Merlin Moncure-2 wrote:
>
> On Sun, Oct 11, 2009 at 6:21 PM, SunWuKung wrote:
>>
>> Yep,
>> it is probably a bug though.
>
> I
hi there ...
for this work i will include you in my evening prayers for at least one
week.
i know there has been a lot of discussion about this but what you just
posted it excellent and more important: USEFUL to many people.
i had something else in mind recently as well: virtual indexes. it w
On Mon, Oct 12, 2009 at 7:26 PM, Ivan Sergio Borgonovo wrote:
> On Mon, 12 Oct 2009 19:11:01 +0530
> Gaini Rajeshwar wrote:
>
> > I think you misunderstood my question. let me give clear idea
> > about what i need.
> >
> > I am using PostgreSQL fulltext search (tsearch2) feature to
> > implement
On Mon, 12 Oct 2009 19:26:55 +0530
Gaini Rajeshwar wrote:
> Ivan,
> If i create a tsvector as you mentioned with concatenation
> operator, my search query will search in any of these fields which
> are concatenated in my tsvector.
> For example, if i create tsvector like this,
> UPDATE document_t
Tyler Durden writes:
> I'm trying to migrate a database from an old posgresql 8.1 server to a
> new one 8.3. I have the Postgis installed on that old database, that
> is not used.
> When I try to restore the database, several errors happens because of
> the various links to libs of Postgis on the
=?UTF-8?B?57qq5pmT5pum?= writes:
> Is it a reasonable idea to add a counter to set_cheapest?
You can try it but I think you'll find it's not terribly useful.
That will effectively just give you a count of the number of join
combinations that were considered (plus the number of base relations).
Ivan,
If i create a tsvector as you mentioned with concatenation operator, my
search query will search in any of these fields which are concatenated in my
tsvector.
For example, if i create tsvector like this,
UPDATE document_table SET search_col =
setweight(to_tsvector(coalesce(title,'')), 'A')
On Mon, 12 Oct 2009 19:11:01 +0530
Gaini Rajeshwar wrote:
> I think you misunderstood my question. let me give clear idea
> about what i need.
>
> I am using PostgreSQL fulltext search (tsearch2) feature to
> implement searching on database. From readings i came to know that
> we can give weight
On Mon, 12 Oct 2009 18:46:02 +0530
Gaini Rajeshwar wrote:
> Hi,
> is there a way to rank the search results based on multiple fields
> in postgreSQL?
> For example,
> i have *title*, *abstract*, *summary*, *body* as fields/columns in
> my database. When user searches on *title*, i want to rank th
Hello,
Is there a way to identify cascading of trigger execution level?
Please let me know if my question doesn't make any sense.
I think you misunderstood my question. let me give clear idea about what i
need.
I am using PostgreSQL fulltext search (tsearch2) feature to implement
searching on database. From readings i came to know that we can give weights
to different fields in database something like this:
*setweight(to_ts
On 12/10/2009 14:23, Raymond O'Donnell wrote:
> Hoe do you define "importance"?
Whoops... for "Hoe" read "How" :-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r...@iol.ie
Galway Cathedral Recitals: h
On 12/10/2009 14:16, Gaini Rajeshwar wrote:
> Hi,
> is there a way to rank the search results based on multiple fields in
> postgreSQL?
> For example,
> i have *title*, *abstract*, *summary*, *body* as fields/columns in my
> database. When user searches on *title*, i want to rank the results based
Hi,
is there a way to rank the search results based on multiple fields in
postgreSQL?
For example,
i have *title*, *abstract*, *summary*, *body* as fields/columns in my
database. When user searches on *title*, i want to rank the results based on
*title* field as well as *summary* field, where impor
On Mon, 2009-10-12 at 16:06 +0400, Vasiliy G Tolstov wrote:
> В Пнд, 12/10/2009 в 15:04 +0300, Peter Eisentraut пишет:
>
> >
> > Use --auth=md5.
> >
>
> Why? crypt is deprecated?
Yes, and removed in 8.4.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Hi,
I'm trying to migrate a database from an old posgresql 8.1 server to a
new one 8.3. I have the Postgis installed on that old database, that
is not used.
When I try to restore the database, several errors happens because of
the various links to libs of Postgis on the disk .
How do I dump the da
В Пнд, 12/10/2009 в 15:04 +0300, Peter Eisentraut пишет:
>
> Use --auth=md5.
>
Why? crypt is deprecated?
--
Vasiliy G Tolstov
Selfip.Ru
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
On Mon, 2009-10-12 at 15:17 +0400, Vasiliy G Tolstov wrote:
> Hello.
> Today i'm try to install postresql an init database
>
> initdb --pgdata=/media/pgsql --encoding=utf8 --locale=en_US.UTF-8
> --auth=crypt --username=postgres --pwprompt
>
> password is crypted $1$qJzh/8AD$Q0wVsHF9XE9NmA/8uKjy2/
Is it a reasonable idea to add a counter to set_cheapest? I think this
function evaluate the cheapest path. Therefore, it means how many complete
plans have been considered, doesn't it?
2009/10/12 纪晓曦
> What I want to count is the number of plans that have been considered
> cheapest_path. Since
What I want to count is the number of plans that have been considered
cheapest_path. Since if a path is considered to be a cheapest_path, the
postgres optimizer need to spent time on comparison. I think this is what I
want.
2009/10/4 Martijn van Oosterhout
> On Sat, Oct 03, 2009 at 04:20:59PM
On Sun, Oct 11, 2009 at 6:21 PM, SunWuKung wrote:
>
> Yep,
> it is probably a bug though.
It's not...it's just the way plpgsql works. I prefix all my local
variables in plpgsql with an underscore to prevent these kinds of
conflicts.
merlin
--
Sent via pgsql-general mailing list (pgsql-general
Le vendredi 09 octobre 2009 19:31:56, Dominic Bevacqua a écrit :
> Hi
>
> This is probably a naive question, but what would I gain from using
> snowball and ispell dictionaries in tsearch2, as described here:
>
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intr
> o.html
Hello.
Today i'm try to install postresql an init database
initdb --pgdata=/media/pgsql --encoding=utf8 --locale=en_US.UTF-8
--auth=crypt --username=postgres --pwprompt
password is crypted $1$qJzh/8AD$Q0wVsHF9XE9NmA/8uKjy2/
then i start postgresql and try to connect via psql following message
ap
On Mon, Oct 12, 2009 at 09:13:09AM +0100, Thom Brown wrote:
> I tried posting this on the pgsql-sql but they don't seem to be posting
> successfully there, so I'm re-posting it here.
>
> I've had a look at examples of lag and lead window functions with order by
> inside the OVER clause, and I'm co
I tried posting this on the pgsql-sql but they don't seem to be posting
successfully there, so I'm re-posting it here.
I've had a look at examples of lag and lead window functions with order by
inside the OVER clause, and I'm confused as to why it influences the overall
order in the output.
For e
59 matches
Mail list logo
