Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. PostgreSQL question about "etc/netdot.meta" file (William Bulley)
2. Re: PostgreSQL question about "etc/netdot.meta" file
(Anton Berezin)
3. Re: PostgreSQL question about "etc/netdot.meta" file
(William Bulley)
----------------------------------------------------------------------
Message: 1
Date: Thu, 8 May 2014 12:51:04 -0400
From: William Bulley <[email protected]>
Subject: [Netdot-devel] PostgreSQL question about "etc/netdot.meta"
file
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
There are several columns in several different tables of type "date".
In none of those columns is the "default" hash key given a default value.
Does anyone know how I might go about giving today's date as the
default value of a column of type "date"? Thanks in advance.
Regards,
web...
--
William Bulley Email: [email protected]
72 characters width template ----------------------------------------->|
------------------------------
Message: 2
Date: Thu, 8 May 2014 19:41:20 +0200
From: Anton Berezin <[email protected]>
Subject: Re: [Netdot-devel] PostgreSQL question about
"etc/netdot.meta" file
To: William Bulley <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
On Thu, May 08, 2014 at 12:51:04PM -0400, William Bulley wrote:
> There are several columns in several different tables of type "date".
>
> In none of those columns is the "default" hash key given a default value.
>
> Does anyone know how I might go about giving today's date as the
> default value of a column of type "date"? Thanks in advance.
default => \"curdate()",
should work for MySQL, while
default => \"current_date",
should work for Pg.
\Anton.
--
Our society can survive even a large amount of irrational regulation.
-- John McCarthy
------------------------------
Message: 3
Date: Thu, 8 May 2014 13:44:57 -0400
From: William Bulley <[email protected]>
Subject: Re: [Netdot-devel] PostgreSQL question about
"etc/netdot.meta" file
To: Anton Berezin <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
According to Anton Berezin <[email protected]> on Thu, 05/08/14 at 13:41:
>
> default => \"curdate()",
>
> should work for MySQL, while
>
> default => \"current_date",
>
> should work for Pg.
Thanks! I'll give it a try. :-)
Regards,
web...
--
William Bulley Email: [email protected]
72 characters width template ----------------------------------------->|
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 86, Issue 6
*******************************************
