Re: PgAccess - small bug?

Started by Bruce Momjianover 25 years ago8 messages
#1Bruce Momjian
pgman@candle.pha.pa.us

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
#2Karel Zak
zakkr@zf.jcu.cz
In reply to: Bruce Momjian (#1)

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

Show quoted text

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
#3Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Karel Zak (#2)

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
In reply to: Bruce Momjian (#3)
Re: [HACKERS] 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

#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Karel Zak (#2)

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
#6Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Bruce Momjian (#5)

[ Charset ISO-8859-1 unsupported, converting... ]

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Karel Zak" <zakkr@zf.jcu.cz>
Cc: "pgsql-hackers" <pgsql-hackers@postgreSQL.org>; <teo@flex.ro>
Sent: Wednesday, January 24, 2001 3:41 PM
Subject: Re: [HACKERS] PgAccess - small bug?

Has this been dealt with?

Nope ... :-(

I'll fix it this weekend!

OK, let me know if you release a new pgaccess and I will add it to CVS.

-- 
  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
#7Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Bruce Momjian (#6)

Applied to CVS. Thanks.

Bruce Momjian wrote:

Constantin Teodorescu wrote:

I'll fix it this weekend!

OK, let me know if you release a new pgaccess and I will add it to CVS.

Bug fixed. Ross patches applied.
HTML documentation updated with what's new.

Hope it's fine!
You'll find attached the 0.98.7.tar.gz file!

Best regards,
Teo

[ application/x-gzip is not supported, skipping... ]

-- 
  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
#8Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Karel Zak (#2)

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