[SQL] Re: m4 macros plus PostgreSQL anyone?

2000-07-09 Thread K Parker
No advice, just a big question: why M4? I've made great use of M4 myself for gluing a constant- and macro-defining capability to languages that don't have such (even Foxpro--no, no, please don't ask!) but in this day and age perl would be far more expressive and capable for the things you are

[SQL] CREATE TABLE with foreign key and primary key

2000-07-09 Thread Paulo Roberto Siqueira
I'm trying to create a table that has three fields as primary key. These fields must exist in two other tables. id_aluno is primary key in table pessoa, id_curso and id_polo are primary key in table curso_polo. But it seems it won't work. What am I doing wrong? See definitions below. Speci

[SQL] m4 macros plus PostgreSQL anyone?

2000-07-09 Thread andrew
Has anyone used the macro processor m4 to generate PostgreSQL (or any other sql) code automatically from a data dictionary? We have made a good start on this, but would like to avoid reinventing any wheels, or wasting time down blind alleys. To illustrate the benefits of this approach, consider t