hi!
using pgadmin III 1.2.0 post-beta2, oct 16 2004 snapshot on win2k, sp4.
database is pgsql 8.0 beta1 running on the same machine.
i experienced the described behaviour in some earlier snapshots also.
i noticed this: in the object tree i have 19 sequences listed and 20
tables. after deleting a
I seem to have encountered several problems with the latest Beta3 of
pgAdmin. This was installed with the latest Beta3 Dev1 installer for
PostgreSQL.
I had Beta2 of pgAdmin previously installed, which was uninstalled
when I uninstalled Beta2 PostgreSQL.
1) The "Recent Files" menu doesn't seem
[EMAIL PROTECTED] wrote:
An fk key definition:
ALTER TABLE xtable
ADD CONSTRAINT cvbcbvc FOREIGN KEY (kod) REFERENCES ytable (kod) ON
UPDATE DEFAULT ON DELETE SET NULL;
Here's the reason: it should read ON UPDATE SET DEFAULT, not just
DEFAULT. Since the reverse engineered string was wrong, so
Dear List!
My Platform is: WinXp
My versions: All Binary Snapsots to 20041016; Version 1.1
Try the following:
1.
create tables:
CREATE TABLE ytable
(
kod varchar(30) NOT NULL
);
CREATE TABLE xtable
(
kod varchar(30) NOT NULL
);
An fk key definition:
ALTER TABLE xtable
ADD CONSTRAINT cvbcbvc FO
All,
There seems to be a new problem with beta 3.
When you try to add a Not Null constraint, the SQL made is incorrect.
When trying to change the operative_group_id field in the operatives table I
get:
ALTER TABLE operatives ALTER operative_group_id TYPE int4ALTER TABLE
operatives
ALTER COLUMN
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Diego A. Gil
> Sent: 21 October 2004 04:46
> To: Pgadmin Support
> Cc: PgAdmin Hackers
> Subject: [pgadmin-hackers] Just to inform sucessful compilation
>
> Hi,
>
> This is just to inform that I
