I have a function that deletes all the values in a table and then
inserts the data again. If this function is run in 2 sessions at the
same time then it populates it twice, giving me a unique value error,
because one of the fields is supposed to be unique.
I understand this because the second ti
On Sat, Sep 16, 2006 at 03:53:04PM +0200, Michelle Konzack wrote:
> Since I have no Internet access @home anymore, I want to install
> my PostgreSQL in one of the patitions I have created. To do this,
> I want to compile it static, so that it does not need any system
> libraries.
> So, how can
On Sun, Sep 17, 2006 at 10:32:12AM +0200, Sim Zacks wrote:
> I have a function that deletes all the values in a table and then
> inserts the data again. If this function is run in 2 sessions at the
> same time then it populates it twice, giving me a unique value error,
> because one of the field
This function, when run in 2 separate sessions at the same time, causes a duplicate key error
because popartid is a primary key. This makes sense to me. When the function is run in the second
session it doesn't know about the transaction currently running in the first session. Therefore,
when it
You forgot to mention that all the functions/views that utilized that table also now point to the
original table with the changed name, because it doesn't store the table name, it stores the table oid.
Berend Tober wrote:
A. Kretschmer wrote:
am Wed, dem 13.09.2006, um 15:46:58 -0700 mailte
Sim Zacks <[EMAIL PROTECTED]> writes:
> This function, when run in 2 separate sessions at the same time,
> causes a duplicate key error because popartid is a primary key.
> ...
> The next one is a bit longer. I would expect that if it was run in 2
> separate sessions that 1) it would generate the s
Has anybody had success installing PostgreSQL into Windows Vista (starter)?
---(end of broadcast)---
TIP 6: explain analyze is your friend
> I've
> never used a hammer to put in a screw.
So I guess you're one of those ivory-tower theory-purist academic types, at
least when it comes to home repairs. As a more practical person myself, let
me just say that sometimes a 3lb hammer is exactly the right tool to get a
screw set in quickly ;
On Fri, 2006-09-15 at 09:38 -0700, Joshua D. Drake wrote:
> Hello,
Hi Joshua,
> Yeah, this is a cross post and it is slightly off topic but IMHO this is
> important.
>
> Tomorrow one of our own, Devrim Gunduz is becoming a man. He is sucking
> it up, and committing to the cvs repo of project m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/17/06 16:34, Scott Ribe wrote:
>> I've never used a hammer to put in a screw.
>
> So I guess you're one of those ivory-tower theory-purist academic
> types, at least when it comes to home repairs. As a more
> practical person myself, let me just
On 9/15/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Hello,
Yeah, this is a cross post and it is slightly off topic but IMHO this is
important.
Tomorrow one of our own, Devrim Gunduz is becoming a man. He is sucking
it up, and committing to the cvs repo of project marriage.
May the patches r
Scott Ribe wrote:
I've
never used a hammer to put in a screw.
So I guess you're one of those ivory-tower theory-purist academic types, at
least when it comes to home repairs. As a more practical person myself, let
me just say that sometimes a 3lb hammer is exactly the right tool to get a
screw
A case in point:
When it comes to driving a screw into a material (like wood) in which
the screw creates the mating helix itself when first driven in, you
might find it helpful to hammer a small portion of the screw into the
receiving part, so the screw "gets an initial hold". It is much easie
As a comment on his points though, isn't it better to use the right tool
for the job rather than try to force one tool to do everything? I've
never used a hammer to put in a screw.
You haven't?
All right-minded people know that PostgreSQL is manifestly superior
and that people who want to us
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/17/06 20:07, Tim Allen wrote:
>>> As a comment on his points though, isn't it better to use the right
>>> tool for the job rather than try to force one tool to do everything?
>>> I've never used a hammer to put in a screw.
>>
>> You haven't?
>>
On 9/15/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Tomorrow one of our own, Devrim Gunduz is becoming a man. He is sucking
it up, and committing to the cvs repo of project marriage.
Congratulations Devrim!
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporatio
I have to update a database system and need some advice.
Most of the database work I've done up to now has been databased backed
websites, using perl and/or php to connect to mSQL, mySQL, or postgreSQL.
One job that I inherited a few years ago was actually two separate
databases, one an in-offic
[EMAIL PROTECTED] writes:
> ... My biggest concern is the existing FileMakerPro clients. How much work
> would it be to connect the existing FMP clients to the postgreSQL database
> using ODBC? Is this a viable temporary step or could it be permanent?
If they can speak ODBC, then in theory you c
On Mon, Sep 18, 2006 at 12:29:56AM +0300, Enver ALTIN wrote:
> On Fri, 2006-09-15 at 09:38 -0700, Joshua D. Drake wrote:
> > Hello,
>
> Hi Joshua,
>
> > Yeah, this is a cross post and it is slightly off topic but IMHO this is
> > important.
> >
> > Tomorrow one of our own, Devrim Gunduz is beco
Yes filemaker can use ODBC but not as a live data source as you would use
access as a frontend. You can use ODBC to import the data to a Filemaker
database and display/edit it there and then export back through ODBC.
If they use Filemaker to enter all the data (none is entered from the web
site) t
Hi,
i was searching for a load balancing solution for
postgres, I found some ready to use software like
PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is
the best taking in consideration that i have an
already running application that i need to load
balanc
As I'm waiting for a CLUSTER operation to finish, it occurs to me that in a lot
of cases, the performance benefits to having one's data stored on disk in index
order can outweigh the overhead involved in inserting data on-disk in index
order Just an idea I thought I'd throw out. :)
Also,
> I think the reason you are seeing failures in the first function is
> that the initial DELETE is a no-op so it doesn't serialize anything,
> and then there is conflict when the two INSERTs proceed in parallel.
There is always data in the table that it deletes. So, according to that, with the fi
23 matches
Mail list logo
