SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 07:26 AM
| ||||
| ||||
 psql problem querying relations Hi, this is with current CVS code: # \dt ERROR: did not find '}' at end of input node Server log: ERROR: did not find '}' at end of input node STATEMENT: SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type", r.rolname as "Owner" FROM pg_catalog.pg_class c JOIN pg_catalog.pg_roles r ON r.oid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) ORDER BY 1,2; Best regards, Zoltán Böszörményi ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings      |
|
04-12-2008, 07:26 AM
| |||
| |||
| Re: psql problem querying relations Zoltan Boszormenyi wrote: > Hi, > > this is with current CVS code: > > # \dt > ERROR: did not find '}' at end of input node > > Server log: > > ERROR: did not find '}' at end of input node It's working for me. Have you tried with a fresh checkout or after running make clean before you build? cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
|
04-12-2008, 07:26 AM
| ||||
| ||||
| Re: psql problem querying relations Andrew Dunstan írta: > Zoltan Boszormenyi wrote: >> Hi, >> >> this is with current CVS code: >> >> # \dt >> ERROR: did not find '}' at end of input node >> >> Server log: >> >> ERROR: did not find '}' at end of input node > > It's working for me. Have you tried with a fresh checkout or after > running make clean before you build? > > cheers > > andrew I have to reinitdb my test database then tried again. It's working regardless of my IDENTITY patch is applied or not. Thanks. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
 |
« 5 Weeks till feature freeze or (do you know where your patch is?)
|
Re: COMMIT NOWAIT Performance Option »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 01:06 AM.
