Joost Kuckartz wrote:
Hello,
After a huge amount of trying out (I'm new at running webservers, I
had a lot of problems installing apache too) I finally was able to
install postpresql 8.2 (latest version) on my computer. What I want
to do in the end is have a local webserver running. I installed
am Wed, dem 20.12.2006, um 9:31:54 +0530 mailte Parthan folgendes:
> Hi,
> I am trying to create a simple trigger which inserts a couple of fields
> into a table, when data in inserted into another table.
>
> I have two tables, 'addressbook' and 'phonebook'. When I insert data
> into the address
Hi,
I am trying to create a simple trigger which inserts a couple of fields
into a table, when data in inserted into another table.
I have two tables, 'addressbook' and 'phonebook'. When I insert data
into the addressbook (whose fields are name, address1, address2,
address3, phonenum), I want it
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Derrick
> Sent: Tuesday, December 19, 2006 5:52 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] postgres kerberos how to
>
> I was wondering if anyone out there could point me in the
> right direction. I'm looking f
Glen Parker wrote:
> Alvaro Herrera wrote:
> >Glen Parker wrote:
> >
> >>I'd also like to use some of this information to issue reindex and
> >>cluster commands only when they're needed. In fact, on days when I
> >>cluster, there's no need whatsoever to also vacuum those tables. This
> >>is so
Brandon Aiken wrote:
You're saying that the dirtyness of a table is proportional to when you
plan on vacuuming it next.
The dirtiness of a table should most certainly have an effect on when it
gets vacuumed in relation to other tables. If dirtiness could be rated,
then the list of vacuumable
Alvaro Herrera wrote:
Glen Parker wrote:
I'd also like to use some of this information to issue reindex and
cluster commands only when they're needed. In fact, on days when I
cluster, there's no need whatsoever to also vacuum those tables. This
is something that autovacuum won't do at all.
* Derrick ([EMAIL PROTECTED]) wrote:
> I was wondering if anyone out there could point me in the right
> direction. I'm looking for a decent how to on using postgresql's built
> in kerberos support to authenticate against windows 2003 active
> directory. I was trying to use pam_ldap, but had t
Glen Parker wrote:
> I'd also like to use some of this information to issue reindex and
> cluster commands only when they're needed. In fact, on days when I
> cluster, there's no need whatsoever to also vacuum those tables. This
> is something that autovacuum won't do at all.
Well, I'd rathe
Alvaro Herrera wrote:
Glen Parker wrote:
That really seems like something that, if it's powerful, would also be
very complicated. If the autovacuum system could just call a user
defined function, all the complexity could be dropped back into the
admin's lap (which is fine with me :-).
I hav
I was wondering if anyone out there could point me in the right
direction. I'm looking for a decent how to on using postgresql's built
in kerberos support to authenticate against windows 2003 active
directory. I was trying to use pam_ldap, but had to give up and decide
on using kerberos inste
Glen Parker wrote:
I wonder if the simple solution is to just have a cron script modify
postgresql.conf and pg_ctl reload. That seems very flexible, or have
two postgresql.conf files and move them into place via cron.
I'd still prefer to vacuum on demand actually. Rather than hope that
autov
Glen Parker wrote:
> >The idea that has been discussed in the past is the concept of
> >maintenance windows, that is for any given period of time, you can set
> >different vacuum thresholds. So at night you might make the thresholds
> >very low so that nearly everything gets vacuumed but during
The idea that has been discussed in the past is the concept of
maintenance windows, that is for any given period of time, you can set
different vacuum thresholds. So at night you might make the thresholds
very low so that nearly everything gets vacuumed but during the day you
might only vacuum
I wonder if the simple solution is to just have a cron script modify
postgresql.conf and pg_ctl reload. That seems very flexible, or have
two postgresql.conf files and move them into place via cron.
I'd still prefer to vacuum on demand actually. Rather than hope that
autovacuum hit all the na
I think it would be good to make it more prominent. Maybe have all the
search forms integrated on a single page and put a link to it in the top
menu, next to Support.
well, why not add a dropdown (or even better a multi-select input) on the
search page where users can choose what to search in:
Matthew O'Connor wrote:
> Glen Parker wrote:
> > Matthew O'Connor wrote:
> >> No, how dirty a table isn't subjective, what is subjective is the
> >> question "Does it need to be vacuumed?". A that is 1% dirty (to use
> >> your term) probably doesn't *need* to be vacuumed, but you might
> >> cho
Glen Parker wrote:
Matthew O'Connor wrote:
No, how dirty a table isn't subjective, what is subjective is the
question "Does it need to be vacuumed?". A that is 1% dirty (to use
your term) probably doesn't *need* to be vacuumed, but you might
choose to vacuum it anyway at least you might at ni
Matthew O'Connor wrote:
No, how dirty a table isn't subjective, what is subjective is the
question "Does it need to be vacuumed?". A that is 1% dirty (to use
your term) probably doesn't *need* to be vacuumed, but you might choose
to vacuum it anyway at least you might at night when the system
Paul Silveira wrote:
> It's yelling about the xslt.h and other files that it can't find. I
> did a locate for xslt.h and it only found two web pages in the
> /usr/share/doc/libxslt-1.1.11 folder.
Presumably you need to install the dev(el(opment)) package belonging to
libxslt.
--
Peter Eisentra
Hi Paul,
On Tue, 2006-12-19 at 15:06 -0800, Paul Silveira wrote:
> xslt_proc.c:18:26: libxslt/xslt.h: No such file or directory
You need to install libxslt-devel or libxslt-dev .
Cheers,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom D
Hello,
I just installed Postgres 8.2 and was trying to add the xml2 contrib module.
I went to the folder that contained the contribs and attempted to run gmake.
I got this error...
[EMAIL PROTECTED] xml2]# gmake
gcc -I/usr/include/libxml2 -fpic -I. -I../../src/include -D_GNU_SOURCE -c
-o xsl
No, how dirty a table isn't subjective, what is subjective is the
question "Does it need to be vacuumed?". A that is 1% dirty (to use
your term) probably doesn't *need* to be vacuumed, but you might choose
to vacuum it anyway at least you might at night when the system isn't in
use.
See the
Alvaro Herrera wrote:
Walter Vaughan wrote:
I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem
to find where it placed admin82.sql, if in fact such a beast should have
been created with the initdb step.
I believe said admin81.sql corresponds to functions that were inc
You're saying that the dirtyness of a table is proportional to when you
plan on vacuuming it next. I don't see that connection at all. The
only correlation I might see is if it happens to be 5:59 AM when your DB
decides your table is dirty, and your maintenance window closes at 6:00
AM. Then you
Glen Parker wrote:
Erik Jones wrote:
Matthew O'Connor wrote:
Glen Parker wrote:
If it isn't there somewhere already, I would ask to add:
Expose a very easy way to discover autovacuum's opinion about a
particular table, for example "table_needs_vacuum(oid)", ignoring
any time constraints tha
Alvaro Herrera wrote:
Matthew O'Connor wrote:
Glen Parker wrote:
5) Expose a very easy way to discover autovacuum's opinion about a
particular table, for example "table_needs_vacuum(oid)", ignoring any
time constraints that may be in place.
This might be a nice feature however in the presence
Glen Parker wrote:
> Alvaro Herrera wrote:
> >>>4) Expose all information used by autovacuum to form its decisions.
> >>You could argue that this is already there, although not easy to get at
> >>I suppose. But all table threshold settings are available either in the
> >>pg_autovacuum relation o
Alvaro Herrera wrote:
4) Expose all information used by autovacuum to form its decisions.
You could argue that this is already there, although not easy to get at
I suppose. But all table threshold settings are available either in the
pg_autovacuum relation or the defaults via GUC variables, th
Erik Jones wrote:
Matthew O'Connor wrote:
Glen Parker wrote:
If it isn't there somewhere already, I would ask to add:
Expose a very easy way to discover autovacuum's opinion about a
particular table, for example "table_needs_vacuum(oid)", ignoring any
time constraints that may be in place.
Matthew O'Connor wrote:
Glen Parker wrote:
If it isn't there somewhere already, I would ask to add:
Expose a very easy way to discover autovacuum's opinion about a
particular table, for example "table_needs_vacuum(oid)", ignoring any
time constraints that may be in place.
This might be a ni
Alvaro Herrera wrote:
> Chris Browne wrote:
> > matthew@zeut.net ("Matthew O'Connor") writes:
> >
> > > Bruce Momjian wrote:
> > >> Yes, I think there are these TODO items. I was waiting to see what
> > >> additional replies there are before adding them.
> > >
> > > Speaking of which, I was just
Walter Vaughan wrote:
> I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem
> to find where it placed admin82.sql, if in fact such a beast should have
> been created with the initdb step.
I believe said admin81.sql corresponds to functions that were included
into 8.2, and
Matthew O'Connor wrote:
> Glen Parker wrote:
> >If it isn't there somewhere already, I would ask to add:
> >
> >4) Expose all information used by autovacuum to form its decisions.
>
> You could argue that this is already there, although not easy to get at
> I suppose. But all table threshold set
Is anyone successfully using pam_ldap with postgres to authenticate
database users? I've read a million how to docs but I've hit a road block.
Magnus Hagander wrote:
Stephen Frost wrote:
* John McCawley ([EMAIL PROTECTED]) wrote:
(I am working on this project with Derrick.) We have to
Glen Parker wrote:
If it isn't there somewhere already, I would ask to add:
4) Expose all information used by autovacuum to form its decisions.
You could argue that this is already there, although not easy to get at
I suppose. But all table threshold settings are available either in the
pg_
I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem to
find where it placed admin82.sql, if in fact such a beast should have been
created with the initdb step.
Any ideas?
Google has zero indexed documents with admin82.sql in it's engine, and of course
all the instument
1) Allow multiple "autovacuum workers": Currently Autovacuum is only
capable of ordering one vacuum command at a time, for most work loads
this is sufficient but falls down when a hot (very actively updated
table) goes unvacuumed for a long period of time because a large table
is currently bei
Chris Browne wrote:
> matthew@zeut.net ("Matthew O'Connor") writes:
>
> > Bruce Momjian wrote:
> >> Yes, I think there are these TODO items. I was waiting to see what
> >> additional replies there are before adding them.
> >
> > Speaking of which, I was just looking at the TODO at:
> >
> > http:/
I need to implement an option to change passwords in my application,
which authenticates using MD5. This application however operates over
unencrypted link, so it'll be a little bit of a challege.
I've came up with several possible implementations.
Hello,
After a huge amount of trying out (I'm new at running webservers, I had a lot
of problems installing apache too) I finally was able to install postpresql 8.2
(latest version) on my computer. What I want to do in the end is have a local
webserver running. I installed ms4w (package with p
Hannes Dorbath wrote:
http://pgfoundry.org/projects/pgmemcache/
We'd like to use pgmemcache with PG 8.2. The memcached version doesn't
matter much (1.2.x is current, 1.1.x would be fine as well).
It fails to build against 8.2 with various errors. The project seems
unmaintained and I failed t
Glen Parker wrote:
Tom Lane wrote:
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 interface,
but we're not going to set the user interface in concrete until we are
pretty conf
Bob Pawley wrote:
What is the best way of installing the tables, triggers etc? Do I add
a project dump file or generate them from an sql file?
Bob
Bob,
I would just have a sql script with the create database etc and then
after the server is up and running, execute the script via psql or yo
Stephen Frost wrote:
> * John McCawley ([EMAIL PROTECTED]) wrote:
>> (I am working on this project with Derrick.) We have to use the Active
>> Directory to authenticate not only users from our client-side app (We're
>> attempting to use PostgreSQL essentially as a proxy authentication
>> mechani
matthew@zeut.net ("Matthew O'Connor") writes:
> Bruce Momjian wrote:
>> Yes, I think there are these TODO items. I was waiting to see what
>> additional replies there are before adding them.
>
> Speaking of which, I was just looking at the TODO at:
>
> http://www.postgresql.org/docs/faqs.TODO.htm
Tom Lane wrote:
Glen Parker <[EMAIL PROTECTED]> writes:
I am still trying to roll my own auto vacuum thingy.
Um, is this purely for hack value?
Don't be silly ;-)
Honestly I sort of thought the problem was fairly obvious.
What is it that you find inadequate
about regular autovacuum? It is
On Dec 19, 2006, at 3:17 AM, Jeff Amiel wrote:
We have a production FreeBSD 6.0 system with Postgresql 8.1 where we
have avoided upgrading/updating the ports to avoid compatability and
other unknown issues.
We have our supfile default date set on our production, test and
development environment
Chansup Byun wrote:
> Hi,
>
> I'm trying to set up a trigger to prevent any duplicate entries into
> my table. But I couldn't figure out how to make my trigger work.
>
> I have a PostgreSQL 8.1.5 installation.
> I created the following table:
>
> CREATE TABLE attendance (
> attendance_id se
On Tue, 2006-12-19 at 13:25 +0100, Hannes Dorbath wrote:
> I think it would be useful to adjust the parser to not split on underscores:
>
> In case I'd like to lookup PG's to_number() function I won't get
> anything useful. Number is contained nearly everywhere and to is
> configured as stop wo
What is the best way of installing the tables, triggers etc? Do I add a
project dump file or generate them from an sql file?
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>;
Sent: Tuesday, December 19, 2006 9:57 AM
Subject: Re: [
> However, the rule system already
> adds the CTID TE to the query tree and it looks to me this can be extended to
> provide
> the requested behavior. The way the rewriter handles it's query
> qualifications would have to
> be redesigned as well, i think, but i don't know what can of worms there
On Tue, 19 Dec 2006 07:22:36 -0800 (PST), Richard Broersma Jr <[EMAIL
PROTECTED]> wrote:
>> Once you update one side of the join with a
>> different join key value, the join row in question no longer exists in
>> the view ... so the second update doesn't find a row to update. This
>> has noth
matthew@zeut.net ("Matthew O'Connor") writes:
> 2) Once we can have multiple autovacuum workers: Create the concept of
> hot tables that require more attention and should never be ignored for
> more that X minutes, perhaps have one "autovacuum worker" per hot
> table? (What do people think of this?
On 19 Dec 2006 08:37:01 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
[...]
What would solve my problem is if there was a
> method to, at the end of
>> a begin/end block, I could rollback the changes made in that block
>> without having to raise an exception. Is it somehow possible to
>> explici
Bob Pawley wrote:
Thanks Tony
What PostgreSQL files do I use?
Bob
Hi Bob,
you need these files:
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.1.5%2Fwin32%2Fpostgresql-8.1.5-1-binaries-no-installer.zip
You will need to modify the Inno script so it points to the correct
On 19 Dec 2006 07:01:41 -0800, Angva <[EMAIL PROTECTED]> wrote:
shared_buffers = 57344
work_mem = 20
maintenance_work_mem = 524288
work_mem seems to be high. what is you max_connections setting?
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
On Tue, 19 Dec 2006, Thomas H. wrote:
http://search.postgresql.org/search?q=HAVING
says "An error occured while searching."
I bet HAVING is a stop-word, so actual message is 'NOTICE: query contains
only stopword(s) or doesn't contain lexeme(s), ignored'
I think we should add to pg_dict di
http://search.postgresql.org/search?q=HAVING
says "An error occured while searching."
I bet HAVING is a stop-word, so actual message is 'NOTICE: query contains
only stopword(s) or doesn't contain lexeme(s), ignored'
I think we should add to pg_dict dictionary line
having having
just a th
Magnus Hagander wrote:
> As for searching spceific mailinglists, you can do that from the
> archives search page already. Perhaps it needs to be made more
> accessible or something?
Amazing. What I like the most about it is that it actually works.
Great!
I think it would be good to make it more
On Dec 19, 2006, at 8:15 AM, Magnus Hagander wrote:
On Tue, Dec 19, 2006 at 01:02:09PM -0300, Alvaro Herrera wrote:
Matthew O'Connor wrote:
Magnus Hagander wrote:
But seriously, I'm definitly interested in ways it can be
improved - and
that's true of the whole web team, I'm sure. It was ju
On Tue, 19 Dec 2006, Filip Rembiakowski wrote:
2006/12/19, Joshua D. Drake <[EMAIL PROTECTED]>:
Take a look at let us know what you think and how it performs for you.
http://search.postgresql.org/search?q=HAVING
says "An error occured while searching."
I bet HAVING is a stop-word, so actua
Thanks Tony
What PostgreSQL files do I use?
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>;
Sent: Tuesday, December 19, 2006 8:53 AM
Subject: Re: [GENERAL] Creating an Independant Application
Bob Pawley wrote:
Yes
I want to i
2006/12/19, Joshua D. Drake <[EMAIL PROTECTED]>:
Take a look at let us know what you think and how it performs for you.
http://search.postgresql.org/search?q=HAVING
says "An error occured while searching."
F.
---(end of broadcast)---
TIP 5: do
Bruce Momjian wrote:
Yes, I think there are these TODO items. I was waiting to see what
additional replies there are before adding them.
Speaking of which, I was just looking at the TODO at:
http://www.postgresql.org/docs/faqs.TODO.html
and I think this item:
* Improve xid wraparound detect
Yes, I think there are these TODO items. I was waiting to see what
additional replies there are before adding them.
---
Matthew O'Connor wrote:
> Alvaro Herrera wrote:
> > Csaba Nagy wrote:
> >>> Alternatively, perhaps a th
Alvaro Herrera wrote:
Csaba Nagy wrote:
Alternatively, perhaps a threshold so that a table is only considered
for vacuum if:
(table-size * overall-activity-in-last-hour) < threshold
Ideally you'd define your units appropriately so that you could just
define threshold in postgresql.conf as 3
Bob Pawley wrote:
Yes
I want to include the service and the tables, triggers etc. as an
installable application for one, or more, users.
I don't know if this is considered embedded or not, but there seems to
be a lack of infomation on how to accomplish this.
Bob
-
Hi Bob,
You can easily
Hello, the company I work for is an all MySQL shop. The new promises of
bi-directional support has their interest. I'm more a PostgreSQL fan and
wondered if there was any feature (bi-directional replication) support
available either in-house or 3rd party.
Thanks!
-William
On Tue, 2006-12-19 at 17:15 +0100, Magnus Hagander wrote:
> On Tue, Dec 19, 2006 at 09:41:38PM +0530, Gurjeet Singh wrote:
> > On 12/19/06, Matthew O'Connor wrote:
> > >
> > >Magnus Hagander wrote:
> > >> But seriously, I'm definitly interested in ways it can be improved - and
> > >> that's true o
On Dec 19, 5:32 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote:
> On Dec 19, 5:00 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
>
>
> > On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
>
> > > On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
> > > > I understand that due to
On Dec 19, 5:00 pm, "BigSmoke" <[EMAIL PROTECTED]> wrote:
> On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
>
>
>
> > On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
> > > I understand that due to a lack of nested transaction support, it is
> > > not possible to u
* John McCawley ([EMAIL PROTECTED]) wrote:
> (I am working on this project with Derrick.) We have to use the Active
> Directory to authenticate not only users from our client-side app (We're
> attempting to use PostgreSQL essentially as a proxy authentication
> mechanism), but also for connectio
On 12/19/06, Oleg Bartunov wrote:
On Tue, 19 Dec 2006, Gurjeet Singh wrote:
> On 12/19/06, Matthew O'Connor wrote:
>>
>> Magnus Hagander wrote:
>> > But seriously, I'm definitly interested in ways it can be improved -
and
>> > that's true of the whole web team, I'm sure. It was just my way of
Yes
I want to include the service and the tables, triggers etc. as an
installable application for one, or more, users.
I don't know if this is considered embedded or not, but there seems to be a
lack of infomation on how to accomplish this.
Bob
- Original Message -
From: "Johann
Magnus Hagander wrote:
We still have a searchform at search.postgresql.org. To search
mainliglists, click Archives search. You can select a list, or a group
of list, there. Or just search them all.
Anyone see any value in allowing the mailing list search to be sorted by
both ascending and desc
Csaba Nagy wrote:
Alternatively, perhaps a threshold so that a table is only considered
for vacuum if:
(table-size * overall-activity-in-last-hour) < threshold
Ideally you'd define your units appropriately so that you could just
define threshold in postgresql.conf as 30% (of peak activity in
Csaba Nagy wrote:
> > Alternatively, perhaps a threshold so that a table is only considered
> > for vacuum if:
> >(table-size * overall-activity-in-last-hour) < threshold
> > Ideally you'd define your units appropriately so that you could just
> > define threshold in postgresql.conf as 30% (o
(I am working on this project with Derrick.) We have to use the Active
Directory to authenticate not only users from our client-side app (We're
attempting to use PostgreSQL essentially as a proxy authentication
mechanism), but also for connections to the SFTP server, and finally our
web app. Ra
On Tue, 19 Dec 2006, Gurjeet Singh wrote:
On 12/19/06, Matthew O'Connor wrote:
Magnus Hagander wrote:
> But seriously, I'm definitly interested in ways it can be improved - and
> that's true of the whole web team, I'm sure. It was just my way of
> saying "it will take a while", but I'll file
On Tue, Dec 19, 2006 at 01:02:09PM -0300, Alvaro Herrera wrote:
> Matthew O'Connor wrote:
> > Magnus Hagander wrote:
> > >But seriously, I'm definitly interested in ways it can be improved - and
> > >that's true of the whole web team, I'm sure. It was just my way of
> > >saying "it will take a whil
On Tue, 19 Dec 2006, Alvaro Herrera wrote:
Matthew O'Connor wrote:
Magnus Hagander wrote:
But seriously, I'm definitly interested in ways it can be improved - and
that's true of the whole web team, I'm sure. It was just my way of
saying "it will take a while", but I'll file it away as a good t
On Tue, Dec 19, 2006 at 09:41:38PM +0530, Gurjeet Singh wrote:
> On 12/19/06, Matthew O'Connor wrote:
> >
> >Magnus Hagander wrote:
> >> But seriously, I'm definitly interested in ways it can be improved - and
> >> that's true of the whole web team, I'm sure. It was just my way of
> >> saying "it
On 12/19/06, Matthew O'Connor wrote:
Magnus Hagander wrote:
> But seriously, I'm definitly interested in ways it can be improved - and
> that's true of the whole web team, I'm sure. It was just my way of
> saying "it will take a while", but I'll file it away as a good thing to
> do when there i
On Tue, Dec 19, 2006 at 09:52:58AM -0600, Derrick Stensrud wrote:
> Thanks I've been trying to use pam_ldap but I keep getting this error
> from postgres. I think it may have something to do with postgres
> running as the postgres user and not having permissions to something,
> but I have no id
> Alternatively, perhaps a threshold so that a table is only considered
> for vacuum if:
>(table-size * overall-activity-in-last-hour) < threshold
> Ideally you'd define your units appropriately so that you could just
> define threshold in postgresql.conf as 30% (of peak activity in last 100
Matthew O'Connor wrote:
> Magnus Hagander wrote:
> >But seriously, I'm definitly interested in ways it can be improved - and
> >that's true of the whole web team, I'm sure. It was just my way of
> >saying "it will take a while", but I'll file it away as a good thing to
> >do when there is a moment
On Dec 19, 4:16 pm, [EMAIL PROTECTED] (Bernd Helmle) wrote:
> On 19 Dec 2006 07:05:10 -0800, "BigSmoke" <[EMAIL PROTECTED]> wrote:
>
> > I understand that due to a lack of nested transaction support, it is
> > not possible to use START TRANSACTION within a PL/PgSQL function. What
> > I, however, do
Thanks I've been trying to use pam_ldap but I keep getting this error
from postgres. I think it may have something to do with postgres
running as the postgres user and not having permissions to something,
but I have no idea what.
LOG: pam_authenticate failed: Conversation error
FATAL: PAM
http://pgfoundry.org/projects/pgmemcache/
We'd like to use pgmemcache with PG 8.2. The memcached version doesn't
matter much (1.2.x is current, 1.1.x would be fine as well).
It fails to build against 8.2 with various errors. The project seems
unmaintained and I failed to get any answer from t
Hi Jeff !
thanks for your help
The slow part is (I think) the reception part. The connection speed is
excellent. The problem does not come from ODBC driver.
I tried to do my request (select * from ...) with the psql.exe tool and
I have the same result : more than 10 seconds to get the request
resu
"hubert depesz lubaczewski" wrote:
> could you please show the configure options (shared buffers, work mem, and
> maintenance_work_mem), plus; what os you are running and on what
> architecture? i.e. 32bit? 64bit? xeon?
Thank you for your response, Hubert. Here is the info:
shared_buffers = 57344
Hi Im engineering a PG database with my workmate.
Unfortunately the inheritance feature seems not to be able to solve my problem.
I have a table "order" with an orderID, each order has 1 to n types of
articles, like services and supply articles with the same PK.
The PK is order_number and positio
Hi,
I'm trying to set up a trigger to prevent any duplicate entries into
my table. But I couldn't figure out how to make my trigger work.
I have a PostgreSQL 8.1.5 installation.
I created the following table:
CREATE TABLE attendance (
attendance_id serial,
service_date timestam
I think Postgres has to be installed as a service. Seems as if what you are
looking for is more of an embeddable solution in which the libraries can
move with the app per se.
Johann.
"Bob Pawley" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I've already built the PostgreSQL da
2006/12/18, Jeff Davis <[EMAIL PROTECTED]>:
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_tabl
Erik Jones wrote:
> 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 day
Csaba Nagy wrote:
- One might have *two* consumers, one that will only process small
tables, so that those little, frequently updated tables can get
handled quickly, and another consumer that does larger tables.
Or perhaps that knows that it's fine, between 04:00 and 09:00 UTC,
to have
Magnus Hagander wrote:
But seriously, I'm definitly interested in ways it can be improved - and
that's true of the whole web team, I'm sure. It was just my way of
saying "it will take a while", but I'll file it away as a good thing to
do when there is a moment of spare time.
I like the way the
> At no point did you show us details, but I suppose that this rule is
> relying on a join view?
Yes, the view is a join between two tables as a test case. I provided the
details of my test case
below. However, I could see the use of joining as many as four tables in an
updatable view.
> On
1 - 100 of 135 matches
Mail list logo