[ADMIN] New Interface for Win
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 Rule quickly because the User just could input the parameters that important only and then the program will perform frame program automatically and can generate script Trigger/Function/Rule from posgresql database just click in table or schema. PDAdmin be make by concept and method difference by data tools for same PosgreSQL like PgAdmin, because first concept this program to help DBA for beginner or advance (in my team) to make transactional script to be use in PosgreSQL Version 7.3 like Trigger, Function or Rule easily, quick and flexible with show capability the editor. Now, we wishful to share “PDAdmin version 1.0.5” in this milist “FREE” Other features: -. Connection to PosgreSQL server without ODBC -. Update condition of trigger with choice checkbox or radio button. -. Available Database Explorer -. Shortcut to general function PostreSQL -. User define shortcut -. Block Execute Command -. Block Increase/Decrease Indent -. Export Trigger/Function/Rule from database to file -. Import data from Ms-Sql Server -. Freeware, No Limit, No Ads. Requirements: -. Windows 95/98/Me/NT/2000/XP -. File Size 1150Kb -. Uninstaller Included: Yes -. Recommended: PosgreSQL 7.3.x Download: http://www.csahome.com/download/PDAdmin/PDASetup.exe Screenshot: http://www.csahome.com/download/PDAdmin/pdadmin1.jpg Regards, Fadjar Hamidi
Re: [ADMIN] deadlock detected during insert
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 waiting on another transaction doing an insert to the same key or on a change to the referenced table. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] \df command.
\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 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] Funny questions...
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 mytable where mydate = 'invalid'" nothing is returned. When I run a query like "select mydate from mytable where myprimarykey = 5" I get : mydate invalid (1 row) How can I either update these values with a query, or get the upgrade to work? Doug
Re: [ADMIN] New Interface for Win
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 PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aspire Something Sent: 07 Maret 2003 12:33 To: php-db; PG Performance; pgsql-novice; Pg Admin Subject: Re: [ADMIN] New Interface for Win Hi all PostgreSQL users, I would recomend PDAdmin. It's a great tool for windows user it has, 1. Good interface 2. Support for Creating functions and Trgers and MORE >>> What it avoid is the dirty interface of PGadmin2 It's nearly equivilant to the EMS Postgresql Tool. Give it a try V Kashyap
Re: [ADMIN] deadlock detected during insert
> 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, do we have any link about deadlock detection during insert command as we have for update command? regards, bhuvaneswaran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] deadlock detected during insert
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? Here i have tried, but unable to > detect deadlock. Not a complete or tested example, but: create table a (a int primary key); create table b ( b int references a); insert into a values (1); insert into a values (2); Transaction 1: begin; Transaction 2: begin; Transaction 1: insert into b values (1); Transaction 2: insert into b values (2); Transaction 1: insert into b values (2); Transaction 2: insert into b values (1); - This really shouldn't be a deadlock, but given the locking level the foreign keys currently use I'm pretty sure it'd cause one. > BTW, do we have any link about deadlock detection during insert command as > we have for update command? Not sure really. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
