On Jan 2, 2007, at 10:34 PM, Mark Harrison wrote:
I have a cluster of CPUs generating thumbnails for
a render farm. I would like to place thumbnail
requests on a queue, and have the cluster of client
dequeue the requests and process them.
Of course, each request should be only dequeued once..
I have a cluster of CPUs generating thumbnails for
a render farm. I would like to place thumbnail
requests on a queue, and have the cluster of client
dequeue the requests and process them.
Of course, each request should be only dequeued once...
if a thumbnail is being processed by one CPU, it
sh
Whew, python lang support just installed for me too.
After reading more, it seems that while there is some broken dependency re
DWMAPI.dll on windowsxp systems, it does not affect most programs.
DWMAPI.dll is shown as missing by 'depends' but that exposes delay-loaded
problems that may have littl
On Monday 01 January 2007 6:24 pm, novnov wrote:
> Thanks, the depends tools looks very handy, surprising I'd not heard of it
> before.
>
> I found that the postgresql\bin dir must be added to the path.
>
> Also, I had python 2.5 installed, and plpython apparently needs python 2.4.
> I've installed
OK, well accepting data loss (even if it is "just" 6-12 hours worth)
really opens up a lot of possibilities.. EXCEPT that you also said you
want both sites to be able to modify data. Again, there is no real
multi-master replication available for postgres, so you'll have to have
both sites a
Bruno Wolff III wrote:
On Tue, Jan 02, 2007 at 12:33:14 -0700,
Anthony Masinton <[EMAIL PROTECTED]> wrote:
I would like to combine data from different rows in one column into
one row.
...
Is this possible and if so, how?
Collapsing rows is done with aggregate functions. You c
On Tue, Jan 02, 2007 at 12:33:14 -0700,
Anthony Masinton <[EMAIL PROTECTED]> wrote:
> I would like to combine data from different rows in one column into
> one row.
>
> I have two tables: 'locations' containing a dozen records about
> cities and their geographic coodinates - the other table,
Anthony Masinton wrote:
I would like to combine data from different rows in one column into one
row.
I have two tables: 'locations' containing a dozen records about cities
and their geographic coodinates - the other table,'testators', contains
several hundred records referring to wills (each
I would like to combine data from different rows in one column into
one row.
I have two tables: 'locations' containing a dozen records about
cities and their geographic coodinates - the other table,'testators',
contains several hundred records referring to wills (each will is
given a uniq
On Sat, 30 Dec 2006, Dennis wrote:
I was thinking of maybe just having 2nd location receive a PG dump (full
or incremental) every so often (an hour to 6 hours) and if the main
location fails majorly, restore the PG cluster from the dump and switch
DNS settings on the actual sites. I can make s
Clodoaldo <[EMAIL PROTECTED]> writes:
> Where can I find the 8.2.1 release notes?
They don't exist yet. You can dig through the pgsql-committers archives
if you want to get an idea of what will be in them.
regards, tom lane
---(end of broadcast)--
Seneca Cunningham <[EMAIL PROTECTED]> writes:
> No, I've only dealt with 10.4. From what I've read Apple changes shm
> configuration methods every couple 10.X or so.
Yeah, they've changed the behavior at least three times :-(. According
to our notes at
http://www.postgresql.org/docs/8.2/static/k
2007/1/2, Tom Lane <[EMAIL PROTECTED]>:
Vlad <[EMAIL PROTECTED]> writes:
> To be on the safe side I wanted to wait till 8.2.1 though - is there
> any estimate for the release date?
Real soon, possibly next week. The core committee is just now trying
to agree on the release date...
Where can
On Tue, Jan 02, 2007 at 10:12:56AM -0700, Scott Ribe wrote:
> > /etc/rc is what causes the values from /etc/sysctl.conf to be read in
> > and used. Some values, such as the shm-related values are specified in
> > the default /etc/rc after /etc/sysctl.conf is parsed up by /etc/rc and
> > applied, b
Vlad <[EMAIL PROTECTED]> writes:
> To be on the safe side I wanted to wait till 8.2.1 though - is there
> any estimate for the release date?
Real soon, possibly next week. The core committee is just now trying
to agree on the release date...
regards, tom lane
---
On Tue, 2007-01-02 at 10:53 -0600, Vlad wrote:
> Hello,
>
> with the switch to 8.2 I see a significant performance increase in
> generating complex reports (something we need badly), so was thinking
> about upgrading our production db to 8.2.
>
> To be on the safe side I wanted to wait till 8.2.1
> /etc/rc is what causes the values from /etc/sysctl.conf to be read in
> and used. Some values, such as the shm-related values are specified in
> the default /etc/rc after /etc/sysctl.conf is parsed up by /etc/rc and
> applied, but in 10.4 the kern.sysv.shm* values can only be set once.
Do you k
On Tue, Jan 02, 2007 at 02:37:59 +0200,
Andrus <[EMAIL PROTECTED]> wrote:
>
> Also Tom Lane strongly recommends using VARCHAR always and never use CHAR
> columns.
If you just want to use Postgres, you might want to use 'text' instead of
'varchar', since you don't need to specify arbitrarylimit
Hello,
with the switch to 8.2 I see a significant performance increase in
generating complex reports (something we need badly), so was thinking
about upgrading our production db to 8.2.
To be on the safe side I wanted to wait till 8.2.1 though - is there
any estimate for the release date?
--
Vl
Andrus wrote:
I have CHAR columns in database in 500 tables. There are currently no
VARCHAR columns.
My C# application receives character data with trailing spaces from npgsql.
Yep - that's what CHAR is for.
This makes application code complicated. Application must remove trailing
spaces fr
On mán, 2007-01-01 at 21:21 -0800, Yesh wrote:
> I need to know how to increment a primary key field automatically in run
> time.
Will SERIAL do what you want?
gnari
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
Yesh wrote:
Hi,
I need to know how to increment a primary key field automatically in run
time.
If you use the "serial" data type, the database does this for you
automatically and you don't have to worry about it.
Is this the data type your using?
--
James Neff
Technology Specialist
T
On 1 Jan 2007 at 21:21, Yesh wrote:
> I need to know how to increment a primary key field automatically in
> run time.
Use type SERIAL as your primary key - here is the relevant page in
the docs:
http://www.postgresql.org/docs/8.2/static/datatype-
numeric.html#DATATYPE-SERIAL
HTH,
--Ray.
-
On 30 Dec 2006 at 0:22, Dennis wrote:
> I was thinking of maybe just having 2nd location receive a PG dump
> (full or incremental) every so often (an hour to 6 hours) and if the
Just curious - how do you do an incremental dump? I had to do
something similar recently, and ended up effectively rol
Yesh wrote:
Hi,
I need to know how to increment a primary key field automatically in run
time.
Not sure precisely what you want to know, but read up on the SERIAL
type, sequences, nextval() and currval().
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
I was thinking of maybe just having 2nd location receive a PG dump (full or
incremental) every so often (an hour to 6 hours) and if the main location fails
majorly, restore the PG cluster from the dump and switch DNS settings on the
actual sites. I can make sure all website files are always in s
Is it possible to get the names of the schema and function within a
plpgsql function?
It is possible to get this information inside a trigger using
TG_TABLE_SCHEMA and TG_TABLE_NAME. I would like to get these values
inside every function I write to display in all error messages.
Regards
Ken
---
I have CHAR columns in database in 500 tables. There are currently no
VARCHAR columns.
My C# application receives character data with trailing spaces from npgsql.
This makes application code complicated. Application must remove trailing
spaces from incoming data for C# string manipulation to wo
Hi Dave
I can get the restore working if I dump the project spelling out "*.backup"
and not relying on the default.
However the restore is being aborted due to a pk error for the spatial
coordinates. I've removed the gis feature from both applications but still
get the error.
Any thoughts
Hi,
I need to know how to increment a primary key field automatically in run
time.
--
View this message in context:
http://www.nabble.com/About-auto_increment-tf2906530.html#a8120183
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of b
Hi,
I've just installed postgres 8.2.0-1 for win32 and wanted to try out the
built-in LDAP support(with Openldap and Novell eDirectory).
The following LDAP authentication was added to "pg_hba.conf" :
Openldap:
host all all 127.0.0.1/32 ldap
ldap://localhost/dc=d
- Yes, both sites have to be online and changing data at the same time.
- data loss is unacceptable
- platform is Gentoo Linux
- downtime of up to 1 day is acceptable as long as there is no data loss
- throughput latency -> internet over 10megabit line
Ben <[EMAIL PROTECTED]> wrote: Sure, there a
Ron Peterson <[EMAIL PROTECTED]> writes:
>> Sorry, I don't believe 8.1 took it either.
> Hmm, my test table fails in 8.1.4 also, but my actual use case works in
> 8.1.4 but not 8.2.
You haven't shown us exactly what that C function is doing, but my
interpretation of that is that 8.1 failed to che
On Mon, Jan 01, 2007 at 11:30:00PM -0500, Tom Lane wrote:
> Ron Peterson <[EMAIL PROTECTED]> writes:
> > I believe there's been a change in PostgreSQL's regular expression
> > handling w/ 8.2.
>
> Compared to what? A repeat count of 256 has been an error at least
> since 7.4, and is documented as
Benjamin Arai wrote:
> Just to make things more clear I ran EXPLAIN ANALYZE on the slow query.
> I got
> -> Index Scan using mutualfd_weekday_qbid_pkey_idx on
> mutualfd_weekday_qbid (cost=0.00..6.01 rows=1 width=19) (actual
> time=34.579..8510.801 rows=253 loops=1)
> Index Cond: ((pk
Bob Pawley wrote:
Following is the error message on pg_restore:-
"pg_restore: ERROR: duplicate key violates unique constraint
"spatial_ref_sys_pkey"
CONTEXT: COPY spatial_ref_sys, line 1: "2000 EPSG 2000 PROJCS["Anguilla
1957 / British West Indies Grid",GEOGCS["Anguilla 1957",DATUM["Angui...
Andrus wrote:
Why MS SQL server and Oracle does not have this issue and implement
ContinueUpdateOnError fast ?
Is this issue caused by PostgreSQL design failure ?
Design decision. An error in a transaction renders that transaction
incomplete. If it's incomplete then it can't be committed. Ot
Reece Hart wrote:
> On Thu, 2006-12-28 at 19:09 +0700, Akbar wrote:
> Note the 'all' after union... I suspect you'll want that or should at
> least consider it.
Not using it will give the exact same results in a slower way; 'blue'
and 'red' are different, after all. You'll be hard pressed to find
John Cohorn wrote:
It seems to me that all information about acceptable values, constraints
and
types for columns is already present within the table definitions so
duplicating those checks and definitions within the application and user
view is folly.
Well, there I'd disagree with you. With a
39 matches
Mail list logo
