On Tue, 2009-06-30 at 17:58 +0200, Rosko C.A. wrote:
Hi. I'm trying to install Postgresql 8.3 in my computer but a windows
appear asking me a password that i no have... If I click next button
no continues... i don't know what can I do. Yesterday I tried to
install pokertracker 3 (the latest
Greetings,
I have a problem with postgresql that connect to a c++ server.
I build some system servers that have connection to a postgresql server.
When i add many object in the database, and the system server going to shoot
the database server with the query. There will be an exception. The
On Thu, Jul 2, 2009 at 2:05 AM, drestajumenadrestajum...@gmail.com wrote:
Greetings,
I have a problem with postgresql that connect to a c++ server.
I build some system servers that have connection to a postgresql server.
When i add many object in the database, and the system server going to
If run the server, the server will be run for several minutes and then the
error will happen. Most of error will held if the server run query : INSERT,
DELETE.
For database server, i use Postgre 8.3.1 on ubuntu 8.10 server.
For system servers, i use standard C++.
I am going to make an MMORPG.
On Thu, Jul 2, 2009 at 2:46 AM, Merrickmerr...@gmail.com wrote:
I was hoping there would be a way to add a field the sequence table
postgresql automatically generates so I could rely on whatever
mechanism postgresql uses to avoid the problems described thus far.
Hm, well you could create a
On Thu, Jul 2, 2009 at 3:28 AM, Greg Starkgsst...@mit.edu wrote:
On Wed, Jul 1, 2009 at 6:01 PM, Scott Marlowescott.marl...@gmail.com wrote:
The simplest method is to do something like:
begin;
select * from sometable where cust_id=99 order by order_id desc for update;
to lock all the
Hi!
Please send me an example (pseudo-code) for Serializable conflict.
And I wanna know, if possible, that if more transactions only read the
tables in Serializable mode, and one or others write to it, can I got some
conflicts in read operation?
c = client t = transaction
c1t1 begin serial
c1t1
Hi all.
I've come across a problem with delete cascade.
I have three tables A, B and C.
Table B has a foreign key on A with delete cascade.
Table C has a foreign key on B with delete cascade.
So, we have this reference chain: C-B-A
All three tables have an 'on delete' trigger.
My problem is,
On Thu, Jul 2, 2009 at 10:35 AM, Scott Marlowescott.marl...@gmail.com wrote:
Actually, since
you're only incrementing from the highest one, you could just lock the
id from a select max(orderid) where custid=xyz and you'd only have to
lock one row.
Not really because you would have a race
Michaël Lemaire wrote:
Hi all.
I've come across a problem with delete cascade.
I have three tables A, B and C.
Table B has a foreign key on A with delete cascade.
Table C has a foreign key on B with delete cascade.
So, we have this reference chain: C-B-A
All three tables have an 'on delete'
On Wed, 2009-07-01 at 16:16 -0500, Anthony Caduto wrote:
I am looking for something similar to:
http://www.arcanadev.com/adtempus/ but without the MS SQL server
dependency.
Thanks,
Tony
http://www.opensymphony.com/quartz/ might fit the bill
--
Sent via pgsql-general mailing list
Richard Huxton d...@archonet.com wrote:
Michaël Lemaire wrote:
Hi all.
I've come across a problem with delete cascade.
I have three tables A, B and C.
Table B has a foreign key on A with delete cascade.
Table C has a foreign key on B with delete cascade.
So, we have this
Michaël Lemaire wrote:
Richard Huxton d...@archonet.com wrote:
Michaël Lemaire wrote:
Hi all.
I've come across a problem with delete cascade.
I have three tables A, B and C.
Table B has a foreign key on A with delete cascade.
Table C has a foreign key on B with delete cascade.
So, we have
2009/7/1 Albe Laurenz laurenz.a...@wien.gv.at
Anderson Valadares wrote:
[this is on Windows, DB is accessed with ODBC driver 8.4.3]
Thanks for the answer ...
But honestly I think that was a misunderstood.
The memory increase issue is showed in the DATA column.
Look how day by
2009/7/1 Merlin Moncure mmonc...@gmail.com:
On Mon, Jun 29, 2009 at 8:14 PM, Anderson Valadaresanderva...@gmail.com
wrote:
Hi all
I have a software developed in Delphi as a Windows Service, but, i don't
know why, it consumns an unexpected large system memory (515m).
The service access
Richard Huxton d...@archonet.com wrote:
Michaël Lemaire wrote:
Richard Huxton d...@archonet.com wrote:
Michaël Lemaire wrote:
Hi all.
I've come across a problem with delete cascade.
I have three tables A, B and C.
Table B has a foreign key on A with delete cascade.
Table C has a
Using th new postgresql 8.4.0 (compiled)
On Ubuntu 8.10
I did an initdb, added a password to the postgres user and then
changed the pg_hba.conf to:
local all all md5
host all all 127.0.0.1/32 md5
Restarted Postgresql.
If I log in normally:
postg...@ben-desktop:~$
On Mon, 2009-06-22 at 17:53 -0400, Gerry Reno wrote:
I noticed that the user survey on the community page does not list
replication among the choices for development priority. For me,
replication is the most important thing that is critically missing from
postgresql. We need something
Good morning.
I am itching to upgrade my 8.3 development database to 8.4 before I move
to production. Pg_migrator is listed as beta so I'd like to avoid that.
Has anyone made the leap yet?
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613)
In response to Ben Trewern ben.trew...@talktalk.net:
Using th new postgresql 8.4.0 (compiled)
On Ubuntu 8.10
I did an initdb, added a password to the postgres user and then
changed the pg_hba.conf to:
local all all md5
host all all 127.0.0.1/32 md5
Restarted
Hartman, Matthew wrote:
Good morning.
I am itching to upgrade my 8.3 development database to 8.4 before I move
to production. Pg_migrator is listed as beta so I'd like to avoid that.
Has anyone made the leap yet?
Just dump/restore with the 8.4 pg_dump/restore if you're still in
On Monday 29 June 2009, fe...@crowfix.com said something like:
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By schema, I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
On Mon, 2009-06-29 at 07:34 -0700, David Fetter wrote:
On Mon, Jun 29, 2009 at 07:11:43PM +0800, Craig Ringer wrote:
On Sun, 2009-06-28 at 09:01 -0700, David Fetter wrote:
Are there any rules of thumb to consider for making an application
easier to work with a general replication
On Tue, 2009-06-30 at 09:27 +0100, Pedro Doria Meunier wrote:
Could someone please tell me why when I click on a cluster pgAdmin
exhibits a dialog stating:
Column not found in pgSet: no_spool ?
- - pgAdmin version 1.10.0 Beta2 rev. 7749
- - Master on a remote server
- - Slony-I not
Hello,
I am wondering if anyone has successfully compiled postgres for 64 bit windows
using mingw64? I tried doing so but the configure step fails with the
following message:
conftest.c:50: error: conflicting types for 'accept'
The config.log file shows the following additional message:
McWilliams, Steven steven_mcwilli...@bmc.com writes:
I am wondering if anyone has successfully compiled postgres for 64 bit
windows using mingw64?
We don't currently support 64-bit builds on Windows. There are a pile
of issues there, most coming from Microsoft's nonstandard decision to
make
I move a compressed pg_dump archives across the wire to a remote
host on a regular schedule. The process completes and the archives
are restored on the remote site and the resulting database performs
as expected.
However, I get this returned to me at the end of each
dump/transfer/restore
I have the following table:
gms= \d jobclock
Table public.jobclock
Column| Type |
Modifiers
Just create a unique constraint on all of the columns.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks Simon,
Actually Dave has already made a patch that overcomes this issue and
it's already been committed!
BR,
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Simon Riggs wrote:
On Tue, 2009-06-30 at 09:27 +0100, Pedro Doria
M == matthew.hart...@krcc.on.ca writes:
M Just create a unique constraint on all of the columns.
Ah. Didn't realize you could specify more than one column as part of
a unique constraint.
Thanks.
--
Brandon
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
In response to Brandon Metcalf bran...@geronimoalloys.com:
I have the following table:
gms= \d jobclock
Table public.jobclock
Column| Type |
Modifiers
w == wmo...@potentialtech.com writes:
...
w Your primary key can span multiple columns, i.e.
w PRIMARY KEY(jobclock_id, employee_id, machine_id)
w Could be more columns.
w Keep in mind that this ensures that the combination of all those
w columns is unique, which may or may not be what
On Thu, 2009-07-02 at 18:30 +0100, Pedro Doria Meunier wrote:
Actually Dave has already made a patch that overcomes this issue and
it's already been committed!
I replied to make sure that everybody knew where to post.
If you post and then solve the problem its best to post again to say its
This is a question about data modeling with inheritance and a way to
circumvent the limitation that primary keys are not inherited.
I'm considering a project to model genomic variants and their associated
phenotypes. (Phenotype is a description of the observable trait, such as
disease or hair
--- On Thu, 7/2/09, Brandon Metcalf bran...@geronimoalloys.com wrote:
From: Brandon Metcalf bran...@geronimoalloys.com
Subject: [GENERAL] simulate multiple primary keys
To: pgsql-general@postgresql.org
Date: Thursday, July 2, 2009, 5:27 PM
I have the following table:
gms= \d jobclock
variant association phenotype
--- --- -
variant_id - variant_id +--- phenotype_id
genome_id phenotype_id -+ short_descr
strand origin_id (i.e., who)
I'm having trouble installing plpython in 8.4. I tried under Windows
(one click installer from EDB) and under Ubuntu (linux binary). In both
cases I was told:
could not load library 8.4/lib/postgresql/plpython.(so|dll)
Both systems have python 2.5 installed. And plpython was working in 8.3
38 matches
Mail list logo