Bob Pawley wrote:
I am installing version 8.1 in Win XP.
Some of the tables I create have the next row displayed, empty, ready for the
next input.
Other tables display only rows with values inserted.
Version 8.0 always displayed the next row.
Is this a characteristic of a difference in 8.1 o
Joshua D. Drake wrote:
On Sun, 2006-12-03 at 08:34 -0800, [EMAIL PROTECTED] wrote:
I had a similar experience with their classes here in Massachusetts.
In the end my boss overrode me and decided to go with MySQL for
our project, since we can find reliable training from MySQL AB.
There
On Dec 2, 2006, at 10:09 , a wrote:
The database folder has a file called postgresql.cons
I assume you mean postgresql.conf?
where we can
specify no of active connections to the database -N which is currently
1024 and also specify the shared buffers. Is there any thumbrule in
deciding the -
I am installing version 8.1 in Win XP.
Some of the tables I create have the next row displayed, empty, ready for the
next input.
Other tables display only rows with values inserted.
Version 8.0 always displayed the next row.
Is this a characteristic of a difference in 8.1 or am I missing somet
On Sun, 2006-12-03 at 08:34 -0800, [EMAIL PROTECTED] wrote:
> I had a similar experience with their classes here in Massachusetts.
> In the end my boss overrode me and decided to go with MySQL for
> our project, since we can find reliable training from MySQL AB.
There are three well known provider
"Niederland" <[EMAIL PROTECTED]> writes:
> How do I issue a vacuum while in standalone mode?
You use a standalone backend. See
http://www.postgresql.org/docs/8.1/static/app-postgres.html
regards, tom lane
---(end of broadcast)-
"Michael Guyver" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION test_v_01() RETURNS VARCHAR AS $$
> DECLARE
> buffer varchar;
> i int4;
> BEGIN
> buffer := 'the quick brown fox jumps over the lazy dog';
> FOR i IN 1..1000 LOOP
> buffer := buffer || 't
Luiz,
I posted answer in openfts mailing list. Short version:
get old .c,.h files from openfts cvs repository.
Oleg
On Fri, 1 Dec 2006, Luiz Claudio da Silva Le?o wrote:
Hi,
I am trying to create de protuguese dictionary in order to use tserch2.
The steps I followed are described below:
1)
wheel wrote:
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
wheel wrote:
Can a pgsql 8.1 database be restored from the raw file? For one database
I have only the files found in the base folder, example C:\PostgreSQL
\data\base\16404, there are many files called 1247, 1248, etc (n
Hi,
I am building a web app backed by database postgresql and currently the
site is under a humongous torrent of hits. I have a question regarding
the database backend config.
The database folder has a file called postgresql.cons where we can
specify no of active connections to the database -N wh
My 8.1 cluster lc_collate and lc_ctype are
Estonian_Estonia.1257. Database encoding is UTF8.
Some columns in some tables contain data in Russian,Finnish, German and
Latvian languages.
I need to force server to perform sorting and case insensitive search for
those columns using column language.
Hi,
I am trying to create de protuguese dictionary in order to use tserch2.
The steps I followed are described below:
1) Login system as user1
2) cd
3) tar -xvzf postgresql-8.1.5.tar.gz
4) cd postgresql-8.1.5
5) ./configure
6) gmake
7) su
8) gmake install
9) adduser postgres
10) mkdir /usr/loca
I'm having some trouble inserting into newly-created partitions
of a partitioned table scheme.
My main question is whether the following constitutes a bug, or
(more likely) a gap in my understanding of what should
happen? Production problem observed on 8.1.3, this test case was
on 8.2RC1. (I poste
This is a windows installation postgresql 8.5.1
trying to start postgresql provides the following:
2006-12-03 08:58:11 LOG: database system was shut down at 2006-12-02
11:01:55 Mountain Standard Time
2006-12-03 08:58:11 LOG: checkpoint record is at 13/173572B0
2006-12-03 08:58:11 LOG: redo rec
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> wheel wrote:
> > Can a pgsql 8.1 database be restored from the raw file? For one database
> > I have only the files found in the base folder, example C:\PostgreSQL
> > \data\base\16404, there are many files called 1247, 1248, etc (no
>
I had a similar experience with their classes here in Massachusetts.
In the end my boss overrode me and decided to go with MySQL for
our project, since we can find reliable training from MySQL AB.
[EMAIL PROTECTED] wrote:
> I've been tasked with administering one of our PostgreSQL databases and
>
"Michael Guyver" <[EMAIL PROTECTED]> writes:
> ... Running the array_append version is faster by at least one order of
> magnitude in these examples.
Really? I see only about a 50% advantage (155 msec vs 105 msec) in both
8.1 and 8.2. What PG version are you running? What database encoding
are
If there's a risk that multiple clients will try to execute a 'create or replace
function' simultaneously, what's the recommended practice for putting it in a
transaction and/or locking it? If a lock's incolved what should this be applied
to- the table that the function is most likely to be involve
Dear all,
I am intending to store the files inside the postgres DB using the
type text (all the files will be pre-encode into base64. The reason
for not using the type bytea as I encountered some undesired
format(the original file alignment can't be preserved) while
extracting the content and dis
Gents,
At risk of answering my own question to spur someone actually to share
their thoughts on this topic, I thought I'd provide a quick look at
the performance of the alternatives: either using the || operator, or
the array_append method.
-- SELECT * FROM test_v_01();
-- SELECT * FROM test_v_0
Yes , that was the case indeed. I disabled seq scan and it used the index. And
the cost was higher than seq scan.
Thanks a lot for all your replies.
With warm regards.
Vivek J. Joshi.
[EMAIL PROTECTED]
Trikon Electronics Pvt. Ltd.
All science is either physics or stamp collecting.
21 matches
Mail list logo
