[GENERAL] How to sample records

data_ora | cod_wmo | t_aria | ur -+-++ 2006-07-05 12:00:00 | 16235 | 31.0 | 41 2006-07-06 11:50:00 | 16235 | 30.0 | 49 2006-07-05 12:00:00 | 16242 | 28.6 | 39 2006-07-06 10:15:00 | 16242 | 27.0 | 56 Please help this absolute beginner Ciao Vittorio

[GENERAL] Help to sample a table

6242 | 28.6 | 39 2006-07-06 10:15:00 | 16242 | 27.0 | 56 Please help this absolute beginner Ciao Vittorio ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Updating & inserting in one shot!

-insert into a table? Ciao Vittorio ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Problems with pgsql 8.0.4 & freebsd 6: partially solved

nsive warning comes up # /usr/local/etc/rc.d/010.pgsql.sh start --: not found Is there anything else I could do? Ciao Vittorio ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] crosstab doesn't work

eger, att2 integer); ERROR: query-specified return row and actual function return row do not match Please help I'm in badly need of the crosstab function. Ciao Vittorio ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] psql runs out of memory

Alle 15:07, mercoledì 19 ottobre 2005, Richard Huxton ha scritto: > Vittorio wrote: > > In my Pentium 4 box 2GHz with 256 MB of RAM I run a pg server 8.0.3 > > under netbsd 2.0.2 in which among other tables there's a "huge" table > > letture02 made of 657,

[GENERAL] psql runs out of memory

ran it successfully many times. Besides, via ODBC I can open as a table the letture24btnondom view without any problems. What should I do for psql? Ciao Vittorio letture24btnondom view: SELECT letture02. contatore, letture02.data, (letture02.let1 + letture02.let2 + letture02. let3 + letture02.l

[GENERAL] Number of rows of a table

Using psql how can I ask postgresql to show the actual number of rows of a table? Ciao Vittorio ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_dump warnings

rtunately, having only one server, I dumped the db from FreeBSD into the office LAN via SAMBA then I compiled linux gentoo on the same server eliminating FreeBSD. Finally I restored the db from the SAMBA share into the new linux box. Therefore, what I now see is that \dt atecu91 gives no owner. H

Re: [GENERAL] cron & backup

f I had to guess on your probem above, i'd say it could be a $PATH > issue, since you're not specifying the path for vacuumdb. Lonni, you were right! The only problem was the absence of the directories of the command vacuumdb and pg_dump. I added the Iusr/local/bin/ prefic to both and now

Re: [GENERAL] cron & backup

to guess on your probem above, i'd say it could be a $PATH > issue, since you're not specifying the path for vacuumdb. You were right! The only problem was the absence of the directories of the command vacuumdb and pg_dump. I added the Iusr/local/bin/ prefic to both and now it all works smoothly. Thanks Vittorio ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Best Linux Distribution

ntoo with which you can prepare your linux box from scratch by compiling everything according to your needs (it isn't enough to have a binary linux distribituion installed and only postgresql compiled from sources). Ciao Vittorio ---(end of broadcast)-