Re: [GENERAL] Error in trigger after upgrading to 8.0.1?

2005-02-05 Thread Andrey V. Semyonov
in tables with VOLATILE option set up. Best regards, Andrey V. Semyonov ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] PostgreSQL Security Release

2005-02-02 Thread Andrey V. Semyonov
Marc G. Fournier wrote: In order to address a potential security hole recently identified with the "LOAD" option, the PostgreSQL Global Development Group is announcing the release of new versions of PostgreSQL going back to the 7.2.x version. As always, these releases are available on all mirro

[GENERAL] inet-type sequence

2005-01-29 Thread Andrey V. Semyonov
Hi there. How do I create a sequence of type inet for automatic assignment an IP/32 to a new row? Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet (PostgreSQL 8.0.0, pgAdmin III v 1.2.0). ---(end of broadcast)--- TIP 8: explain

[GENERAL] inet-type sequence

2005-01-29 Thread Andrey V. Semyonov
Hi there. How do I create a sequence of type inet for automatic assignment an IP/32 to a new row? Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet (PostgreSQL 8.0.0, pgAdmin III v 1.2.0). ---(end of broadcast)--- TIP 6: Have y

Re: [GENERAL] Allowing update of column only from trigger

2005-01-29 Thread Andrey V. Semyonov
ger function's owner (if differs from owner). Best regards, Andrey V. Semyonov ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq