query question

Started by chris mutchlerover 25 years ago2 messagesgeneral
Jump to latest
#1chris mutchler
davron@leibnizcreations.com

I am new to using postgresql and have the following question. if i submit
a query (through a perl script), what values (and in what order) will be
returned to me? here is my query:

SELECT p.ids_name, m.start_time, m.end_time
FROM mail_schedule m, personnel p
WHERE p.ids_int = m.ids_int AND
m.dow = $weekday AND
$timestamp BETWEEN m.start_time AND m.end_time
UNION
SELECT p.ids_name, c.on_start, c.on_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int AND
$timestamp BETWEEN c.on_start AND c.on_end
EXCEPT
SELECT p.ids_name, c.off_start, c.off_end
FROM mail_changes c, personnel p
WHERE p.ids_int = c.ids_int AND
$timestamp BETWEEN c.off_start AND c.off_end

thanks in advance for any assistance you can provide.
chris mutchler
davron@leibnizcreations.com

#2Steve Heaven
steve@thornet.co.uk
In reply to: chris mutchler (#1)
migrating test db -> live db

We run several web based postgresql applications and find it difficult to
make changes in a safe and reliable manner.

We have test databases that mirror the live ones. When we have finished
making the testing the updated version, we labouriously go through and copy
all the changes onto the live system. Obviously the live system has to be
taken down during this.
Is is possible to do the following:

stop postmaster
copy all files from ~postgres/base/testdb/* -> ~postgres/base/livedb/*
restart postmaster

All the tables, indexes etc have the same names in both, but we may
add/alter columns for the new version.

Thanks

Steve

--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk