On Wed, 2010-09-29 at 21:57 -0500, Karl Denninger wrote:
> That's actually ok - the update itself is a legitimate statement on the
> master, posted to that table on a reply, and is part of a transaction.
Even if it's part of a transaction, you still have a race condition,
unless you're using a ser
Rob Sargent writes:
> echo "#define SYSCONFDIR \"/opt/PostgreSQL/9.0/etc/postgresql\""
SYSCONFDIR is a place where you might choose to put some handmade
configuration files, but the standard installation doesn't put anything
there. So offhand I don't see a reason why it should create the
dir
On 9/29/2010 8:55 PM, Jeff Davis wrote:
> On Wed, 2010-09-29 at 20:04 -0500, Karl Denninger wrote:
>> Sep 29 19:58:54 dbms2 postgres[8564]: [2-2] STATEMENT: update post set
>> views = (select views from post where number='116763' and toppost='1') +
>> 1 where number='116763' and toppost='1'
>> Se
Dianne Yumul writes:
> We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
> use OIDs to identify a row. I'm planning on adding a serial column to the
> tables and modifying the code to use the serial column instead. But I am
> curious to find out how close we are bef
The log from make shows
echo "#define PGBINDIR \"/opt/PostgreSQL/9.0/bin\"" >pg_config_paths.h
echo "#define PGSHAREDIR \"/opt/PostgreSQL/9.0/share/postgresql\""
>>pg_config_paths.h
echo "#define SYSCONFDIR \"/opt/PostgreSQL/9.0/etc/postgresql\""
>>pg_config_paths.h
echo "#
On Wed, 2010-09-29 at 20:04 -0500, Karl Denninger wrote:
> Sep 29 19:58:54 dbms2 postgres[8564]: [2-2] STATEMENT: update post set
> views = (select views from post where number='116763' and toppost='1') +
> 1 where number='116763' and toppost='1'
> Sep 29 20:01:11 dbms2 postgres[8581]: [2-1] ERROR
I am playing with the replication on 9.0 and running into the following.
I have a primary that is running at a colo, and is replicated down to a
secondary here using SLONY. This is working normally.
I decided to set up a replication of the SLONY secondary onto my
"sandbox" machine to see what I
On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J
wrote:
> Hello,
>
> I’ve installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and
> I’m trying to install the temporal extension module available in
> pg_Foundry. One problem I can see that I’m running into is that the path
> defined fo
Hello,
I've installed the PostgreSQL 9.0 binary package for Windows XP 32-bit
and I'm trying to install the temporal extension module available in
pg_Foundry. One problem I can see that I'm running into is that the
path defined for PGXS in pg_config does not exist:
PGXS = c:/program files/Postgr
On Wed, Sep 29, 2010 at 02:23:14PM -0700, Joshua D. Drake wrote:
- > Howdy,
- >
- > Does anyone know of any tools or methods to handle centralized user
management within postgres?
- >
- > I've got about 20 DB servers (and growing) each requiring a different
number and level of user access
- >
On Wed, 2010-09-29 at 14:21 -0700, David Kerr wrote:
> Howdy,
>
> Does anyone know of any tools or methods to handle centralized user
> management within postgres?
>
> I've got about 20 DB servers (and growing) each requiring a different number
> and level of user access
> (think dev, qa, stag
Howdy,
Does anyone know of any tools or methods to handle centralized user management
within postgres?
I've got about 20 DB servers (and growing) each requiring a different number
and level of user access
(think dev, qa, staging, production, etc.)
Corporate security guidelines state that all
Hello everyone,
We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
use OIDs to identify a row. I'm planning on adding a serial column to the
tables and modifying the code to use the serial column instead. But I am
curious to find out how close we are before the OID w
On 29 September 2010 20:02, Tom Lane wrote:
> Peter Bex writes:
>> On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
>>> Okay, I understand what's happening. But does the planner need to
>>> understand the type of literals in the select list if it's not used
>>> anywhere else?
>
>> Fie
Peter Bex writes:
> On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
>> Okay, I understand what's happening. But does the planner need to
>> understand the type of literals in the select list if it's not used
>> anywhere else?
> Fields sent back to the client also carry their type wit
Are there any commands to see the created index info?
For example, if I have a table A (has 100,000 tuples )with index A_INDEX,
how to see the A_INDEX info, such as the deep of B+ tree?
peng
On 29 September 2010 19:41, Peter Bex wrote:
> On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
>> Okay, I understand what's happening. But does the planner need to
>> understand the type of literals in the select list if it's not used
>> anywhere else?
>
> Fields sent back to the clie
On Wed, Sep 29, 2010 at 07:33:53PM +0100, Thom Brown wrote:
> Okay, I understand what's happening. But does the planner need to
> understand the type of literals in the select list if it's not used
> anywhere else?
Fields sent back to the client also carry their type with them.
There's no "unknow
On 09/25/2010 07:03 AM, Tom Lane wrote:
rey writes:
Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
regards, tom lane
I agree that that multi-character (or eve
On 29 September 2010 19:15, Peter Bex wrote:
> On Wed, Sep 29, 2010 at 07:08:22PM +0100, Thom Brown wrote:
>> Could someone explain why the following doesn't work?
>>
>> test=# PREPARE meow(unknown) AS
>> test-# SELECT $1 as meow;
>> ERROR: could not determine data type of parameter $1
>>
>> The
On Wed, Sep 29, 2010 at 07:08:22PM +0100, Thom Brown wrote:
> Could someone explain why the following doesn't work?
>
> test=# PREPARE meow(unknown) AS
> test-# SELECT $1 as meow;
> ERROR: could not determine data type of parameter $1
>
> The problem is that using PDO in PHP, prepared statements
On 09/29/2010 12:10 PM, Oleg Bartunov wrote:
Christian,
On Wed, 29 Sep 2010, Christian Ramseyer wrote:
Hi List
I have a largish partitioned table, it has ~60 million records in each
of 12 partitions. It appears that a Full Text Index could speed up
some user queries a lot.
A quick test with
Could someone explain why the following doesn't work?
test=# PREPARE meow(unknown) AS
test-# SELECT $1 as meow;
ERROR: could not determine data type of parameter $1
The problem is that using PDO in PHP, prepared statements aren't
possible if values are used instead of columns in the select list.
On 29 Sep 2010, at 18:31, Henri De Feraudy wrote:
> I mean, if you are inserting into a table from PLPGSQL do you have to do an
> explicit commit at some stage?
I suppose you meant psql here, as otherwise the above statement wouldn't make
sense ;)
Alban Hertroys
--
Screwing up is an excellent
On Wed, Sep 29, 2010 at 12:38 PM, Andy Colson wrote:
> On 9/29/2010 11:31 AM, Henri De Feraudy wrote:
>>
>> Hello,
>> I've been writing an application that allows me to edit simple maps. It
>> involves Postgis but here I think I have run into
>> a basic Postgres consideration.
>> I did a bit of ed
On 9/29/2010 11:31 AM, Henri De Feraudy wrote:
Hello,
I've been writing an application that allows me to edit simple maps. It
involves Postgis but here I think I have run into
a basic Postgres consideration.
I did a bit of editing of a map which involved creating a polygon with a
selection, inser
Hello,
I've been writing an application that allows me to edit simple maps. It
involves Postgis but here I think I have run into
a basic Postgres consideration.
I did a bit of editing of a map which involved creating a polygon with a
selection, inserting into a database and reloading
the "lay
2010/9/29 Tom Lane :
> =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
>> I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
>> Basically , assuming that psql doesn't show me that FKs are disabled
>> some code was using 'trigger all' instead of 'user'.
>
> I think that is toda
If I run the admin tool from my postgres account, that works fine since
postgres is the owner.
> Cc: pgsql-general@postgresql.org
> Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0
>
>> Thanks for the fast reply. I must have still been connected to the older
>> database som
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
> I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
> Basically , assuming that psql doesn't show me that FKs are disabled
> some code was using 'trigger all' instead of 'user'.
I think that is today's lesson in why not to work
Where would I type 'show hba_file'? I'm on Mac. Also I downloaded the
distribution from postgresql.org. If I run an initdb and I already restored a
database, will it put the pg_hba.conf file in the 'data' folder?
> Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0
>
> Adam
Adam Wizon writes:
> Thanks for the fast reply. I must have still been connected to the older
> database somehow. I cleaned up my installation and restored the database.
> No error messages this time. I need to change the pg_hba.conf file. I read
> the documentation and its supposed to be
I got bitten Today by 'alter table disable trigger all' vs 'trigger user'.
Basically , assuming that psql doesn't show me that FKs are disabled
some code was using 'trigger all' instead of 'user'.
Is that a bug of psql, or a feature ? As far as I can see
pg_catalog.pg_constraint doesn't contain in
On Wed, Sep 29, 2010 at 5:22 AM, wrote:
> Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
> replication provider (Master) and receiver (client) at the same time?
>
You can implement such a replication using Slony-1.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Use JOIN sherlock.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I have this query
SELECT
*
FROM
v_material
WHERE
show_in_recent AND section_id IN (
SELECT
s.id
FROM
section AS s, section AS s2
WHERE
s2.id = 842
AND
s.breadcrumb <@ s2.breadcrumb
)
ORDER BY
published_on DESC
LIMIT 3;
On Wed, Sep 29, 2010 at 11:37 AM, Andrus wrote:
>> We updated it for Win64, but it looks like the stackbuilder catalog
>> wasn't updated to allow it to be downloaded on that platform. I've
>> fixed that - it should be available within an hour or so.
>
> I just installed 9.0 x64
>
> Is it sufficien
We updated it for Win64, but it looks like the stackbuilder catalog
wasn't updated to allow it to be downloaded on that platform. I've
fixed that - it should be available within an hour or so.
I just installed 9.0 x64
Is it sufficient to run Program files / PostgreSql 9.0 / Application Stack
B
2010/9/29 Andrus :
> I installed PostgreSql 9.0 Win 64 standard distro.
>
> Stack builder offered in end of installation does not contain
> postgresql.conf optimization wizard.
>
We updated it for Win64, but it looks like the stackbuilder catalog
wasn't updated to allow it to be downloaded on that
2010/9/29 Andrus :
> I installed PostgreSql 9.0 Win 64 standard distro.
>
> Stack builder offered in end of installation does not contain
> postgresql.conf optimization wizard.
>
> How to optimize postgresql.conf for 64 bit dedicated postgresql windows
> 2003 server or is default .conf file best f
> In pl/pgsql at any rate, functions which return a set of rows build up
> the entire result set in memory and then return the set in one go:
Ok, then pl/pgsql and pl/python (which can't return SETOF) are ruled out.
(Thank you for pointing that out).
But pl/perl seems to do the trick:
"PL/Per
I installed PostgreSql 9.0 Win 64 standard distro.
Stack builder offered in end of installation does not contain
postgresql.conf optimization wizard.
How to optimize postgresql.conf for 64 bit dedicated postgresql windows
2003 server or is default .conf file best for this?
Andrus.
--
S
Christian,
On Wed, 29 Sep 2010, Christian Ramseyer wrote:
Hi List
I have a largish partitioned table, it has ~60 million records in each of 12
partitions. It appears that a Full Text Index could speed up some user
queries a lot.
A quick test with an additional tsvector column revealed that
On 29/09/2010 10:52, Leonardo Francalanci wrote:
Hi,
I need to generate aggregates of data coming from a stream.
I could easily doing it inserting data coming from the stream into a table,
and then query it using something like:
select from atable group by
The problem with this approach is
Hi,
I need to generate aggregates of data coming from a stream.
I could easily doing it inserting data coming from the stream into a table,
and then query it using something like:
select from atable group by
The problem with this approach is that I would have to wait for the whole
stream to
On 29 September 2010 10:22, wrote:
> Hello List,
>
> a lot of recherche and no answer so far. So my question to you:
>
> Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
> replication provider (Master) and receiver (client) at the same time?
>
> Can i configure both to
> * accept
no you can't
but you have have multiple clusters running at the same time on the
same box. Just set them up on different ports, and in different
directories.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
Hello List,
a lot of recherche and no answer so far. So my question to you:
Is it possible to set up ONE PostgreSQL 9 to serve as a streaming
replication provider (Master) and receiver (client) at the same time?
Can i configure both to
* accept 'insert into ...' & stream that changes out (usual
On Tue, Sep 28, 2010 at 7:46 PM, Scott Ribe wrote:
> On Sep 28, 2010, at 11:50 AM, Dave Page wrote:
>
>> You're welcome. I guess it is running the 64bit image - is your
>> machine Leopard Server?
>
> That's irrelevant. The 32-bit vs 64-bit default is for the kernel and
> extensions, not for appli
On 8 September 2010 21:48, Thom Brown wrote:
> Hi,
>
> I noticed that if I run this:
>
> SELECT alias, description, token FROM
> ts_debug('http://www.postgresql.org:2345/directory/page.html?version=9.1&build=alpha1#summary');
>
> I get:
>
> alias | description | t
50 matches
Mail list logo
