
Hi,

in PgAccess's the create table dialog is small bug. If I define a new table
as interits of other table and I not define any column (as 'field' named this 
dialog) - PgAccess return ERROR message "Your table has not field!". But
PgSQL allow define table as:

	CREATE TABLE xxx () INHERITS(yyy); 

...all colunms is from 'yyy'. 

NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is 
abnormal in SQL speech... 

							Karel

------------------------------------------------------------------------------
Karel Zak <zakkr@zf.jcu.cz>                      http://home.zf.jcu.cz/~zakkr/

Docs:         http://docs.linux.cz                          (big docs archive)	
Kim Project:  http://home.zf.jcu.cz/~zakkr/kim/              (process manager)
FTP:          ftp://ftp2.zf.jcu.cz/users/zakkr/              (C/ncurses/PgSQL)
------------------------------------------------------------------------------


Thu, 25 Nov 1999 14:43:20 +0100 (CET)
Karel Zak - Zakkr <zakkr@zf.jcu.cz>
PgAccess - small bug?
I assume this is fixed?


> 
> Hi,
> 
> in PgAccess's the create table dialog is small bug. If I define a new table
> as interits of other table and I not define any column (as 'field' named this 
> dialog) - PgAccess return ERROR message "Your table has not field!". But
> PgSQL allow define table as:
> 
> 	CREATE TABLE xxx () INHERITS(yyy); 
> 
> ...all colunms is from 'yyy'. 
> 
> NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is 
> abnormal in SQL speech... 
> 
> 							Karel
> 
> ------------------------------------------------------------------------------
> Karel Zak <zakkr@zf.jcu.cz>                      http://home.zf.jcu.cz/~zakkr/
> 
> Docs:         http://docs.linux.cz                          (big docs archive)	
> Kim Project:  http://home.zf.jcu.cz/~zakkr/kim/              (process manager)
> FTP:          ftp://ftp2.zf.jcu.cz/users/zakkr/              (C/ncurses/PgSQL)
> ------------------------------------------------------------------------------
> 
> 
> ************
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 31 May 2000 20:04:08 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PgAccess - small bug?




On Wed, 31 May 2000, Bruce Momjian wrote:

> I assume this is fixed?

 Oh, it is really old letter from me. I total forget... 

 Hmm, I haven't here last version of CVS, but pgaccess in my comp has this
bug still..

 Bruce, thanks for answer. I not had hope that anyone advert to this.

						Karel

> 
> > 
> > Hi,
> > 
> > in PgAccess's the create table dialog is small bug. If I define a new table
> > as interits of other table and I not define any column (as 'field' named this 
> > dialog) - PgAccess return ERROR message "Your table has not field!". But
> > PgSQL allow define table as:
> > 
> > 	CREATE TABLE xxx () INHERITS(yyy); 
> > 
> > ...all colunms is from 'yyy'. 
> > 
> > NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is 
> > abnormal in SQL speech... 
> > 
> > 							Karel
> > 
> > ------------------------------------------------------------------------------
> > Karel Zak <zakkr@zf.jcu.cz>                      http://home.zf.jcu.cz/~zakkr/
> > 
> > Docs:         http://docs.linux.cz                          (big docs archive)	
> > Kim Project:  http://home.zf.jcu.cz/~zakkr/kim/              (process manager)
> > FTP:          ftp://ftp2.zf.jcu.cz/users/zakkr/              (C/ncurses/PgSQL)
> > ------------------------------------------------------------------------------
> > 
> > 
> > ************
> > 
> 
> 
> -- 
>   Bruce Momjian                        |  http://www.op.net/~candle
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 


Thu, 1 Jun 2000 10:07:33 +0200 (CEST)
Karel Zak <zakkr@zf.jcu.cz>
Re: PgAccess - small bug?
Constantin, can you comment on this?

> 
> 
> 
> 
> On Wed, 31 May 2000, Bruce Momjian wrote:
> 
> > I assume this is fixed?
> 
>  Oh, it is really old letter from me. I total forget... 
> 
>  Hmm, I haven't here last version of CVS, but pgaccess in my comp has this
> bug still..
> 
>  Bruce, thanks for answer. I not had hope that anyone advert to this.
> 
> 						Karel
> 
> > 
> > > 
> > > Hi,
> > > 
> > > in PgAccess's the create table dialog is small bug. If I define a new table
> > > as interits of other table and I not define any column (as 'field' named this 
> > > dialog) - PgAccess return ERROR message "Your table has not field!". But
> > > PgSQL allow define table as:
> > > 
> > > 	CREATE TABLE xxx () INHERITS(yyy); 
> > > 
> > > ...all colunms is from 'yyy'. 
> > > 
> > > NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is 
> > > abnormal in SQL speech... 
> > > 
> > > 							Karel
> > > 
> > > ------------------------------------------------------------------------------
> > > Karel Zak <zakkr@zf.jcu.cz>                      http://home.zf.jcu.cz/~zakkr/
> > > 
> > > Docs:         http://docs.linux.cz                          (big docs archive)	
> > > Kim Project:  http://home.zf.jcu.cz/~zakkr/kim/              (process manager)
> > > FTP:          ftp://ftp2.zf.jcu.cz/users/zakkr/              (C/ncurses/PgSQL)
> > > ------------------------------------------------------------------------------
> > > 
> > > 
> > > ************
> > > 
> > 
> > 
> > -- 
> >   Bruce Momjian                        |  http://www.op.net/~candle
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> > 
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 2 Oct 2000 00:22:48 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PgAccess - small bug?
Bruce Momjian wrote:
> 
> Constantin, can you comment on this?

Sorry for my delayed response!
Yes, I will fix the table creation for no columns but inherited from
other tables!

> > > > in PgAccess's the create table dialog is small bug. If I define a new table
> > > > as interits of other table and I not define any column (as 'field' named this
> > > > dialog) - PgAccess return ERROR message "Your table has not field!". But
> > > > PgSQL allow define table as:
> > > >
> > > >   CREATE TABLE xxx () INHERITS(yyy);
> > > >
> > > > ...all colunms is from 'yyy'.
> > > >
> > > > NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is
> > > > abnormal in SQL speech...

I will also replace all over the place 'field' with 'column'!

Hope I will be able to deliver soon a minor upgrade (mainly bug fixes)
but we are in Romania in the fever of general elections (chambers and
president) :-)

Constatin Teodorescu
Braila, ROMANIA

Fri, 13 Oct 2000 08:12:49 +0300
Constantin Teodorescu <teo@flex.ro>
Re: [HACKERS] PgAccess - small bug?

Has this been dealt with?

> 
> 
> 
> 
> On Wed, 31 May 2000, Bruce Momjian wrote:
> 
> > I assume this is fixed?
> 
>  Oh, it is really old letter from me. I total forget... 
> 
>  Hmm, I haven't here last version of CVS, but pgaccess in my comp has this
> bug still..
> 
>  Bruce, thanks for answer. I not had hope that anyone advert to this.
> 
> 						Karel
> 
> > 
> > > 
> > > Hi,
> > > 
> > > in PgAccess's the create table dialog is small bug. If I define a new table
> > > as interits of other table and I not define any column (as 'field' named this 
> > > dialog) - PgAccess return ERROR message "Your table has not field!". But
> > > PgSQL allow define table as:
> > > 
> > > 	CREATE TABLE xxx () INHERITS(yyy); 
> > > 
> > > ...all colunms is from 'yyy'. 
> > > 
> > > NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is 
> > > abnormal in SQL speech... 
> > > 
> > > 							Karel
> > > 
> > > ------------------------------------------------------------------------------
> > > Karel Zak <zakkr@zf.jcu.cz>                      http://home.zf.jcu.cz/~zakkr/
> > > 
> > > Docs:         http://docs.linux.cz                          (big docs archive)	
> > > Kim Project:  http://home.zf.jcu.cz/~zakkr/kim/              (process manager)
> > > FTP:          ftp://ftp2.zf.jcu.cz/users/zakkr/              (C/ncurses/PgSQL)
> > > ------------------------------------------------------------------------------
> > > 
> > > 
> > > ************
> > > 
> > 
> > 
> > -- 
> >   Bruce Momjian                        |  http://www.op.net/~candle
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> > 
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 24 Jan 2001 08:41:38 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PgAccess - small bug?

This is fixed in the pgaccess version in CVS. 

> 
> 
> 
> 
> On Wed, 31 May 2000, Bruce Momjian wrote:
> 
> > I assume this is fixed?
> 
>  Oh, it is really old letter from me. I total forget... 
> 
>  Hmm, I haven't here last version of CVS, but pgaccess in my comp has this
> bug still..
> 
>  Bruce, thanks for answer. I not had hope that anyone advert to this.
> 
> 						Karel
> 
> > 
> > > 
> > > Hi,
> > > 
> > > in PgAccess's the create table dialog is small bug. If I define a new table
> > > as interits of other table and I not define any column (as 'field' named this 
> > > dialog) - PgAccess return ERROR message "Your table has not field!". But
> > > PgSQL allow define table as:
> > > 
> > > 	CREATE TABLE xxx () INHERITS(yyy); 
> > > 
> > > ...all colunms is from 'yyy'. 
> > > 
> > > NOTE: Why a attribute (column) is in the PgAccsess named 'field'? It is 
> > > abnormal in SQL speech... 
> > > 
> > > 							Karel
> > > 
> > > ------------------------------------------------------------------------------
> > > Karel Zak <zakkr@zf.jcu.cz>                      http://home.zf.jcu.cz/~zakkr/
> > > 
> > > Docs:         http://docs.linux.cz                          (big docs archive)	
> > > Kim Project:  http://home.zf.jcu.cz/~zakkr/kim/              (process manager)
> > > FTP:          ftp://ftp2.zf.jcu.cz/users/zakkr/              (C/ncurses/PgSQL)
> > > ------------------------------------------------------------------------------
> > > 
> > > 
> > > ************
> > > 
> > 
> > 
> > -- 
> >   Bruce Momjian                        |  http://www.op.net/~candle
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> > 
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sat, 27 Jan 2001 13:46:43 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PgAccess - small bug?