varchar to text - Mailing list pgsql-general

From Zlatko Matić
Subject varchar to text
Date
Msg-id 000001c5c744$c702a4f0$52bffea9@zlatkovyfkpgz6
Whole thread Raw
Responses Re: varchar to text  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Hello.
 
There are some columns in my tables that I should change from varchar to text, in order to have enough space for long textual commentaries.
Before I do that, I would like to know is there any restriction regarding text type in comparison to varchar type?
Especially concerning triggers and rules ?
Namely, I have triggers that perform audit trail of all my tables, so I'm concerned whether it will work for text type fields ?
 
One additional question is regarding my MS Access front-end. Would it be a problem for Access ?
 
Thanks in advance,
 
Zlatko

pgsql-general by date:

Previous
From: Ben-Nes Yonatan
Date:
Subject: Broken pipe
Next
From: Zlatko Matić
Date:
Subject: Re: installing several PostgreSQL instances on Windows