tables   11751

« earlier    

PostgreSQL error cache lookup failed for relation - what causes it and why? - Stack Overflow
deleting orphaned temp tables allowed vacuum to complete:

I was dropping a schema and I had this error "lookup failed for relation xxxx". There was the name of a table also. It seemed some tables from the schema I was deleting, were in a strange state. At the end we did this third steps.

We obtain the C.oid of the table.
select c.oid
from pg_class c
join pg_namespace n on n.oid=c.relnamespace
where c.relname = 'MY_TABLE_NAME'
and n.nspname='MY_SCHEMA_NAME';
delete from pg_class where oid = MY_OID;
delete from pg_depend where objid = MY_OID;
delete from pg_constraint where conrelid = MY_OID;
drop schema MY_SCHEMA_NAME cascade
Then appeared another similar error with another table and we repeated steps 1 to 3 until we deleted the schema.
postgresql  error  cache  lookup  failed  for  relation  orphan  table  tables  delete  from  pg_class  vacuum  full  transaction 
3 days ago by theskett
Design better data tables –
Rudimentary (design. not implementation) but thorough review of table considerations.
tables  graphing  data  design  dashboard  table  spreadsheet  spreadsheets  reading  visualizations 
6 days ago by smack416
Mobile Tables — Comparisons and Other Data Tables (Nielsen/Norman Group)
Amy Schade из Nielsen/Norman Group перечисляет приёмы представления сложных таблиц на мобильных.
UX  mobile  tables  comparison  issue  patterns 
7 days ago by jvetrau
SublimeDataConverter "Sublime Text EDITOR" PKG ~ similar to online site: Mr. Data Converter!
This package ==>for the "Sublime Text EDITOR" <==, converts csv files to various other formats.
(It's been adapted from the wonderful Mr. Data Converter).

After installing, you'll find commands look like
DataConverter: to foo
in the Command Palette.

DataConverter will convert a selection or multiple selections.
(If nothing is selected, the entire document is converted).


Turn this:

Alice,10,Apple,"Sep. 12, 2016"
Bob,11,Blueberry,"Sep. 13, 2016"
Chris,12,Orange,"Sep. 14, 2016"

into this (Ruby):

[{"name"=>"Alice", "value"=>10, "fruit"=>"Apple", "date"=>"Sep. 12, 2016"},
{"name"=>"Bob", "value"=>11, "fruit"=>"Blueberry", "date"=>"Sep. 13, 2016"},
{"name"=>"Chris", "value"=>12, "fruit"=>"Orange", "date"=>"Sep. 14, 2016"}];

or into this (JSON):

{"fruit": "Apple", "name": "Alice", "value": "10", "date": "Sep. 12, 2016"},
{"fruit": "Blueberry", "name": "Bob", "value": "11", "date": "Sep. 13, 2016"},
{"fruit": "Orange", "name": "Chris", "value": "12", "date": "Sep. 14, 2016"}

Formats supported:

HTML tables
JIRA (Atlassian Confluence)
JSON (array of columns)
JSON (array of rows)
JSON (object, first column is key)
Javascript object
PHP (two formats)
Python (list of dicts)
Python (list of lists)
SQL (Postgres, MySQL and SQLite)
text table
Wiki markup
XML (property list)
XML for data-driven Adobe Illustrator

Additionally, DataConverter can convert between delimiters. By default, this includes commands to convert to CSV and TSV, and it's possible to add your own delimiter (create a User.sublime-commands file following the pattern in DataConverter.sublime-commands).

With Package Control

If you have Package Control installed, you can install DataConverter from within Sublime Text. Open the Command Palette and enter "Package Control: Install Package", then search for DataConverter.
Without Package Control

Clone the repository into your Sublime Text packages directory:

git clone git://

Without Package Control or Git

Click Download Zip above to download the package. Unzip it, rename the folder "DataConverter" and move it into your Sublime Text 2 packages directory (Preferences > Browse Packages in the application menu).

CSV containing Unicode characters aren't supported in the Sublime Text 2 version of the package. This is due to limitations in the Python 2.6 csv module. Unicode is fully supported in the Sublime Text 3 version of the package.

Submit an issue.
Editor  text  delimiters  delimiter  ActionScript  ASP  HTML  tables  Gherkin  JIRA  Atlassian  Confluence  JSON  Javascript  JS  Perl  PHP  Python  Ruby  SQL  Postgres  MySQL  SQLite  table  Wiki  markup  XML  YAML  SublimeDataConverter  Sublime  Data  Converter  transformeter  btw  between  ex  exs  Rlang  PKG  Mr  Convert  transform  format  formats  layout 
9 days ago by SFdude

« earlier    

related tags

&  *todo  2017-08-12  2017-08-14  2017-08-16  2017-09-13  2017-09-15  2017-09-17  access  accessibility  accessories  accordion  actionscript  admin  administration  agency  algorithm  all  alternativeto  always  an  analysis  and  another  appdesign  apps  archive  arrays  art  articles  asp  associative  atlassian  auto  automation  autovacuum  awesome  b2b  backyard  bar  bench  benches  bestpractice  between  blog  bookshelve  bootstrap  boxes  brian  btw  built  cache  chairs  chandeliers  class  coffee  cognitive.load  comparison  confluence  contemporary  convert  converter  copy  corruption  creative  css  csv  custom  dashboard  data-reporting  data-table  data  database  databases  datascience  datastructures  datatables  dataviz  db  delete  delimiter  delimiters  design.patterns  design  development  editor  elegant  eloquent  emacs  email  entries  environment  error  everything  ex  example  examples  excel  exs  extraction  failed  feature  features  filter  find  fire  for  format  formats  frame  framework  freeze  from  front-end  frozen  full  functionalprogramming  funny  furnishings  furniture  generator  gherkin  golang  google  graphing  graphs  guide  hash  hayneedle  hd  heating  hickory  hide  hks  home  how  howto  html  ice  id  ideas  ifttt  impressive  in  indesign  inspiration  inspired  instance  intel  into  issue  ixd  java  javascript  jira  jquery  js  json  kernighan  key  laravel  latex  layout  library  lighting  lights  list  lookup  markdown  markup  medium  metadata  mirror  mirrored  mobile  mr  ms  mysql  netart  nichol  on  one  opensource  org-mode  org  orphan  orphaned  outdoor  outlook  owners  patterns  pendant  perl  pg_class  phone  php  pit  pits  pivot  pkg  plugin  postgres  postgresql  presentation  pricing  principles  print  processor  product  productivity  products  programming  promotions  python  query  r  re-fx  react  reading  recovery  reference  refx  related  relation  repair  reporting  responsive  reviews  rlang  rollup  rolluptables  ruby  rwd  sag  sap  scandinavian  seating  server  setup  shaun  sheets  show  showing  small  smart  smartphone  sort  spreadsheet  spreadsheets  sql  sqlite  stackoverflow  stools  study  sublime  sublimedataconverter  subreport  table  table_design  tableware  tablular  tasks  temp  text  themes  tips  to  toolkit  tools  tradition  transaction  transform  transformeter  turn  tutorial  ui  uniflame  usa  usability  userinterface  users  ux  vacuum  vanillajs  vba  video  visualization  visualizations  vuejs  web  webapp  webdesign  webdev  webdevel  webpress  weddi  wiki  wizard  wood  woodworking  word  wordpress  wraparound  xeon  xml  yaml  your  youtube  | 

Copy this bookmark: