Re: [ADMIN] deadlock detected during insert

2003-03-06 Thread Stephan Szabo
On Fri, 7 Mar 2003, A.Bhuvaneswaran wrote: > > > If you're using foreign keys on the table that you're inserting into it's > > possible that it's waiting on another transaction doing an insert to the > > same key or on a change to the referenced table. > > Can you able to give some test cases? He

Re: [ADMIN] deadlock detected during insert

2003-03-06 Thread A.Bhuvaneswaran
> If you're using foreign keys on the table that you're inserting into it's > possible that it's waiting on another transaction doing an insert to the > same key or on a change to the referenced table. Can you able to give some test cases? Here i have tried, but unable to detect deadlock. BTW

Re: [ADMIN] New Interface for Win

2003-03-06 Thread Mr.F
Thanks for your support specially for publishing PDAdmin to the posgresql users. Please send me email if you have any idea or advice to make it better.   Regards, Fadjar Hamidi   Another URL to download: http://www.geocities.com/fadjarh     -Original Message- From: [EMAIL

[ADMIN] Funny questions...

2003-03-06 Thread Douglas Mayle
I'm trying to upgrade a Postgres 7.0.3 database to something current, and the new version spits out an error when I try and import the data file, complaining that 'invalid' is no longer supported as a timestamp. The funny thing is, when I try and run a query in psql like "select * from myt

Re: [ADMIN] deadlock detected during insert

2003-03-06 Thread Stephan Szabo
On Thu, 6 Mar 2003, A.Bhuvaneswaran wrote: > Hi, > > I am using pgsql 7.2.3 on redhat linux 7.3. > > I am facing the deadlock detected error in transaction during insert > command. How can i fix this? If you're using foreign keys on the table that you're inserting into it's possible that it's wa

[ADMIN] \df command.

2003-03-06 Thread Rajesh Kumar Mallah
\df in any particular schema lists all functions not just from that schema . is it really so or am i doing anything stupid? -- Regds Mallah Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (2

[ADMIN] New Interface for Win

2003-03-06 Thread Mr.F
Hi all,   After two month we have been migrating from Ms-Sql Server 7 to PosgreSQL 7.3, we also build new interface to connect from client in Win base to Posgresql and it call “PDAdmin”. PDAdmin is a Posgresql tools to help Database Administrator (DBA) for a make a Trigger, Function, or R