Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: citext

Can I change CITEXT columns to VARCHAR without encountering any surprise difficulties?

By adminPosted on June 24, 2022

Question : I went overboard on CITEXT columns on a particularly large table in my application. I would like to […]

Where do you find the citext module in postgres 9.3 on ubuntu 14.04?

By adminPosted on September 18, 2021

Question : So I’m trying to use citext, but it appears to be MIA from ubuntu 14.04 postgres install. Where […]

How do I resolve Postgresql error, ‘no collation was derived for column “foo” with collatable type citext’?

By adminPosted on June 12, 2021

Question : Just recently I upgraded from Postgresql 8.4.11 to 9.1.3. I used pg_dump in the process. Now I’m getting […]

Why does a comparison between CITEXT and TEXT fail?

By adminPosted on April 4, 2021

Question : As expected, when doing an equality test like this, the comparison succeeds: CREATE TABLE citext_test ( value citext […]

Recent Posts

  • Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring
  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding