Re: [ADMIN] Using temp tables
Andreas Schmitz <[EMAIL PROTECTED]> writes: > I did a vacuum full and analyze but this pg_temp namespaces are still there. > Any ideas about that phenomena ? They're supposed to be there; we recycle the pg_namespace entry across successive backend sessions. I see no point in deleting it only to have to make it again in a later session. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[ADMIN] Using temp tables
Hello *, we started the use of temporary tables for evaluating data. create temp table xxx drop temp table xxx; We encountered some strange errors about relation exists or even does not exist from server and application site. I started to look after orphan temp tables. No orphans were left but I found namespace entries in pg_namespace. select * from pg_namespace; nspname | nspowner | nspacl +--+ pg_catalog |1 | {=U} pg_toast |1 | {=} public |1 | {=UC} pg_temp_1 |1 | pg_temp_8 |1 | pg_temp_11 |1 | pg_temp_10 |1 | pg_temp_6 |1 | pg_temp_4 |1 | pg_temp_3 |1 | pg_temp_14 |1 | pg_temp_2 |1 | pg_temp_5 |1 | pg_temp_12 |1 | (14 rows) I did a vacuum full and analyze but this pg_temp namespaces are still there. Any ideas about that phenomena ? best regards -Andreas Schmitz -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(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