Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> writes:
>> After you've created at least one temp table, you can look at the result
>> of "current_schemas(true)". There's no guarantee that the schema even
>> exists before you've created something...
> Is there a guaranteed order of the resulting array, i.e. is this guaranteed to
> return the temp schema, given there is one:
> 'select (current_schemas(true))'.....?
Yes, in the current implementation and for the foreseeable future (else
temp tables would fail to mask permanent tables).
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Jonathan Albert C. Vallar||Date: 2006-02-28 03:51:20|
|Subject: BUG #2288: bad value for type timestamp using JDBC Type2 Driver version 8.1-405|
|Previous:||From: Frank van Vugt||Date: 2006-02-27 21:54:53|
|Subject: Re: has_table/schema_privilige() returns incorrect info on temp tables|