Feature Requests item #926456, was opened at 2004-03-31 13:57
Message generated for change (Comment added) made by chriskl
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=926456&group_id=37132
Category: Tables
Group: None
>Status: Closed
Priority: 5
Submitted By: jc_m (jc_m)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Support arrays in data types
Initial Comment:
Can the create table and add column functions support
array data types? Currently you have to select from the
list and arrays are not an option.
Thanks.
jc_m
----------------------------------------------------------------------
Comment By: Christopher Kings-Lynne (chriskl)
Date: 2004-03-31 15:43
Message:
Logged In: YES
user_id=82305
The feature you requested has been implemented in CVS. If
you wish to use the feature before the next release, please
download a nightly snapshot:
http://phppgadmin.sourceforge.net/
Note that you may have to wait up to 24 hours for the latest CVS
changes to appear in the snapshot.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=926456&group_id=37132

Feature Requests item #922471, was opened at 2004-03-24 14:35
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=922471&group_id=37132
Category: Interface
Group: None
Status: Open
Priority: 5
Submitted By: Markus Bertheau (twanger)
Assigned to: Robert Treat (xzilla)
Summary: link to schema/table in search results
Initial Comment:
When an attribute is found, the search result is
presented like
(link to attribute)schema.table.attribute(/link)
I think
(link to schema)schema(/link).(link to
table)table(/link).(link to attr)attr(/link) would be
cool, because often you want the table te attribute is
in, not the attribute itself.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=922471&group_id=37132

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2488949
By: reed73
Hi,
I love phpPgAdmin but there is one bit of information it cannot give me.
When I edit a row I need a copy of the update statement it used to update that
row. I don't know enough about php to grab it and I can get it if I enter some
bad information, in which case it echoes the invalid update statement.... how
can I grab the update statement when it is valid?
Thanks
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2484279
By: xzilla
I tried to reproduce it on our 7.2.4 demo server with the cvs code... everything
worked like a charm... perhaps the OP can give his php version info? also perhaps
he should try cvs if possible (though i dont see anything really relevant to
that).
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2482340
By: gog93rpf
Hi all,
I am getting a weird error on phppgadmin 3.3.1 using postgresql 7.2.1. When
I create a table then go back to try and alter it, after clicking on properties,
I get this strange error as the url looks weird.
There is a screenshot of what I mean at http://www.hostarriba.com/error.png. If you
look down at the bottom left hand corner, that is the url which appears when
I put my cursor over the alter link in the table.
Anyone had this before or have any ideas how to correct this ? Is it an isp
thing that they need to tweak ?
Thanks - Rich
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2459834
By: nobody
I am trying to get phppgadmin to connect to Postgresql via SSL. I've compiled
Postgresql with SSL, set ssl=true in postgres.conf, installed the apache, php,
openssl, and libapache-mod-ssl debs, and configured http.conf to load the ssl
module but it's still not working.
Phppgadmin works fine without SSL, however.
What else should I do to get it to work via SSL?
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884

Bugs item #910678, was opened at 2004-03-06 03:03
Message generated for change (Comment added) made by chriskl
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=910678&group_id=37132
Category: Views
Group: 3.3
Status: Open
Resolution: None
Priority: 5
Submitted By: Pablo Zorzoli (loco-loco)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Problems on IE
Initial Comment:
Hi,
i&#039;m having a weird problem due to javascript. In the
"create index" option I cannot select a field from the
left column an move it to the right. When i press the
">>" button, nothing happens.
IE version 5.00.3700.1000
WIn 2K SP4
Hope this report helps.
Regards
Pablo
----------------------------------------------------------------------
>Comment By: Christopher Kings-Lynne (chriskl)
Date: 2004-03-06 12:24
Message:
Logged In: YES
user_id=82305
Hi Pablo,
None of us have access to IE 5 to try to fix the script. If
you can, figure out what the problem is in IE5, and let us
know. Otherwise, just upgrade to IE 6 or Firefox.
Chris
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=910678&group_id=37132

Bugs item #910678, was opened at 2004-03-05 19:03
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=910678&group_id=37132
Category: Views
Group: 3.3
Status: Open
Resolution: None
Priority: 5
Submitted By: Pablo Zorzoli (loco-loco)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Problems on IE
Initial Comment:
Hi,
i&#039;m having a weird problem due to javascript. In the
"create index" option I cannot select a field from the
left column an move it to the right. When i press the
">>" button, nothing happens.
IE version 5.00.3700.1000
WIn 2K SP4
Hope this report helps.
Regards
Pablo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=910678&group_id=37132

Feature Requests item #813072, was opened at 2003-09-26 21:49
Message generated for change (Comment added) made by chriskl
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=813072&group_id=37132
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: David Hofmann (elmic)
Assigned to: Nobody/Anonymous (nobody)
Summary: Views
Initial Comment:
In the new system you need to create views via SQL
code. It seems a bit silly considering the fact that I
could just as easily type it in the main SQL box at the
top.
The system that was used in 2.X was great beacuse it
allowed you to quickly throw views together. Be nice to
have that kind of multi teir selection system again.
----------------------------------------------------------------------
>Comment By: Christopher Kings-Lynne (chriskl)
Date: 2004-03-04 10:12
Message:
Logged In: YES
user_id=82305
Hi Bryan,
It would be a lot easier from this point onwards if you just
subscribed to our ppa-dev list and then we can chat without
using this annoying forums interface.
OK, your questions:
1) Feel free to add a parameter to all the getConstraints()
functions for constraint type to return. Make it a defined
variable (eg. DEFINE('CONSTR_FOREIGN', 'f')) or something.
2) Hmm...yes there is - you can examine pg_constraint
directly. Maybe you'll have to write a getLinkingTables()
function or something. I could help you with that.
3) For pre-7.3 FK constraints, this is a problem recovering
from the triggers. My advice: don't bother. Just have
getConstraints for 7.2 and lower return 'no fk constraints'.
Also, have a look at constraints.php in the doDefault()
function. Note the dodginess in how do output constraints
in 7.3 even.
Chris
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2004-03-03 05:54
Message:
Logged In: YES
user_id=756868
Doh, kind of embarassed, sorry I haven't done this. Real
life has had me for quite a while (work, looking for a
house, recently being married, etc.). That's no excuse, but
I'd like to finish this up.
Anyways, quick question for you Chris, I was planning on
implementing the foreign key thing by looking using
$data->getConstraints and checking the constraint type
(contype) and then parsing consrc for the definition of the
foreign key to find out the specific table and field to link
to, however I was wondering if:
1)There's a cleaner way to do this with the DB classes you
have setup (is there be a better way than getting all
constraints, iterating over them and checking the contype
for 'f').
2)Is there a better way to find the linking tables than
parsing consrc.
3)Will consrc have the same format for all foreign keys?
For example in earlier versions of Postgres foreign keys are
shown as triggers, is there a good way of reconciling this?
Thanks, and sorry for flaking.
-b
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-31 04:38
Message:
Logged In: YES
user_id=756868
>1. Make it so they can use the old method, OR the wizard.
>The views that can be created by the wizard are very
>restrictive and no view I've ever created could be made with
>it...
I'll take a look at this either today or tomorrow, shouldn't
be hard. And, yes, I do agree that the wizard is/has been
pretty limited (actually never used it myself)
>2. Automatically detect the join conditions. eg. From the
>foreign key info, figure out the linking keys, and allow
>person to specify INNER, LEFT or RIGHT join type.
I'll look at this as well, I may have to get more
clarification as to what you have in mind, if so I'll email
you about it.
-b
----------------------------------------------------------------------
Comment By: Christopher Kings-Lynne (chriskl)
Date: 2003-12-31 00:28
Message:
Logged In: YES
user_id=82305
I'll have a look in the next few days. It's cool, except
I'd like 2 major changes.
1. Make it so they can use the old method, OR the wizard.
The views that can be created by the wizard are very
restrictive and no view I've ever created could be made with
it...
2. Automatically detect the join conditions. eg. From the
foreign key info, figure out the linking keys, and allow
person to specify INNER, LEFT or RIGHT join type.
I'll see if I can deal with these, otherwise I'll let you
know...
Chris
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-30 12:49
Message:
Logged In: YES
user_id=756868
Code submitted 12/27/03 in the form of full source and cvs
diffs. Just waiting to see if Chris and the devs feel it's
good enough to make it into the source.
-b
----------------------------------------------------------------------
Comment By: Christopher Kings-Lynne (chriskl)
Date: 2003-12-24 10:45
Message:
Logged In: YES
user_id=82305
Hi Brydan,
We would appreciate it very much if you would like to
re-implement the old method. It hasn't been done due to
severe lack of manpower. (I've been busy working on other
things).
This is exactly the sort of thing we need people to help with!
Read the DEVELOPERS file that comes with phpPgAdmin and
learn how to check out the CVS version. Then, use that as
the basis of your development. You can even check out the
old 2.x code so you can see how it used to be done I guess...
Chris
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-24 00:55
Message:
Logged In: YES
user_id=756868
Have the devs approved this feature request? Are there any
reasons why this should not be implemented? If not, I may
have some time during the holiday break and may try and
implement the old method from 2.x if this is still desired.
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-24 00:55
Message:
Logged In: YES
user_id=756868
Have the devs approved this feature request? Are there any
reasons why this should not be implemented? If not, I may
have some time during the holiday break and may try and
implement the old method from 2.x if this is still desired.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=813072&group_id=37132

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2453694
By: drworld
Hi there,
I installed the phppgadmin rpm package provide by mandrake to help me to easily
admin the only one Pstgres server I got.
Well first I got an PHP error regarding the postgress class, so I fixed it by
correcting the path in the aodb.inc.php file.
After that I try to log with the postgres user (I disabled the security function)
but I obtain a blank page with nothing in (no HTML tag, absolutly nothing).
I got the trouble with the phppgadmin 3.1 and 3.2.1.
I configured the pg_hba.conf with
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
to test, but nothing more. Please notice that PG seems to work fine because
I can access it thru the webmin module.
I try to access to PG thru phppgadmin in local and tcp mode but nothing happen
....
So if someone got the solution, I would appreciate.
Regards,
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884

Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=2453684
By: drworld
You can simply correct the directory where adodb try to open the class.
in /var/www/html/admin/phpPgAdmin/libraries/adodb/adodb.inc.php
line 447
Just suppress the "drivers" of the path and it's gonna working.
Regards
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit:
https://sourceforge.net/forum/unmonitor.php?forum_id=115884

Feature Requests item #813072, was opened at 2003-09-26 06:49
Message generated for change (Comment added) made by bcyde
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=813072&group_id=37132
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: David Hofmann (elmic)
Assigned to: Nobody/Anonymous (nobody)
Summary: Views
Initial Comment:
In the new system you need to create views via SQL
code. It seems a bit silly considering the fact that I
could just as easily type it in the main SQL box at the
top.
The system that was used in 2.X was great beacuse it
allowed you to quickly throw views together. Be nice to
have that kind of multi teir selection system again.
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2004-03-02 13:54
Message:
Logged In: YES
user_id=756868
Doh, kind of embarassed, sorry I haven't done this. Real
life has had me for quite a while (work, looking for a
house, recently being married, etc.). That's no excuse, but
I'd like to finish this up.
Anyways, quick question for you Chris, I was planning on
implementing the foreign key thing by looking using
$data->getConstraints and checking the constraint type
(contype) and then parsing consrc for the definition of the
foreign key to find out the specific table and field to link
to, however I was wondering if:
1)There's a cleaner way to do this with the DB classes you
have setup (is there be a better way than getting all
constraints, iterating over them and checking the contype
for 'f').
2)Is there a better way to find the linking tables than
parsing consrc.
3)Will consrc have the same format for all foreign keys?
For example in earlier versions of Postgres foreign keys are
shown as triggers, is there a good way of reconciling this?
Thanks, and sorry for flaking.
-b
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-30 12:38
Message:
Logged In: YES
user_id=756868
>1. Make it so they can use the old method, OR the wizard.
>The views that can be created by the wizard are very
>restrictive and no view I've ever created could be made with
>it...
I'll take a look at this either today or tomorrow, shouldn't
be hard. And, yes, I do agree that the wizard is/has been
pretty limited (actually never used it myself)
>2. Automatically detect the join conditions. eg. From the
>foreign key info, figure out the linking keys, and allow
>person to specify INNER, LEFT or RIGHT join type.
I'll look at this as well, I may have to get more
clarification as to what you have in mind, if so I'll email
you about it.
-b
----------------------------------------------------------------------
Comment By: Christopher Kings-Lynne (chriskl)
Date: 2003-12-30 08:28
Message:
Logged In: YES
user_id=82305
I'll have a look in the next few days. It's cool, except
I'd like 2 major changes.
1. Make it so they can use the old method, OR the wizard.
The views that can be created by the wizard are very
restrictive and no view I've ever created could be made with
it...
2. Automatically detect the join conditions. eg. From the
foreign key info, figure out the linking keys, and allow
person to specify INNER, LEFT or RIGHT join type.
I'll see if I can deal with these, otherwise I'll let you
know...
Chris
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-29 20:49
Message:
Logged In: YES
user_id=756868
Code submitted 12/27/03 in the form of full source and cvs
diffs. Just waiting to see if Chris and the devs feel it's
good enough to make it into the source.
-b
----------------------------------------------------------------------
Comment By: Christopher Kings-Lynne (chriskl)
Date: 2003-12-23 18:45
Message:
Logged In: YES
user_id=82305
Hi Brydan,
We would appreciate it very much if you would like to
re-implement the old method. It hasn't been done due to
severe lack of manpower. (I've been busy working on other
things).
This is exactly the sort of thing we need people to help with!
Read the DEVELOPERS file that comes with phpPgAdmin and
learn how to check out the CVS version. Then, use that as
the basis of your development. You can even check out the
old 2.x code so you can see how it used to be done I guess...
Chris
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-23 08:55
Message:
Logged In: YES
user_id=756868
Have the devs approved this feature request? Are there any
reasons why this should not be implemented? If not, I may
have some time during the holiday break and may try and
implement the old method from 2.x if this is still desired.
----------------------------------------------------------------------
Comment By: Bryan Encina (bcyde)
Date: 2003-12-23 08:55
Message:
Logged In: YES
user_id=756868
Have the devs approved this feature request? Are there any
reasons why this should not be implemented? If not, I may
have some time during the holiday break and may try and
implement the old method from 2.x if this is still desired.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=813072&group_id=37132