On 18 Dec 2006 07:16:56 -0800, Angva <[EMAIL PROTECTED]> wrote:
The funny thing is that once it does fail, it fails consistently until
the server is bounced - I must have run the cluster script 10 times
after the initial failure. The server's 6g of RAM is normally more than
enough (so normally,
Reece Hart wrote:
On Mon, 2006-12-18 at 15:47 -0800, Joshua D. Drake wrote:
Take a look at let us know what you think and how it performs for you.
Terrific. Fast and meaningful.
I echo Thomas' request to have docs limited to a version (or, better,
most recent). Perhaps archived docs should
Hi,
On Tue, 2006-12-19 at 16:47 +1000, CARMODA wrote:
> I am currently investigating the preferred method of clustering a
> postgresql database on Redhat?
> we already have licences for Redhat Enterprise Linux ES v4, i was
> wondering if Redhat's Cluster Manager is a candidate?
Using RHEL +
Hi,
I am currently investigating the preferred method of clustering a
postgresql database on Redhat?
i would really appreciate some suggestions or experiences you guys have had.
note: performance & redundancy are both equally desirable and i have
plenty of resources.
we already have licenc
Glen Parker <[EMAIL PROTECTED]> writes:
> I am still trying to roll my own auto vacuum thingy.
Um, is this purely for hack value? What is it that you find inadequate
about regular autovacuum? It is configurable through the pg_autovacuum
catalog --- which I'd be the first to agree is a sucky user
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> My concern regarding the rule system is not related to the incorrect
> update count but the fact that my update statement was suppose to
> change BOTH name AND dresssize. However, as you see only the name was
> changed, dresssize remains unchanged.
Hello,
Searching after "tsearch"
5. PostgreSQL: Documentation: Manuals: PostgreSQL 7.4: Examples [0.1]
...tsearch and tsearch2Full text
indexingPrevHomeNextLimitationsUpPage Files User Comments No comments
could be found for this...
http://www.postgresql.org/docs/7.4/interactive/examples.htm
am Tue, dem 19.12.2006, um 13:32:10 +0900 mailte Richard Ollier folgendes:
> Hello,
>
> I was wondering it there was a way to optimize a view.
> If my view contains 20 LEFT joins, my guessing is that each time I will
> make a select on it, the view will be completely recalculated. Is there
> a
> > postgres=# update vwife
> >set name = 'Katheryn',
> >dresssize = 12
> >where (id,name,dresssize)=(2,'katie',11);
> > UPDATE 0
> > postgres=# select * from vwife;
> > id | name | dresssize
> > +--+---
> > 2 | Katheryn |11
Hello,
I was wondering it there was a way to optimize a view.
If my view contains 20 LEFT joins, my guessing is that each time I will
make a select on it, the view will be completely recalculated. Is there
a way to have it up and running all the time like a table would be ?
Any advice here is
semi-ambivalent wrote:
All,
I have a simple web page that inserts data into a table in 8.1.5 using
PHP4. It's pretty amateurish but gets the job done. A few days ago I
upgraded to 8.2 (this is on a FreeBSD system, and I used the port) but
when I tried to use the web page this morning I got error
On Mon, 2006-12-18 at 20:23 -0600, Derrick wrote:
> Subject:
> [GENERAL] Anyone? Best way to
> authenticate postgres against
> active directory?
I know very little about AD, its kerberos implementation, and
interoperability limitations. I have been using kerberos with p
I've been struggling with pam_ldap and a windows 2003 active directory
server, trying to get postgres to authenticate against it. I'm
wondering what the best way to get postgres to authenticate against
windows active directory would be? I've posted the problem on the
general mail list that I
> The difference here is that by passing the values into a function, it
> creates a copy of the value, meaning it won't change due to an UPDATE.
> The only negative of using a function is that the number of affected
> tuples will always be zero.
The function and rule does indeed work from the psql
On Mon, 2006-12-18 at 17:09 -0800, Richard Broersma Jr wrote:
> > Actually, I am seeing some unexpected behavior, or rather behavior that
> > I wouldn't expect. After the first UPDATE in the rule, NEW and OLD are
> > gone.
>
> I guess the end-result behaviour I am looking for (as you mentioned) is
On Mon, 2006-12-18 at 15:47 -0800, Joshua D. Drake wrote:
> Take a look at let us know what you think and how it performs for you.
Terrific. Fast and meaningful.
I echo Thomas' request to have docs limited to a version (or, better,
most recent). Perhaps archived docs should be searched via a se
> Actually, I am seeing some unexpected behavior, or rather behavior that
> I wouldn't expect. After the first UPDATE in the rule, NEW and OLD are
> gone.
I guess the end-result behaviour I am looking for (as you mentioned) is having
an update-able view
behave exactly as if it were a table in reg
"Thomas H." <[EMAIL PROTECTED]> writes:
> i would love an advanced search where you can limit the results to a
> particular version of the documentation. the query for "SELECT" returns too
> many results from too many versions, obviously.
+1 on that.
> its fast & quick tho :-)
Indeed.
Be seei
On Mon, 2006-12-18 at 15:30 -0800, Richard Broersma Jr wrote:
> > > postgres=# update vwife
> > >set name = 'Katheryn',
> > >dresssize = 12
> > >where (id,name,dresssize)=(2,'katie',11);
> >
> > In "UPDATE #", # is the result of the libpq function PQcmdTup
I've already built the PostgreSQL database. Now I want to turn it and the
Delphi interface (host) into a distributable application.
I am using Installshield and I need to pick up the files in Postgres to
include.
Bob Pawley
- Original Message -
From: "John McCawley" <[EMAIL PROTECTE
Take a look at let us know what you think and how it performs for you.
i would love an advanced search where you can limit the results to a
particular version of the documentation. the query for "SELECT" returns too
many results from too many versions, obviously.
its fast & quick tho :-)
re
Hello,
search.postgresql.org is now served directly from PostgreSQL 8.2 ,
Tsearch2 and GIN. We have been testing thoroughly for the last couple of
weeks but of course... it is now open to the general public.
Take a look at let us know what you think and how it performs for you.
Sincerely,
Joshu
> What I was trying to explain is that all of your statements *are*
> succeeding. A WHERE clause in an UPDATE may match zero or more rows. The
> second UPDATE in your rule matches zero rows.
I see, that makes sense. I guess that my confussion was that update 0 was
not the same as success.
> You
> > postgres=# update vwife
> >set name = 'Katheryn',
> >dresssize = 12
> >where (id,name,dresssize)=(2,'katie',11);
>
> In "UPDATE #", # is the result of the libpq function PQcmdTuples(), and
> it refers to the number of tuples affected by the last comman
On Mon, 2006-12-18 at 15:06 -0800, Richard Broersma Jr wrote:
> > None of A, C, I, or D say that you need to report a truthful update
> > count.
> >
> > The fact that the update count is wrong with updatable views is a known
> > deficiency.
>
> I see. However, my my case I would like all of th
> None of A, C, I, or D say that you need to report a truthful update
> count.
>
> The fact that the update count is wrong with updatable views is a known
> deficiency.
I see. However, my my case I would like all of the sql statments in the rule
to succeed and if
they don't I would want none
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 18 Dec 2006, at 09:37, Alban Hertroys wrote:
Lars Heidieker wrote:
Hi all,
I just started to write my first stored procedure in plpgsql and
installed a trigger for it.
The two Tables are:
CREATE TABLE ltlocation (
"id" integer DEFAULT next
You probably need to re-compile PHP so that it can correctly link to the
new postgres binaries.
semi-ambivalent wrote:
All,
I have a simple web page that inserts data into a table in 8.1.5 using
PHP4. It's pretty amateurish but gets the job done. A few days ago I
upgraded to 8.2 (this is on a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 18 Dec 2006, at 09:26, Albe Laurenz wrote:
The strange thing is:
insert is OK (materialized path gets populated)
update of parent column is OK old values get delete and new ones get
inserted
but if the exception handling of the unique_violation
Tom Lane wrote:
> OK, I played around with this for a bit, and what I find is that in 8.1,
> that SPIExec context is where the sort operation run by CLUSTER's
> reindexing step allocates memory.
Interesting. I wonder if dropping indexes could alleviate this problem.
Please see another recent post o
All,
I have a simple web page that inserts data into a table in 8.1.5 using
PHP4. It's pretty amateurish but gets the job done. A few days ago I
upgraded to 8.2 (this is on a FreeBSD system, and I used the port) but
when I tried to use the web page this morning I got errors about:
PHP Fatal error
Alvaro Herrera wrote:
Glen Parker wrote:
The trouble now is, I don't see how to reset the statistics. My
assumption was that vacuum did it, but that appears to be false. How
does autovacuum do it? Can I do it with SQL?
Huh, reset what statistics? Autovacuum does not reset anything. What
Glen Parker wrote:
> The trouble now is, I don't see how to reset the statistics. My
> assumption was that vacuum did it, but that appears to be false. How
> does autovacuum do it? Can I do it with SQL?
Huh, reset what statistics? Autovacuum does not reset anything. What
statistics are you
On Mon, 2006-12-18 at 13:42 -0800, Richard Broersma Jr wrote:
> > > Would there be any interest in making rules with multiple sql statements
> > > acid compliant?
> > They are.
>
> postgres=# update vwife
>set name = 'Katheryn',
>dresssize = 12
>where (i
Richard Broersma Jr wrote:
> postgres=# update vwife
>set name = 'Katheryn',
>dresssize = 12
>where (id,name,dresssize)=(2,'katie',11);
> UPDATE 0
>
> postgres=# select * from vwife;
> id | name | dresssize
> +--+---
> 3 | dodie
> > Would there be any interest in making rules with multiple sql statements
> > acid compliant?
> They are.
Am I missing something then, becuase I have cases where it is possible to get
partial updates from
the multi-sql statement rule? I suppose that my understanding of "ACID"
actually mean
Hi all,
I am still trying to roll my own auto vacuum thingy. The goal is to
vacuum on demand in one step just like the old days, but not hit the
tables that never change (we have a lot). The idea now is to use a
combination of SQL and shell scripts to duplicate some of what auto
vacuum does
On Mon, 2006-12-18 at 13:20 -0800, Richard Broersma Jr wrote:
> I didn't see this on the to-do list.
>
> Would there be any interest in making rules with multiple sql statements acid
> compliant?
>
They are.
Regards,
Jeff Davis
---(end of broadcast)---
I didn't see this on the to-do list.
Would there be any interest in making rules with multiple sql statements acid
compliant?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I'm not quite sure I understand your question, do you mean that you wish
to distribute an "all-in-one" installer for a client machine that will
include both your app and PostgreSQL?
It all depends on the complexity of your database backend. If this is
small, quick-and-dirty app, I don't know
On Fri, 2006-12-15 at 04:58 -0800, [EMAIL PROTECTED] wrote:
> Hi !
> I have a strange slow performance problem depending on client computer.
> I have a postgresql server (8.1.3) running on an XP system (P4 3GHz,
> 1Go RAM).
>
> I have 3 other computers from which I make request on the database : 2
On Fri, 2006-12-15 at 17:21 -0200, Clodoaldo wrote:
> -- drop table test_table;
> create table test_table (tname varchar, value integer);
> insert into test_table values ('[ab]x', 1);
> insert into test_table values ('[ab]y', 2);
> insert into test_table values ('[Ab]z', 3);
> insert into test_tabl
Hi
I have managed to turn my host software into an executable. It runs well using
my installed database and server.
What files in PostgreSQL do I need to include to have the host software, the
PostgreSQL server and database run as an independant application??
Bob Pawley
In response to Tom Lane <[EMAIL PROTECTED]>:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > Notice that the order is different between the two. Apparently, log is more
> > verbose than notice for clients, but less verbose than notice for the log.
>
> Yup, that's intentional. LOG-level messages ar
Bill Moran <[EMAIL PROTECTED]> writes:
> Notice that the order is different between the two. Apparently, log is more
> verbose than notice for clients, but less verbose than notice for the log.
Yup, that's intentional. LOG-level messages are supposed to go to the
log but not to clients under the
I just had a "huh?!" moment ... brought to you by the postgresql.conf file ...
#client_min_messages = notice # Values, in order of decreasing detail:
# debug5
# debug4
> > I asked this on a pgcluster forum at pgfoundry a few days ago, but
> > no one responded
>
> I suspect that pgcluster has become obsoleted and no longer
> maintained.
Well, a patch for 8.2 was released on pgfoundry 7-Dec-2006.
> I suggest looking at pgpool-II and/or slony1 ... Also, the High
Bill makes several valid points, but in spite of them, the app I'm
writing has almost no logic in the database.
Why? Well, mostly because it would be too much trouble to remove all
of it. :) No, seriously...
Lack of a good language. Postgresql understands a growing number of
languages and that's
Richard Huxton writes:
> Andrus wrote:
>> How to allow non-superusres to create database with language ?
> You can't. If they can install a language-handler, they can install code
> that can do anything, including take control of the server and the unix
> account it runs as.
However, you could
I've been beating my head it trying to understand what is going on
here. I'm trying to setup postgresql to authenticate using pam_ldap
against a windows 2003 Active Directory server. I have setup accounts
on the Active directory and tested the authentication against it using
services like loc
Hi Sandro.
I think there is no silver bullet here (as in many other fields, too).
You could end with a mix of different approaches (simple checks done
on the database, while complex one are left in the application logic).
Also, most probably you will end moving that logic in the lifetime of
the
I asked this on a pgcluster forum at pgfoudry a few days ago, but no one
responded:
When I apply pgcluster-1.7.0rc1-patch to Postgres REL8_2_STABLE I get a
handful of rejects. Is this to be expected, or should I be applying
against some different source?
---(end of broadca
On 18 Dec 2006 06:20:35 -0800
"semi-ambivalent" <[EMAIL PROTECTED]> wrote:
[...]
> when I tried to use the web page this morning I got errors about:
> PHP Fatal error: Call to undefined function: pg_escape_string() in
> /usr/local/www/data-dist/some_dir/some_dir/dataInsert.php on line 9,
> refer
In response to Sandro Dentella <[EMAIL PROTECTED]>:
>
> Hi all,
>
> I'm starting a project in which I will use PostgreSQL in which I need to
> check permissions at different levels (eg.: status of a record, hierarchy
> and so on). The application needs to run with a web interface (sigh!).
""Raymond O'Donnell"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On 18 Dec 2006 at 12:08, Magnus Hagander wrote:
>
>> For client-side it's mostly copy/paste, but you will also need to
>> download some dependency DLLs (such as OpenSSL and MIT Kerberos)
>> elsewhere, unless you al
Hi all,
I'm starting a project in which I will use PostgreSQL in which I need to
check permissions at different levels (eg.: status of a record, hierarchy
and so on). The application needs to run with a web interface (sigh!).
At first I thought i'd like to put as much permission logic
On 18 Dec 2006 at 12:08, Magnus Hagander wrote:
> For client-side it's mostly copy/paste, but you will also need to
> download some dependency DLLs (such as OpenSSL and MIT Kerberos)
> elsewhere, unless you already have them on your system.
If you have pgAdmin III installed - and I'd strongly rec
On Mon, Dec 18, 2006 at 11:49:42AM +0100, riki wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Mon, Dec 18, 2006 at 09:52:27AM +0100, riki wrote:
> >> Hi all,
> >> is it possible to install postgres ver 8.1.4 on windows Me FAT32
> >> partition?
> >>
"Magnus Hagander" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Mon, Dec 18, 2006 at 09:52:27AM +0100, riki wrote:
>> Hi all,
>> is it possible to install postgres ver 8.1.4 on windows Me FAT32
>> partition?
>> if so, how?
>> on the second step of installation after i choose la
Anton Melser wrote:
> Hi,
> I am trying to move up in the world with my sql and need to do the
> following...
> I have a subscribers table and I need to export to csv (semi-colon
> separated) certain fields - that is fine, but I also need to export a
> multi-select field from another table as one s
Lars Heidieker wrote:
> Hi all,
>
> I just started to write my first stored procedure in plpgsql and
> installed a trigger for it.
>
> The two Tables are:
>
> CREATE TABLE ltlocation (
> "id" integer DEFAULT nextval('ltlocation_id_seq'::text) NOT NULL,
> name varchar(30) NOT NULL default '',
> The strange thing is:
> insert is OK (materialized path gets populated)
> update of parent column is OK old values get delete and new ones get
> inserted
> but if the exception handling of the unique_violation exception is
> removed an update on the id column fails, with
> an duplicate pkey v
On Mon, Dec 18, 2006 at 09:52:27AM +0100, riki wrote:
> Hi all,
> is it possible to install postgres ver 8.1.4 on windows Me FAT32 partition?
> if so, how?
> on the second step of installation after i choose language i get error
> message "Failed to create process: 2!".
> Win Me are freshly instal
Hi all,
is it possible to install postgres ver 8.1.4 on windows Me FAT32 partition?
if so, how?
on the second step of installation after i choose language i get error
message "Failed to create process: 2!".
Win Me are freshly installed.
thanks
---(end of broadcast)-
On Sun, Dec 17, 2006 at 08:14:43PM +1300, Steve Castellotti wrote:
>
>Hello all-
>I'm working with a poorly-designed schema and need to do a lookup in
> one
>table who's name I have to pull from a second table. I'm wondering if its
>possible to do something like this in Postgr
Henrik Zagerholm wrote:
Hello list,
I'm trying to install tsearch2 on a freshly created database in 8.2 but
I get these NOTICES when doing so.
Is this something to be concerned about?
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"pg_ts_dict_pkey" for table "pg_ts_dict"
NOTI
66 matches
Mail list logo
