Bruce Momjian <[EMAIL PROTECTED]> writes:
> OK, I did a little research on this. It turns out that this code in
> vacuum.c:
> if (vacstmt->verbose)
> MESSAGE_LEVEL = NOTICE;
> else
> MESSAGE_LEVEL = DEBUG;
> controls whether the message comes out as a NOTICE or a DEBUG
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> where the backend automatically assumes that a relative path is relative
>> to $PGLIB. I'd like to see the backend adding the file extension too,
>> to avoid platform dependencies (".so" is not universal).
> We could have a run-t
On 08 May 2001 10:31:17 -0400, Vince Vielhaber wrote:
> > http://hermes.swu.bg/postgres/postgres/sql-altertable.htm
> > The correct syntax is:
> > ALTER TABLE foobar add column address varchar(50);
> > ALTER TABLE foobar alter column address set default 'none';
>
> If this:
>
> alter table fooba
On 05 May 2001 12:23:37 -0400, [EMAIL PROTECTED] wrote:
> Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Alter table add column ignores default
>
> Long Description
> Alter table add column ignores the
I am altering the source to ISO dates ... makes it easier as I am using
'copy from'
to do the bulk uploads :)
> The algorithm for interpreting dates is in an appendix in the User's
> Guide. Does this behavior match your reading of that writeup?
Yes, that's okay - I just had a one-off case that co
> > In 7.0.3, I'm converting seconds from midnight to a time of
> > day using interval ( 'seconds '). This worked fine in
> > 7.0.3 and gives a Bad interval external representation message
> > in 7.1.
> This has never been the intended or documented format; it should
> be ' seconds'. Allowing bo
