column test.a
CREATE TABLE
Table public.test
Column | Type |Modifiers
+--+--
a | smallint | not null default nextval('test_a_seq'::regclass)
--
JC de Villa
SELECT age(dob);
Should give you
age
-
31 years 5 mons 17 days
If you want to be really exact about it. :)
JC de Villa
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On Tue, Oct 27, 2009 at 6:31 PM, Alvaro Herrera
alvhe...@commandprompt.comwrote:
JC Praud escribió:
So my question are: can the autovacuum daemon perform vacuum full ? Or
another internal postgres process ? Could it come from the TRUNCATE I run
and canceled 4 days before
Sorry, I got a bit lost in the thread. BTW, Thanks for all the answers :)
On Wed, Oct 28, 2009 at 12:29 AM, Alvaro Herrera alvhe...@commandprompt.com
wrote:
JC Praud escribió:
- Last night the database locked. pg_log full of messages about insert
into
the mother table waiting for a lock
the unlock.
So my question are: can the autovacuum daemon perform vacuum full ? Or
another internal postgres process ? Could it come from the TRUNCATE I run
and canceled 4 days before ?
I'm running postgresql-8.3.7
Regards,
--
JC
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl
will need it also on 8.4
Regards,
--
JC
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!
Hi there,
1. As I have installed thePostgreSQL
8.0.2in French, when I start "psql to template1" in console mode, I
receive a message telling that my code page 850 is not the one of the
application (1252) and consequently the display could be erroneous. It's true,
all the accented