public inbox for [email protected]
help / color / mirror / Atom feedhow to select temp table
15+ messages / 6 participants
[nested] [flat]
* how to select temp table
@ 2009-05-06 12:34 liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: liuzg4 liuzg4 @ 2009-05-06 12:34 UTC (permalink / raw)
To: [email protected]
ver 8.4
i create two table with same name named 'testtable'
one is temp table
i select * from testtable
then this table is a public or a temp ???
drop table testtable
then is this table a public or a temp? i test ,it drop temp table fisrst!
so am i must show public or pg_temp_1 when i has two table with same name
!!!
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
@ 2009-05-06 17:59 ` Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Robert Gravsjö @ 2009-05-06 17:59 UTC (permalink / raw)
To: liuzg4 liuzg4 <[email protected]>; +Cc: [email protected]
On 2009-05-06 14.34, liuzg4 liuzg4 wrote:
> ver 8.4
> i create two table with same name named 'testtable'
>
> one is temp table
>
>
>
> i select * from testtable
> then this table is a public or a temp ???
Temp. To access public use "select * from public.testtable".
"Temporary tables exist in a special schema, so a schema name cannot be
given when creating a temporary table."
See http://www.postgresql.org/docs/8.4/static/sql-createtable.html for
details.
/r
> drop table testtable
>
> then is this table a public or a temp? i test ,it drop temp table fisrst!
>
> so am i must show public or pg_temp_1 when i has two table with same name
> !!!
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
@ 2009-05-06 19:23 ` Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-06 19:23 UTC (permalink / raw)
To: Robert Gravsjö <[email protected]>; +Cc: liuzg4 liuzg4 <[email protected]>; [email protected]
Robert Gravsjö escribió:
> On 2009-05-06 14.34, liuzg4 liuzg4 wrote:
>> ver 8.4
>> i create two table with same name named 'testtable'
>>
>> one is temp table
>>
>> i select * from testtable
>> then this table is a public or a temp ???
>
> Temp. To access public use "select * from public.testtable".
>
> "Temporary tables exist in a special schema, so a schema name cannot be
> given when creating a temporary table."
Note that you can refer to the temp table like this:
select * from pg_temp.testtable;
Also, you can make the non-temp table first in the search path by
putting pg_temp later than the public schema (or wherever you have
created the function):
select * from testtable; -- refers to temp
set search_path to 'public', 'pg_temp';
select * from testtable; -- refers to non-temp
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-06 19:27 ` Alvaro Herrera <[email protected]>
2009-05-06 19:45 ` Re: [GENERAL] how to select temp table David Fetter <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
0 siblings, 2 replies; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-06 19:27 UTC (permalink / raw)
To: Robert Gravsjö <[email protected]>; +Cc: liuzg4 liuzg4 <[email protected]>; pgsql-docs
Alvaro Herrera escribió:
> Note that you can refer to the temp table like this:
>
> select * from pg_temp.testtable;
BTW I found no mention of pg_temp in the doc page here:
http://www.postgresql.org/docs/current/static/ddl-schemas.html
Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-06 19:45 ` David Fetter <[email protected]>
2009-05-06 20:58 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: David Fetter @ 2009-05-06 19:45 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
On Wed, May 06, 2009 at 03:27:28PM -0400, Alvaro Herrera wrote:
> Alvaro Herrera escribió:
>
> > Note that you can refer to the temp table like this:
> >
> > select * from pg_temp.testtable;
>
> BTW I found no mention of pg_temp in the doc page here:
> http://www.postgresql.org/docs/current/static/ddl-schemas.html
>
> Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
That's probably not a good omission. Any ideas as to where further
mentions should go?
Cheers,
David.
--
David Fetter <[email protected]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [email protected]
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:45 ` Re: [GENERAL] how to select temp table David Fetter <[email protected]>
@ 2009-05-06 20:58 ` Alvaro Herrera <[email protected]>
0 siblings, 0 replies; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-06 20:58 UTC (permalink / raw)
To: David Fetter <[email protected]>; +Cc: Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
David Fetter escribió:
> On Wed, May 06, 2009 at 03:27:28PM -0400, Alvaro Herrera wrote:
> > Alvaro Herrera escribió:
> >
> > > Note that you can refer to the temp table like this:
> > >
> > > select * from pg_temp.testtable;
> >
> > BTW I found no mention of pg_temp in the doc page here:
> > http://www.postgresql.org/docs/current/static/ddl-schemas.html
> >
> > Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
>
> That's probably not a good omission. Any ideas as to where further
> mentions should go?
I think mentioning it in the page I link to above would be good. I
can't think of any further places on which it should be mentioned.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-06 20:46 ` Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: Tom Lane @ 2009-05-06 20:46 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Alvaro Herrera <[email protected]> writes:
> Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
It's also described under the search_path GUC.
regards, tom lane
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
@ 2009-05-06 20:53 ` Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-06 20:53 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Tom Lane escribió:
> Alvaro Herrera <[email protected]> writes:
> > Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
>
> It's also described under the search_path GUC.
Hmm, we have another problem then, which is that GUC vars are not
showing in the search results when you search for their names. For
example if I search for search_path I am suggested
http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH
but nothing else.
Oh, I see the problem .. the index entry is "search_path configuration
parameter". I think it would be better if it were
<primary>search_path</><secondary>configuration parameter</>
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-06 21:11 ` Tom Lane <[email protected]>
2009-05-06 21:19 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Tom Lane @ 2009-05-06 21:11 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Alvaro Herrera <[email protected]> writes:
> Hmm, we have another problem then, which is that GUC vars are not
> showing in the search results when you search for their names. For
> example if I search for search_path I am suggested
> http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH
> but nothing else.
> Oh, I see the problem .. the index entry is "search_path configuration
> parameter". I think it would be better if it were
> <primary>search_path</><secondary>configuration parameter</>
Seems like what you are describing is a bug in the search engine,
not a problem we must address by doubling the vertical space needed for
literally hundreds of index entries.
regards, tom lane
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
@ 2009-05-06 21:19 ` Alvaro Herrera <[email protected]>
2009-05-07 13:44 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-06 21:19 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs; Magnus Hagander <[email protected]>
Tom Lane escribió:
> Alvaro Herrera <[email protected]> writes:
> > Hmm, we have another problem then, which is that GUC vars are not
> > showing in the search results when you search for their names. For
> > example if I search for search_path I am suggested
> > http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH
> > but nothing else.
>
> > Oh, I see the problem .. the index entry is "search_path configuration
> > parameter". I think it would be better if it were
>
> > <primary>search_path</><secondary>configuration parameter</>
>
> Seems like what you are describing is a bug in the search engine,
> not a problem we must address by doubling the vertical space needed for
> literally hundreds of index entries.
Yeah, perhaps ... I think it should suggest all index entries that
start with the search string, not necessarily equal.
Magnus? :-)
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 21:19 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-07 13:44 ` Magnus Hagander <[email protected]>
2009-05-07 15:17 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Magnus Hagander @ 2009-05-07 13:44 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: Tom Lane <[email protected]>; Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Alvaro Herrera wrote:
> Tom Lane escribió:
>> Alvaro Herrera <[email protected]> writes:
>>> Hmm, we have another problem then, which is that GUC vars are not
>>> showing in the search results when you search for their names. For
>>> example if I search for search_path I am suggested
>>> http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH
>>> but nothing else.
>>> Oh, I see the problem .. the index entry is "search_path configuration
>>> parameter". I think it would be better if it were
>>> <primary>search_path</><secondary>configuration parameter</>
>> Seems like what you are describing is a bug in the search engine,
>> not a problem we must address by doubling the vertical space needed for
>> literally hundreds of index entries.
>
> Yeah, perhaps ... I think it should suggest all index entries that
> start with the search string, not necessarily equal.
>
> Magnus? :-)
Uh, I don't think that information is even available at that point. We
index only the output of the web pages, not the SGML source.
//Magnus
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 21:19 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-07 13:44 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
@ 2009-05-07 15:17 ` Alvaro Herrera <[email protected]>
2009-05-07 15:23 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-07 15:17 UTC (permalink / raw)
To: Magnus Hagander <[email protected]>; +Cc: Tom Lane <[email protected]>; Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Magnus Hagander escribió:
> Alvaro Herrera wrote:
> > Yeah, perhaps ... I think it should suggest all index entries that
> > start with the search string, not necessarily equal.
> >
> > Magnus? :-)
>
> Uh, I don't think that information is even available at that point. We
> index only the output of the web pages, not the SGML source.
AFAIK the search "suggests" stuff from pg_docbot or something similar.
That includes index entries.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 21:19 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-07 13:44 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
2009-05-07 15:17 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-07 15:23 ` Magnus Hagander <[email protected]>
2009-05-07 15:28 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Magnus Hagander @ 2009-05-07 15:23 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: Tom Lane <[email protected]>; Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
On 7 maj 2009, at 17.17, Alvaro Herrera <[email protected]>
wrote:
> Magnus Hagander escribió:
>> Alvaro Herrera wrote:
>
>>> Yeah, perhaps ... I think it should suggest all index entries that
>>> start with the search string, not necessarily equal.
>>>
>>> Magnus? :-)
>>
>> Uh, I don't think that information is even available at that point.
>> We
>> index only the output of the web pages, not the SGML source.
>
> AFAIK the search "suggests" stuff from pg_docbot or something similar.
> That includes index entries.
>
The docbot index is completely manually maintained. It never reads
anything in our documetation.
/Magnus
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 21:19 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-07 13:44 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
2009-05-07 15:17 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-07 15:23 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
@ 2009-05-07 15:28 ` Alvaro Herrera <[email protected]>
2009-05-08 11:34 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Alvaro Herrera @ 2009-05-07 15:28 UTC (permalink / raw)
To: Magnus Hagander <[email protected]>; +Cc: Tom Lane <[email protected]>; Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Magnus Hagander escribió:
> On 7 maj 2009, at 17.17, Alvaro Herrera <[email protected]>
> wrote:
>
>> Magnus Hagander escribió:
>>> Alvaro Herrera wrote:
>>
>>>> Yeah, perhaps ... I think it should suggest all index entries that
>>>> start with the search string, not necessarily equal.
>>>
>>> Uh, I don't think that information is even available at that point.
>>> We
>>> index only the output of the web pages, not the SGML source.
>>
>> AFAIK the search "suggests" stuff from pg_docbot or something similar.
>> That includes index entries.
>
> The docbot index is completely manually maintained. It never reads
> anything in our documetation.
So where does the "we suggest this link" data come from?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [GENERAL] how to select temp table
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Re: how to select temp table Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Re: how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 20:53 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Re: [GENERAL] how to select temp table Tom Lane <[email protected]>
2009-05-06 21:19 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-07 13:44 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
2009-05-07 15:17 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
2009-05-07 15:23 ` Re: [GENERAL] how to select temp table Magnus Hagander <[email protected]>
2009-05-07 15:28 ` Re: [GENERAL] how to select temp table Alvaro Herrera <[email protected]>
@ 2009-05-08 11:34 ` Magnus Hagander <[email protected]>
0 siblings, 0 replies; 15+ messages in thread
From: Magnus Hagander @ 2009-05-08 11:34 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: Tom Lane <[email protected]>; Robert Gravsjö <[email protected]>; liuzg4 liuzg4 <[email protected]>; pgsql-docs
Alvaro Herrera wrote:
> Magnus Hagander escribió:
>> On 7 maj 2009, at 17.17, Alvaro Herrera <[email protected]>
>> wrote:
>>
>>> Magnus Hagander escribió:
>>>> Alvaro Herrera wrote:
>>>>> Yeah, perhaps ... I think it should suggest all index entries that
>>>>> start with the search string, not necessarily equal.
>>>> Uh, I don't think that information is even available at that point.
>>>> We
>>>> index only the output of the web pages, not the SGML source.
>>> AFAIK the search "suggests" stuff from pg_docbot or something similar.
>>> That includes index entries.
>> The docbot index is completely manually maintained. It never reads
>> anything in our documetation.
>
> So where does the "we suggest this link" data come from?
A manually maintained database. That is regularly (as in, has been once)
synced over from the IRC bot database. Which is, again, manually
maintained by ppl in the irc channel.
//Magnus
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2009-05-08 11:34 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-05-06 12:34 how to select temp table liuzg4 liuzg4 <[email protected]>
2009-05-06 17:59 ` Robert Gravsjö <[email protected]>
2009-05-06 19:23 ` Alvaro Herrera <[email protected]>
2009-05-06 19:27 ` Alvaro Herrera <[email protected]>
2009-05-06 19:45 ` David Fetter <[email protected]>
2009-05-06 20:58 ` Alvaro Herrera <[email protected]>
2009-05-06 20:46 ` Tom Lane <[email protected]>
2009-05-06 20:53 ` Alvaro Herrera <[email protected]>
2009-05-06 21:11 ` Tom Lane <[email protected]>
2009-05-06 21:19 ` Alvaro Herrera <[email protected]>
2009-05-07 13:44 ` Magnus Hagander <[email protected]>
2009-05-07 15:17 ` Alvaro Herrera <[email protected]>
2009-05-07 15:23 ` Magnus Hagander <[email protected]>
2009-05-07 15:28 ` Alvaro Herrera <[email protected]>
2009-05-08 11:34 ` Magnus Hagander <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox