char failed - Search results in mailing lists

2021-09-23 13:00:22 | hashjoins, index loops to retrieve pk/ux constrains in pg12 (Arturas Mazeika)

char"[])) Rows Removed by Filter: 2 Buffers: shared hit=52 -> Materialize (cost=0.00..1.09 rows=4 width=4) (actual time=0.000..0.001 rows=4 loops=1707) Output: nr_6.oid Buffers: shared

2021-05-22 05:41:43 | RE: Partition with check constraint with "like" (Michel SALAIS)

char(encoding) "encoding", datcollate, datctype from pg_database; It is also possible to define an explicit collation for the column. You can have it when you describe the table… But I think like others have

2016-01-01 17:13:46 | Re: Plan differences (Anton Melser)

char(timezone('UTC'::text, a.tstamp), 'YYYY-MM-DD'::text), a.column1, CASE WHEN (d.column1 IS NOT NULL) THEN d.column1 ELSE fff.column1 END, a.column2 -> Merge Left Join (cost=110018.15..3072358.66 rows=23780215 width=143) (actual time

2014-12-17 15:14:23 | Excessive memory used for INSERT (Alessandro Ipe)

char(_slot, 'YYYY-MM-DD'); _tablename := 'MSG_'||_date; PERFORM 1 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND c.relname = _tablename

2010-10-27 11:00:28 | Re: Postgres insert performance and storage requirement compared to Oracle (Divakar Singh)

failed: %s", PQerrorMessage(conn)); PQclear(res); exit_nicely(conn); } /* * Should PQclear PGresult whenever it is no longer needed to avoid memory * leaks */ PQclear(res); char

2010-01-13 00:59:25 | a heavy duty operation on an "unused" table kills my server (Eduardo Piombino)

char(250), and it locked up my system. No surprise, since I had many threads waiting for this alter table to finish. What I did not foresee was that this alter table would take

2009-04-07 19:49:39 | Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian)

char $ac_func (); ! /* The GNU C library defines this for functions which it implements ! to always fail

2008-11-28 13:59:17 | Re: Increasing GROUP BY CHAR columns speed (Andrus)

CHAR(10) AS dbobjekt is ugly. I tried to rewrite it using NullIfNot(dbkonto.objekt1, '+') AS dbobjekt, bot got error ERROR: function nullifnot(character, "unknown") does not exist How to re-write this in nicer

2008-08-13 19:30:50 | Re: Filesystem benchmarking for pg 8.3.3 server (Ron Mayer)

failed on hda3 - disabling barriers and %hdparm -I /dev/hdf | grep FLUSH_CACHE_EXT will not show you anything on those devices. IMHO that's cool; and doesn't count as a lying IDE drive since

2008-03-10 06:31:51 | Utility functions for enabling/disabling fkey triggers (Craig Ringer)

CHAR; BEGIN SELECT contype INTO constraint_type FROM pg_catalog.pg_constraint WHERE pg_catalog.pg_constraint.conname = constraint_name; IF constraint_type <> 'f' THEN RAISE EXCEPTION 'Can only disable triggers for foreign key constraints

2008-01-24 20:32:52 | 8.3rc1 Out of memory when performing update (Stephen Denne)

Failed on request of size 28. 2008-01-25 11:53:10.362 NZDT [3824]: [5-1] STATEMENT: UPDATE document_file SET document_type_id = (SELECT document_type_id FROM document d where d.id = document

2007-10-10 16:34:16 | Re: Performance problems with prepared statements (Theo Kramer)

fail to see how preparing a query using PQprepare() and then executing it using PQexecPrepared(), is 8 thousand times slower than directly executing it.,, ( 403386.583ms/50.0ms = 8067 ). When doing a 'manual' prepare and explain analyze

2007-01-14 08:44:02 | Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) (Rolf Østvik (HA/EXA))

char(ur.start_date_time, 'YYYY-MM-DD'), count(*) as num_test from uut_result as ur inner join units as u on ur.unit_ref=u.ref inner join step_result

2007-01-14 08:31:41 | (Rolf Østvik (HA/EXA))

char(ur.start_date_time, 'YYYY-MM-DD'), count(*) as num_test from uut_result as ur inner join units as u on ur.unit_ref=u.ref inner join step_result

2006-12-13 17:49:51 | Re: Optimizing a query (Tom Lane)

char(3) columns, shouldn't you be quoting the constants? select * from nanpa where npa='775' and nxx='413'; Any non-numeric input will fail