Re: [SQL] backup of a specific schema
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kenneth Gonsalves wrote: | On Saturday 28 August 2004 06:18 pm, Gaetano Mendola wrote: | | |>| |>| backup/restore |> |>Well, that chapter speak about pg_dump, don't you had the curiosity |>to look at the complete options for that command ? :-) | | | yes. so i looked in the book from which i was learning postgres. it gave | about 3 options and didnt say there were more. so i didnt look further. i | thought maybe it has to be done programmatically which is why i posted the | query Is better alway take a look at the on-line doocumentation, in this way you'll be sure to be up-to-date. Regards Gaeatano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBMbvg7UpzwH2SGd4RApdvAKD1MFtYwnsShQIiEvfuQ5y6fZI71wCgpweH WiqNRGoDaNy11W18Dg40/EE= =3a5m -END PGP SIGNATURE- ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[SQL] Abwesenheitsnotiz: approved document
Sehr geehrte Damen und Herren, ich bin bis einschl. 27.08.2004 nicht im Büro. In dringenden Fällen wenden Sie sich bitte an das Sekretariat, Frau Braun-Scheibe , Tel. 0511/645-3485. Heino Gerdes MFG Heino Gerdes ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] expression_tree_walker: Unexpected node type 711
I am having a problem with a select statement and the error expression_tree_walker: Unexpected node type 711 is being returned when I am trying to execute a rather simple SELECT statement. Any insight anyone could give me would be greatly appreciated. And if this is the wrong place to ask this then if someone could point me in the right direction that would be swell. TALE STRUCTURE: Table "public.official_hour" Column | Type | Modifiers ---+--+--- calendar_date | date | not null official_opening_hour | double precision | office_closed | boolean | Indexes: official_hour_pkey primary key btree (calendar_date) SOME DATA THAT LIVES IN TABLE: select * from official_hour limit 10; calendar_date | official_opening_hour | office_closed ---+---+--- 2018-11-08| | 2018-11-09| | 2018-11-10| | t 2018-11-11| | t 2018-11-12| | 2018-11-13| | 2018-11-14| | 2004-08-11| 9 | f 2004-08-12| 9 | f 2004-08-13| 9 | f SQL THAT IS THROWING ERROR: select calendar_date from official_hour where official_hour is not null and office_closed = False and calendar_date >= date'2004/01/01' and calendar_date <= date'2004/08/23' order by calendar_date RESULTS: ProgrammingError: ERROR: expression_tree_walker: Unexpected node type 711 Anyone see something here I don't? Could this be a result of having a date object as part of the primary key? -- Ian Percival - Developer mailto:[EMAIL PROTECTED] phone: 780.413.6397 ext. 226 Emergence by Design http://www.emergence.com mailto:[EMAIL PROTECTED] toll free: 1.866.860.2666 -- ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] expression_tree_walker: Unexpected node type 711
Ian Percival <[EMAIL PROTECTED]> writes: > SQL THAT IS THROWING ERROR: > select > calendar_date > from > official_hour > where > official_hour is not null > and office_closed = False > and calendar_date >= date'2004/01/01' > and calendar_date <= date'2004/08/23' > order by > calendar_date > RESULTS: > ProgrammingError: ERROR: expression_tree_walker: Unexpected node type 711 > Anyone see something here I don't? 7.4 will give a more helpful error message: ERROR: relation reference "official_hour" cannot be used in an expression regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
