On Tue, 28 Oct 2003, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Is it possible to remove the implicit search path of pg_catalog from a
> > psql session without it breaking lots of stuff?
>
> Do you consider "+", "count
On Tue, 28 Oct 2003, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > I say leave it the way it is. If you want system table tab completion,
> > simply:
> > ALTER USER ... SET search_path =3D pg_catalog,...;
>
> Unfortunately, that *does not* affect the tab-completion behavior
Just two minor issues with timestamps:
Error message is currently:
create table test (ts timestamp);
-- insert an illegal date:
insert into test values ('20021131');
invalid input syntax for timestamp: "20021131"
SQL92 and 99 say it should be:
data exception-datetime field overflow
No big dea
Oh, and the error message listed in SQL92 for out of range timezone is:
data exception-invalid time zone displacement value
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
