Tom Lane wrote:
> Andreas Haumer <[EMAIL PROTECTED]> writes:
> > How can I get the functionality of an "deferred AFTER trigger"
> > again with PostgreSQL 8?
>
> Use CREATE CONSTRAINT TRIGGER. The manual is fairly negative about this
> but I don't actually foresee it going away any time soon.
Do
I've found it useful to explore the information_schema schema by doing:
set search_path=information_schema; -- Lets just look at the system tables.
\d -- Show me all the tables.
...
(40 rows)
then
select * from some-likely-looking-table limit 20;
In this
On Fri, 21 Apr 2006, Bruno Wolff III wrote:
On Fri, Apr 21, 2006 at 09:29:33 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
Is there a reasonable way to extract a list of all tables which contain a
specific column name from the system views on 8.1?
For instance, I might want to enumerate all ta
On Fri, Apr 21, 2006 at 09:29:33 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
> Is there a reasonable way to extract a list of all tables which contain a
> specific column name from the system views on 8.1?
>
> For instance, I might want to enumerate all tables with a column named
> last_modif
Is there a reasonable way to extract a list of all tables which contain a
specific column name from the system views on 8.1?
For instance, I might want to enumerate all tables with a column named
last_modified.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.
Andreas Haumer <[EMAIL PROTECTED]> writes:
> How can I get the functionality of an "deferred AFTER trigger"
> again with PostgreSQL 8?
Use CREATE CONSTRAINT TRIGGER. The manual is fairly negative about this
but I don't actually foresee it going away any time soon.
regards
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I'm currently porting a rather complex application from
PostgreSQL 7.4.x to 8.1.3 and I'm having problems with
changed semantics of the trigger functionality.
The problem is quite complex and I'm trying to describe
the functionality involved as d
Hello Willem,
you are writing an edit mask?
Then do the following. Feed the mask with the data from the record.
If the user changes anything and presses the save button, then issue an
UPDATE WHERE ID= to the database.
Always remember: you are working with a database, not with a dbf-file.
If
