# Editing constants in constraints

DevFeed: [Editing constants in constraints](<https://devfeed.tech/articles/editing-constants-in-constraints-34379.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2010/08/editing-constants-in-constraints/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2010-08-09T12:45:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [servers](<https://devfeed.tech/topics/servers.md>), [Parsing](<https://devfeed.tech/topics/parsing.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [parsing](<https://devfeed.tech/tags/parsing.md>), [schema](<https://devfeed.tech/tags/schema.md>), [server](<https://devfeed.tech/tags/server.md>)

## AI overview

The article discusses changing constants in database constraints for a replicated-server setup. It considers a PL/pgSQL approach to avoid unsafe text-based parsing and unintended data changes.

## Source excerpt

We're using constants in some constraints here, for example in cases where several servers are replicating to the same federating one: each origin server has his own schema, and all is replicated nicely on the central host, thanks to Londiste, as you might have guessed already.