No phpPgAdmin delete or edit links when browsing

[Dan99]

I am not sure if I should post this here or in a potgre group, but I
will start here. I recently got a new server and thus when I copied
all the files to the new machine, I logically decided to upgrade
everything to the newest versions. So my postgre got upgraded from
7.4 to 8.1 and my phpPgAdmin also got upgraded. Now though, I am only
able to use the edit/delete buttons on some of the tables when
browsing. I am not sure what is the difference between the tables
that allows or disallows these buttons to be there. Is it at all
possible to get these buttons back? (originally on the other server,
all tables had these buttons). The only thing I can think of is that
there is a configuration setting that needs to be changed or that
something in the conversion process between 7.4 to 8.1 changed
something. The version of phpPgAdmin I have is 4.0.1

An help anyone can provide me for this would be greatly apreciated.
Let me know if you think this is a postgre problem and I will instead
post in that group.

Thank you,
Daniel

[Toby A Inkster]

Dan99 wrote:

Would it be enough to do something like SELECT * INTO table2 FROM table
WITH OIDS

I've not tried that, but I imagine it will work. Relying on OIDs isn't a
great idea though, because:

a) they're a non-standard feature of PostgreSQL, so if you need
to move to a different database, you won't be able to use
them; and

b) PostgreSQL seems to be phasing them out, so if you *don't* move
to a different database, you may not be able to use them in the
future.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 25 days, 2:38.]

CSS to HTML Compiler
http://tobyinkster.co.uk/blog/2008/01/22/css-compile/

[Dan99]

On Jan 24, 10:28 am, Toby A Inkster <[e-mail]>
wrote:

Dan99 wrote:

Would it be enough to do something like SELECT * INTO table2 FROM table
WITH OIDS

I've not tried that, but I imagine it will work. Relying on OIDs isn't a
great idea though, because:

a) they're a non-standard feature of PostgreSQL, so if you need
to move to a different database, you won't be able to use
them; and

b) PostgreSQL seems to be phasing them out, so if you *don't* move
to a different database, you may not be able to use them in the
future.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 25 days, 2:38.]

CSS to HTML Compiler
http://tobyinkster.co.uk/blog/2008/01/22/css-compile/

I know this is starting to get way off of php, but you sound like you
know what you are talking about so I hope you dont mind helping me out
a bit more. Changing the config file worked good for creating new
tables with the oids, but I want to replicate all the existing tables
so that they have oids. I ran the following query on a test table
that does not have OIDs after changing the config:
SELECT * INTO table2 FROM table
This works well except for the fact that it doesnt copy anything but
the data. For example any indexes, constraints, or triggers do not
copy to the new table? How would I go about making an exact duplicate
of a table?

Thanks again,
Daniel

[Toby A Inkster]

Dan99 wrote:

SELECT * INTO table2 FROM table
This works well except for the fact that it doesnt copy anything but the
data. For example any indexes, constraints, or triggers do not copy to
the new table? How would I go about making an exact duplicate of a
table?

CREATE TABLE foo (LIKE bar INCLUDING DEFAULTS INCLUDING CONSTRAINTS);
INSERT INTO foo SELECT * FROM bar;

This will copy the table structure, data and constraints, but not indexes
or triggers. If you want to make sure that indexes and triggers are
copied, probably the best route is to use the pg_dump backup tool that
comes with PostgreSQL to dump the table in its entirety to a flat SQL
file, which can then be opened with a text editor to change the table name
and then restored.

I suggest continuing this discussion in comp.databases.postgresql.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 22:33.]

Looking Ahead to PHP 6
http://tobyinkster.co.uk/blog/2008/01/29/php6/