Re: [pgadmin-support] Error Message: ERROR: CREATE USER: permission denied
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ben Trewern > Sent: 22 August 2004 21:21 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Error Message: ERROR: CREATE > USER: permission denied > > I don't think this is a pgAdmin problem. You need to log in > as a superuser account to create a user. The superuser is > usually called postgres in a standard PostgreSQL install > although any user can be made a superuser (See ALTER USER > CREATEUSER). > > Try > > CREATE USER ; > > via psql or the sql window in pgAdmin to see if that does it. Yes, that's good advice. I would like to add that pgAdmin II is no longer actively supported, and the 7.2.1 native port of PostgreSQL that you appear to be using has never been properly tested with pgAdmin (though it *should* be OK). If this is a new project you are working on, you might want to consider upgrading to PostgreSQL 8.0 beta1 (with a view to upgrading to the release version as soon as available), which comes with pgAdmin III if you download the installer build from http://pgfoundry.org/project/showfiles.php?group_id=107. Both are being actively developed and supported. Regards, Dave > >-- Application Information -- > > > >Name: pgAdmin II > >Version: 1.6.0 > >Descripton: > > > >-- Database Information -- > > > >Version: 7.2.1 > >Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, > compiled by msdev > >6.0 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] Error Message: Invalid procedure call or argument
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Somchai BoongerdSent: 23 August 2004 07:25To: [EMAIL PROTECTED]Subject: [pgadmin-support] Error Message: Invalid procedure call or argument Name: PostgreSQLVersion: 7.5.2Descripton: PostgreSQL 8.0.0beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)-- Error Information --Description: Invalid procedure call or argumentNumber: 5Routine: pgAdmin II:frmMain.svServerInsert your comment: pgAdmin III can run ,do not error pgAdmin II will not run on PostgreSQL 8.0 and is no longer being actively supported or maintained. Regards, Dave
[pgadmin-support] Can't create foreign keys
I'm testing pgAdmin III Aug 15 snapshot and have found that you can't add foreign keys. You go to your table of choice then: Properties -> Constraints -> Add -> Pick table in References drop down -> Pick a field in Local column -> No fields show up in Referencing! Regards, Ben _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] Can't create foreign keys
Ben Trewern wrote: I'm testing pgAdmin III Aug 15 snapshot and have found that you can't add foreign keys. You go to your table of choice then: Properties -> Constraints -> Add -> Pick table in References drop down -> Pick a field in Local column -> No fields show up in Referencing! Then the table has no PK and is unsuitable as a referenced table. Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support] Can't create foreign keys
Andreas, 1. The table does have a PK. 2. It used to work in pgAdmin III 1.0.2 3. Could it be that one field is int4 and the other is declared as a serial field? - Just a thought. Ben From: Andreas Pflug <[EMAIL PROTECTED]> To: Ben Trewern <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Can't create foreign keys Date: Mon, 23 Aug 2004 10:23:47 + Ben Trewern wrote: I'm testing pgAdmin III Aug 15 snapshot and have found that you can't add foreign keys. You go to your table of choice then: Properties -> Constraints -> Add -> Pick table in References drop down -> Pick a field in Local column -> No fields show up in Referencing! Then the table has no PK and is unsuitable as a referenced table. Regards, Andreas ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-support] General Question re: PGAdmin III
Hi, I am a new user of open source tools and technologies. I did find your tool interesting and would like to use it on a database that I will be supporting however, I am using a Linux Fedora Core 2 installation. Is there anyone that has made the adaptations so that the product will run in Linux FC2.? I also downloaded and installed the Windows version of the product and things operate properly. Both environments are separate for security reasons so I can't point the windows version at my Linux box where the database resides. I am from the Microsoft SQL 2000 world so if I can get this tool to work it would make life a lot easier. Thanks, Email: [EMAIL PROTECTED]
