Postgres Pro
Downloads
Home   >   mailing lists

Thread: error creating new table

error creating new table

From
"Virgil Frum"
Date:
pgAdmin ver. 1.3.0 (Jan 14 2005)
Windows XP SP2

When creating new table via 'New Table' dialog I've got error:
XRC resource 'frmHint' (class 'wxDialog') not found! (and pgAdmin freezes)
but via SQL query tool it works fine.

Here is table definition:
CREATE TABLE info
(  version varchar(50) NOT NULL,  creationtstamptz timestamptz NOT NULL DEFAULT now()
) WITHOUT OIDS;

There is another problem, I cannot insert rows via Edit Data grid in info 
table.


Virgil Frum

Re: error creating new table

From
Andreas Pflug
Date:
Virgil Frum wrote:
> pgAdmin ver. 1.3.0 (Jan 14 2005)
> Windows XP SP2
> 
> When creating new table via 'New Table' dialog I've got error:
> XRC resource 'frmHint' (class 'wxDialog') not found! (and pgAdmin freezes)
> but via SQL query tool it works fine.
> 
> Here is table definition:
> CREATE TABLE info
> (
>   version varchar(50) NOT NULL,
>   creationtstamptz timestamptz NOT NULL DEFAULT now()
> ) WITHOUT OIDS;
> 
> There is another problem, I cannot insert rows via Edit Data grid in 
> info table.

Both problems result from the missing primary key. The latter is well 
documented (FAQ, rank 1)

Regards,
Andreas

Re: error creating new table

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Andreas Pflug
> Sent: 10 February 2005 12:44
> To: Virgil Frum
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] error creating new table
>
> Virgil Frum wrote:
> > pgAdmin ver. 1.3.0 (Jan 14 2005)
> > Windows XP SP2
> >
> > When creating new table via 'New Table' dialog I've got error:
> > XRC resource 'frmHint' (class 'wxDialog') not found! (and
> pgAdmin freezes)
> > but via SQL query tool it works fine.
> >
> > Here is table definition:
> > CREATE TABLE info
> > (
> >   version varchar(50) NOT NULL,
> >   creationtstamptz timestamptz NOT NULL DEFAULT now()
> > ) WITHOUT OIDS;
> >
> > There is another problem, I cannot insert rows via Edit
> Data grid in
> > info table.
>
> Both problems result from the missing primary key. The latter is well
> documented (FAQ, rank 1)

A missing pkey results in a missing XRC resource? Wow, we need a new
dependency tracking system :-)

Seriously though, I don't see a frmHint anywhere (including
xrcDialogs.cpp) - did you forget to commit it?

Regards, Dave.

Re: error creating new table

From
Andreas Pflug
Date:
Dave Page wrote:
> 
> A missing pkey results in a missing XRC resource?

Yeah, the very latest pgsql extension :-)

> Wow, we need a new dependency tracking system :-)



> Seriously though, I don't see a frmHint anywhere (including
> xrcDialogs.cpp) - did you forget to commit it?

No, I uploaded a win32 snapshot which contains that reference. The CVS 
is consistent.

I'm in the middle of some major code expectoration, so stay tuned.

Regards,
Andreas