st(a smallserial);
NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for serial
column "test.a"
CREATE TABLE
Table "public.test"
Column | Type |Modifiers
----+--+--
a | smallint | not null default nextval('test_a_seq'::regclass)
--
JC de Villa
g with a view that calls
> date_trunc('year', now() - dob).
>
> If you must store the age then you have to run a daily batch to make the
> bulk update.
Theres also the age() function
SELECT age(dob);
Should give you
age
-
31 years 5 m
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 wrote:
> JC Praud escribió:
>
> > - Last night the database locked. pg_log full of messages about insert
> into
> > the mother table waiting for a lo
On Tue, Oct 27, 2009 at 6:31 PM, Alvaro Herrera
wrote:
> 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 ?
>
&g
after 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
the 8.3. But I 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 the PostgreSQL
8.0.2 in 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 charac
