[GENERAL] System Tables

Is it possible to accomplish any SQL statement manipulating the System tables? I was wondering about the possibility to substitute the unrecognized SQL statements (ALTER TABLE table COLUMN , for instance) through some queries to the system tables. Nelio -- Nelio Alves Pereira Filho IFX

Re: [GENERAL] Order of Rules

Yes, but how can I pass a reference of the row just inserted to the trigger?? adb wrote: > > Sounds like you need to use a trigger set to > fire after the insert on table A > > Alex. > > On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote: > > > I read at th

[GENERAL] Order of Rules

some information about the row just inserted, so I used rules. As my sum is running before the insertion, its result is wrong. Any ideas? Tks -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br +55 11 3365-5863 [EMAIL PROTECTED]

[GENERAL] Rules

I'd like to know in what order are rules executed, comparing to the queries that generated them. For instance, supose that a INSERT on table A has a rule to update a column in table B. What will be executed first: the INSERT or UPDATE? Tks -- Nelio Alves Pereira Filho IFX Net

[GENERAL] System Tables ER / ALTER COLUMN

I was wondering if there is a ER diagram of the system tables.. As pgsql doesn't have a command to change the type of a field, I thought to make a procedure that do that, changing the system tables. Tks -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br +55 11 3365-5863 [

[GENERAL] miliseconds

Does postgresql have a time type that supports miliseconds? Nelio -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br +55 11 3365-5863 [EMAIL PROTECTED]

Re: [GENERAL] Modeling tool / ODBC

s using the current ODBC driver with ERWin (see our > Users Guide at www.greatbridge.com/docs) . What kind of problems are > you having? > > Regards, > Ned > > Nelio Alves Pereira Filho wrote: > > > Hi there. > > > > Has anyone ever developed a big sys

[GENERAL] Modeling tool / ODBC

using the driver provided at ftp.postgresql.org. Does anyone use frequently this driver? Is its development stopped? I'm having some problems with it, what caused someone to suggest to use M$SQL !! Thanks for helping. -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br +55 11 3

Re: [GENERAL] Inheritance and Foreign Keys

Is it planned to include these features to class inheritance? Nelio Oliver Elphick wrote: > > Nelio Alves Pereira Filho wrote: > >Here's my situation: I have the following relation > > > >table A -<>-- table B > > 1:N &

[GENERAL] Inheritance and Foreign Keys

ted another table, C, that had just one field and inherited from B. No errors showed up, but it didn't complain when I inserted some data into C without the corresponding one in A!! Is it possible to do what I intended? Thanks -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br +55 11

[GENERAL] pgaccess

Is it possible to create schemas and generate them into the database through pgaccess?? What I really wanted to do is a tool where I could model the entities, creating the tables, indexes, triggers, etc, on the fly.. Thanks in advance -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br

[GENERAL] pgaccess

Is it possible to create schemas and generate them into the database through pgaccess?? What I really wanted to do is a tool where I could model the entities, creating the tables, indexes, triggers, etc, on the fly.. Thanks in advance -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br

[GENERAL] sequences and tables

Where do I find information about a sequence? I'd like to know what are the table and column referenced by a sequence. As its name may be truncated, it's not a consistent place to look for. The system tables didn't seem to help. Thanks -- Nelio Alves Pereira Fil

[GENERAL] Union & Nested queries

I tried to do the following query, but it doesn't work. IFX=> select 1 IN (SELECT 1 UNION SELECT 2); ERROR: parser: parse error at or near "union" Are there and syntax error? What is wrong about that?? Thanks -- Nelio Alves Pereira Filho IFX Networks Sao Paulo / Brazil