recently, my dsl provider went out of business, currently, I am using dial-up and I need to build indexes of a very large database table. this take a few hours...
i used psql via ssh on dial-up and closed the ssh client. I logged in again and it showed that the postmater process was still running.
First, sorry for the OT, flame me off-list!
I'm a sysadmin being impressed into dba service. i've been getting along
pretty well writing queries and making reports, but i've got some questions.
suggestions for a good list/forum for help?
from two tables both with email_addr columns, i want a dist
Somebody gimme your hand plz.
Using my previous Database I used to be
like that;
" ALTER TRIGGER tr_T_DtlPO ON
dbo.T_DtlPO FOR UPDATE AS
bla..bla..bla...
IF @OldQty <> @NewQty
BEGIN
ROLLBACK
INSERT
INTO T_My_ListError(fc_code,fv_descript)
VALUES('12345','No
I've never really used this site but it might be of interest:
http://www.dbforums.com/
You may also want to check out "SQL Queries for Mere Mortals"
(Hernandez/Viescas - Addison Wesley)
-Steve
On Thursday 16 January 2003 2:15 pm, Tim Lynch wrote:
> First, sorry for the OT, flame me off-list!
there are several ways to do this, one example would be:
select distinct(email_addr) from table1
union
select distinct(email_addr) from table2
You can ask questions like these on the pgsql-newbies or pgsql-sql lists
if you'd like (though generally you shouldn't get flamed no matter which
group yo
On Thu, Jan 16, 2003 at 14:15:22 -0800,
Tim Lynch <[EMAIL PROTECTED]> wrote:
> First, sorry for the OT, flame me off-list!
>
> I'm a sysadmin being impressed into dba service. i've been getting along
> pretty well writing queries and making reports, but i've got some questions.
> suggestions for
you should be able to do something like:
select distinct email from test1
union (select distinct email from test2);
regards,
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474
"Tim Lynch" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/16/2003 04:15 PM
Hi All,
Is There any function to get Difference of Dates.
Here tdate is of type timestamp
If I tried
select * from temptbldate WHERE (EXTRACT(EPOCH FROM TIMESTAMP 'now()') -
EXTRACT(EPOCH FROM TIMESTAMP tdate) )/ 86400 < 2
I got error as 'Parse error at tdate'
select * from temptbldate WHERE
Hi All,
I got solution from the following link.
http://techdocs.postgresql.org/techdocs/faqdatesintervals.php
Thanks,
Sreedhar
- Original Message -
From: "shreedhar" <[EMAIL PROTECTED]>
To: "Postgres" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 3:06 PM
Subject: [ADMIN] Is There
On Wed, 15 Jan 2003 11:19:29 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Andre Schubert <[EMAIL PROTECTED]> writes:
> > Ok, but is there another way to enable STATS_ROW_LEVEL for a special
> > backend not connecting as superuser ?
>
> No: the code is deliberately designed to prevent that, on the
Hi,
Is there any command to find database server local time zone
alone.
SHOW TIME ZONE just displays database servers local time zone.
But I need to hold output of SHOW TIME ZONE in a variable, to
convert the input given in GMT to database server time zone.
Is there any other way to get databa
what abt:
select * from temptbldate WHERE current_date - date(tdate) < CAST ('2 days' AS
INTERVAL) ;
?
regds
mallah.
(EXTRACT(EPOCH FROM TIMESTAMP 'now()') -
EXTRACT(EPOCH FROM TIMESTAMP tdate) )/ 86400 < 2
On Thursday 16 January 2003 03:06 pm, shreedhar wrote:
> Hi All,
>
> Is There
On Thu, Jan 16, 2003 at 10:58:24 -,
d ravipati <[EMAIL PROTECTED]> wrote:
> Hi,
> Is there any command to find database server local time zone
> alone.
>
> SHOW TIME ZONE just displays database servers local time zone.
> But I need to hold output of SHOW TIME ZONE in a variable, to
> co
Have you tried age(now(), tdate)? Or just:
.where now()-tdate < '2 days'
Cheers,
Steve
On Thursday 16 January 2003 1:36 am, shreedhar wrote:
> Hi All,
>
> Is There any function to get Difference of Dates.
>
> Here tdate is of type timestamp
>
> If I tried
>
> select * from temptbldate WHERE
> i used psql via ssh on dial-up and closed the ssh client. I logged in
again and it showed that the postmater process was still running.. I thought
that the index building process would continue 'til completion.
try
( echo '´CREATE INDEX blablabla' | psql database >> log.txt ) &
on your (bash)
Christopher Smith <[EMAIL PROTECTED]> writes:
> i used psql via ssh on dial-up and closed the ssh client. I logged in
> again and it showed that the postmater process was still running.. I
> thought that the index building process would continue 'til
> completion.
> however, this morning no indexe
Hello All,
I am using Java J2EE with CMP 2.0 with finders and
selectors with a JBoss 3.0.4 application server and
would like to determine which queries and other DML
are being executed the most. I have thought about
setting up triggers to execute and populate a table
with that information every t
Filesystem Size Used Avail Use% Mounted on/dev/sdb1 17G 2.0G 13G 13% /var/lib/pgsql/data/dev/sdd1 17G 11G 5.2G 68% /datadir
correct disk space ran out. However, just one more question... on my test server the indexes are ~8G. I moved the data to be i
disk space ran out. Is it possible to predict the filename to be used for indexes and hence create a link to another open disk.
I think that the filename used are oids?
please advise
Tom Lane <[EMAIL PROTECTED]> wrote:
Christopher Smith <[EMAIL PROTECTED]>writes:> i used psql via ssh on dial-up a
> recently, my dsl provider went out of business, currently, I am
> using dial-up and I need to build indexes of a very large database
> table. this take a few hours...
>
> i used psql via ssh on dial-up and closed the ssh client. I logged
> in again and it showed that the postmater process was s
Christopher Smith <[EMAIL PROTECTED]> writes:
> disk space ran out. Is it possible to predict the filename to be used
> for indexes and hence create a link to another open disk.
No, but you might get some joy by adjusting the pgsql_tmp subdirectory
of your database to symlink to a temp directory
Somebody Help Me.
Using my previous Database I used to be
like that;
" ALTER TRIGGER tr_T_DtlPO ON
dbo.T_DtlPO FOR UPDATE AS
bla..bla..bla...
IF @OldQty <> @NewQty
BEGIN
ROLLBACK
INSERT
INTO T_My_ListError(fc_code,fv_descript)
VALUES('12345','No Authori
22 matches
Mail list logo
