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
exce
On Thu, Jul 2, 2009 at 2:05 AM, drestajumena 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 shoot
> the dat
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. S
On Thu, Jul 2, 2009 at 2:46 AM, Merrick 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 sequence for every
On Thu, Jul 2, 2009 at 3:28 AM, Greg Stark wrote:
>> On Wed, Jul 1, 2009 at 6:01 PM, Scott Marlowe 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 customer records for cust
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 s
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, w
On Thu, Jul 2, 2009 at 10:35 AM, Scott Marlowe 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 condition between select
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' t
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
Richard Huxton 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 referen
Michaël Lemaire wrote:
Richard Huxton 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 reference chai
2009/7/1 Albe Laurenz
>
> 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 d
2009/7/1 Merlin Moncure :
> On Mon, Jun 29, 2009 at 8:14 PM, Anderson Valadares
> 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 PostgresSQL by ODBC driver (psqlo
Richard Huxton wrote:
> Michaël Lemaire wrote:
> > Richard Huxton 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:~$ psq
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 somethin
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) 549-66
In response to Ben Trewern :
> 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.
>
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
developmen
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,
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" repli
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 n
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:
c:
"McWilliams, Steven" 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 sizeof(long) != sizeof(p
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
pg_re
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 Me
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 chan
In response to Brandon Metcalf :
> 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 wha
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 colo
--- On Thu, 7/2/09, Brandon Metcalf wrote:
> From: Brandon Metcalf
> 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
(a
38 matches
Mail list logo
