Обсуждение: Free 4GL Compiler, Informix-Postgress support

Hi.

See Aubit-4GL a full compatible 4GL compiler which may access Informix
and Postgress Database.

See more about this at http://aubit4gl.sourceforge.net/index.html

Enjoy it and feedback please...

Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel 
2.4.9-31,glibc-2.2.4-24).

It seems that pg_dump -t "tablename" dumps correctly the sequence of a 
table's column,when the column is named after "id".

For example,

dynacom=# CREATE TABLE foo2 (fid serial NOT NULL UNIQUE PRIMARY KEY,id 
serial);

[postgres@pc216 ~]% pg_dump -t foo2 > foo2DUMP.sql 

[postgres@pc216 ~]% cat foo2DUMP.sql
--
-- Selected TOC Entries:
--
\connect - postgres
--
-- TOC Entry ID 2 (OID 2009757)
--
-- Name: foo2_id_seq Type: SEQUENCE Owner: postgres
--
CREATE SEQUENCE "foo2_id_seq" start 1 increment 1 maxvalue 
9223372036854775807 minvalue 1 cache 1;
--
-- TOC Entry ID 4 (OID 2009759)
--
-- Name: foo2 Type: TABLE Owner: postgres
--
CREATE TABLE "foo2" (       "fid" integer DEFAULT nextval('"foo2_fid_seq"'::text) NOT NULL,       "id" integer DEFAULT
nextval('"foo2_id_seq"'::text)NOT NULL,       Constraint "foo2_pkey" Primary Key ("fid")
 
);
--
-- Data for TOC Entry ID 6 (OID 2009759)
--
-- Name: foo2 Type: TABLE DATA Owner: postgres
--
COPY "foo2" FROM stdin;
\.
--
-- TOC Entry ID 5 (OID 2009762)
--
-- Name: "foo2_id_key" Type: INDEX Owner: postgres
--
CREATE UNIQUE INDEX foo2_id_key ON foo2 USING btree (id);
--
-- TOC Entry ID 3 (OID 2009757)
--
-- Name: foo2_id_seq Type: SEQUENCE SET Owner: postgres
--
SELECT setval ('"foo2_id_seq"', 1, false);
-- 

Any ideas??

Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr

On Tue, 23 Jul 2002, Achilleus Mantzios wrote:

Just a correction

> Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel 
> 2.4.9-31,glibc-2.2.4-24).
> 
> It seems that pg_dump -t "tablename" dumps correctly the sequence of a 
> table's column,when the column is named after "id".
>                 ^^^^

I meant "when ONLY" the column is named after "id",
whereas it does not dump the sequence when the column is
named after something different than "id".

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr

Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
>> It seems that pg_dump -t "tablename" dumps correctly the sequence of a 
>> table's column,when the column is named after "id".

> I meant "when ONLY" the column is named after "id",

Yeah, you're right.  I'm hoping to see a better answer in 7.3, but
right now it's a horrible kluge ...
        regards, tom lane

On Wed, 24 Jul 2002, Tom Lane wrote:

> Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> >> It seems that pg_dump -t "tablename" dumps correctly the sequence of a 
> >> table's column,when the column is named after "id".
> 
> > I meant "when ONLY" the column is named after "id",
> 
> Yeah, you're right.  I'm hoping to see a better answer in 7.3, but
> right now it's a horrible kluge ...

No harm done!

> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr