onsdag 15 september 2004 13:31 skrev Roy F. Cabaniss:

On Tuesday 14 September 2004 11:39, Örn Hansen wrote:

...

Hi,

Has anyone seen or built pgAdmin 3 for SuSE 9.1 amd64? I'm currently using pgaccess, but it requires a bit of hand fiddling since it doesn't provide means to have references when designing fields.

I use phpPgAdmin 3.2.1 with no problems at all.

One of the things I'm seeking in particular, is the following either directly in the table creation (preferrable) or as in this example:

ALTER TABLE ONLY referrer ADD CONSTRAINT "$1" FOREIGN KEY (id) REFERENCES referred(id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE

I tried it in phpPgAdmin ... but it puts the "FOREIGN Key ..." within CHECK(FOREIGN KEY ...) which then returns an error. I know pgAdmin has the feature in windows, at least ... remember having seen it, which is why I went looking for it... put compiling it myself, it requires a newer version of wxGTK than is available, etc ... so I was hoping that someone else had gone through the trouble. :-)

Mvh, Örn