Re: [pgadmin-support] Error adding new column to existing table.

2004-09-17 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted TaylorSent: 16 September 2004 21:51To: [EMAIL PROTECTED]Subject: [pgadmin-support] Error adding new column to existing table. Short version: using the “Add Column” GUI on an existing table puts d

Re: [pgadmin-support] Data insert & column name problems

2004-09-17 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Michal Unzeitig > Sent: 16 September 2004 13:47 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Data insert & column name problems > > PgAdmin 1.2.0 beta on Win32 > > -- I'm unable to add n

Re: [pgadmin-support] Bug: pgAdmin III v1.2.0 Beta 1 - wrong color

2004-09-17 Thread Andreas Pflug
Alexander Kirpa wrote: In case using "'" in comment pgAdmin display WRONG color of keywords. I can't see this. Please provide an example. Regards, Andreas ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [pgadmin-support] pgAdmin III bug with transaction failure

2004-09-17 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: I'm trying to run a SQL script in pgAdminIII which works in psql but fails in pgAdminIII Platform: XP Professional sp2 Language: English Distribution: pgadmin3-win32.zip 12-Sep-2004 19:34 Version: 1.2.0 Post Beta 1 (Sep 12 2004) Problem: The script I'm running drops

Re: [pgadmin-support] Bug: pgAdmin III v1.2.0 Beta 1 - wrong color

2004-09-17 Thread Andreas Pflug
Please don't send mails to private accounts, use the list. Alexander Kirpa wrote: In case using "'" in comment pgAdmin display WRONG color of keywords. I can't see this. Please provide an example. Please COMMENT ON TABLE word IS 'normal color \' wrong \' again normal'; OK, not in comments, but for

[pgadmin-support] pgadmin with error to run

2004-09-17 Thread Alex Rodrigues da Silva
Hi, I installed the pgadmin3 at conectiva linux 10, but when i start the pgadmin, it launch a error pgadmin3: error while loading shared libraries: pgadmin3: undefined symbol: _gtk_accel_group_attach. What i have to do it run? Thanks, Alex Rodrigues ---(end of broadcast

[pgadmin-support] Create database

2004-09-17 Thread Jona
When creating a new database in pgAdmin on an "older" version of PostGreSQL (7.3.4 in my case) the Name and Owner input fields are greyed out. This means that it's not possible to create a new database on this version of PostGreSQL from the GUI but that one has to write the SQL query by hand C

Re: [pgadmin-support] Error adding new column to existing table.

2004-09-17 Thread Ted Taylor
Hi Dave,   Thank you for your quick response.   I downloaded pgAQdmin III “Version 1.2.0 Post Beta 1 (Sep 16 2004)” and I confirm that my original bug report has been fixed.  The GUI does not add the quotes to the datatype, and the column is added.   …BUT…   (and I realize the SEP

Re: [pgadmin-support] Error adding new column to existing table.

2004-09-17 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 September 2004 14:52To: Dave Page; [EMAIL PROTECTED]Subject: RE: [pgadmin-support] Error adding new column to existing table. Hi Dave,   Hi Ted,   Thank you for your quick response.   Your welco

[pgadmin-support] allowing users to change the IP-addresses that are allowed to connect to postgresql

2004-09-17 Thread stig erikson
Hello. I have a postgresql 7.4.5 running. On the server i have a few databases, all owned and administered by different users. The users sometimes change access-rules to their databases, in particular they change access rules based on IP-addresses, which i have to do for them manually in pg_hba.

Re: [pgadmin-support] Error adding new column to existing table.

2004-09-17 Thread Andreas Pflug
Dave Page wrote: NOW, on the left hand side, I re-right-clicked on the same table name (eg if I wanted to add another new column name). pgAdmin abruptly closes with no error messages at all (the app exits, no GPF, no Illegal Operation, no BSOD, no nothing). The expected

Re: [pgadmin-support] allowing users to change the IP-addresses that

2004-09-17 Thread Andreas Pflug
stig erikson wrote: Hello. I have a postgresql 7.4.5 running. This list is for pgadmin, not for pgsql. On the server i have a few databases, all owned and administered by different users. The users sometimes change access-rules to their databases, in particular they change access rules based on I

Re: [pgadmin-support] pgAdmin III bug with transaction failure

2004-09-17 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: The default behavior in pgsql is to allow the use of transactions to isolate SQL statements. PgAdmin seems to batch the entire script into a single transaction, making the user's transaction irrelevant. Use the mailing list! To pgAdmin, all you execute is a single statem

Re: [pgadmin-support] Error adding new column to existing table.

2004-09-17 Thread Ted Taylor
Andreas, Dave, It is fixed in the executable that Dave sent me [Version 1.2.0 Post Beta 1 (Sep 17 2004)]. I will also download the snapshot when it becomes available. Thanks! Ted. -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 10:40 AM

[pgadmin-support] Cannot Create Foreign Key

2004-09-17 Thread Shane G. Brodie
App:pgAdminIII V1.2.0 Post Beta 1 (Sept 17 2004) DB: PostgreSQL 7.4.2 O/S:Fedora Core 2 Kernel: 2.6.8-1.521 Cannot add a foreign key to a table using the gui provided by the "New Object" ... "Foreign Key" dialog. The dialog appears complete and I have filled out all of the requisite p