Hello World!
I´m trying to migrate a database
from one server to another but I got a hard problem. All the tables
and sequences are migrated but the field last_value of ALL sequences is set to
1. Why this? The others fields of them are set correctly but last_value it not.
Is there a wa
Hello
am new to transactional sql (just moved from mysql) and would like to
use transactions and i want to ask about it here, when am in a
transaction block can i execute other queries on the server (that
table exactly) or shoudl i commit the transaction to free the table ?
---
On Tue, 2005-02-15 at 09:14, Zouari Fourat wrote:
> Hello
> am new to transactional sql (just moved from mysql) and would like to
> use transactions and i want to ask about it here, when am in a
> transaction block can i execute other queries on the server (that
> table exactly) or shoudl i commit
Is there a neat way to clean out a database via SQL commands?
i.e. get rid of tables, sequences, integers, etc.
At present I'm using dropdb/createdb, but thats' far from ideal
and I think it's causing postgres to do more mork than it needs to...
--
'My life, and by extension everyone else's, i
Dick Davies <[EMAIL PROTECTED]> writes:
> Is there a neat way to clean out a database via SQL commands?
> i.e. get rid of tables, sequences, integers, etc.
> At present I'm using dropdb/createdb, but thats' far from ideal
> and I think it's causing postgres to do more mork than it needs to...
Wel
* Tom Lane <[EMAIL PROTECTED]> [0232 16:32]:
> Dick Davies <[EMAIL PROTECTED]> writes:
> > Is there a neat way to clean out a database via SQL commands?
> > i.e. get rid of tables, sequences, integers, etc.
>
> > At present I'm using dropdb/createdb, but thats' far from ideal
> > and I think it's
How about just truncating all the tables?
Dick Davies wrote:
> * Tom Lane <[EMAIL PROTECTED]> [0232 16:32]:
>
>>Dick Davies <[EMAIL PROTECTED]> writes:
>>
>>>Is there a neat way to clean out a database via SQL commands?
>>>i.e. get rid of tables, sequences, integers, etc.
>>
>>>At present I'm u
If there are any foreign key constraints, you'll have to truncate the
tables in the appropriate order. You would also have to reset the
sequence values as well.
Naomi Walker wrote:
How about just truncating all the tables?
Dick Davies wrote:
* Tom Lane <[EMAIL PROTECTED]> [0232 16:32]:
Hi,
I am trying to get postgres working on a Dell and am finidng
my SQL queries run incrediably slow.
I have tried to adjust cache and buffers, etc with no luck.
Any advice on who would be best for help either it’s a
config issue or a query issue etc.
I been trying for a few weeks
Clinging to sanity, [EMAIL PROTECTED] (Dick Davies) mumbled into her beard:
> Is there a neat way to clean out a database via SQL commands?
>
> i.e. get rid of tables, sequences, integers, etc.
>
> At present I'm using dropdb/createdb, but thats' far from ideal
> and I think it's causing postgres t
On Tue, 2005-02-15 at 14:12, Joel Fradkin wrote:
> Hi,
>
>
>
> I am trying to get postgres working on a Dell and am finidng my SQL
> queries run incrediably slow.
>
> I have tried to adjust cache and buffers, etc with no luck.
>
> Any advice on who would be best for help either itâs a config
On Tue, 15 Feb 2005, Joel Fradkin wrote:
Hi,
I am trying to get postgres working on a Dell and am finidng my SQL queries
run incrediably slow.
I have tried to adjust cache and buffers, etc with no luck.
Any advice on who would be best for help either it's a config issue or a
query issue etc.
Us? :
I think Joel may be asking for a paid, dedicated consultant. Could be
wrong, but I know you folks are out there. --Rick
"Marc G. Fou
Us? :) Can you provide some more details?
Hardware configuration,
Dell 6560 4 processor, 8 gig memory, I think I have Postgres on two raids
separate from the OS (pgsql is a raid 10 4 10kdrive array) and /wal is 2 15k
drives). I am running postgres 8 and am using the conf in
/var/lib/pgslq/data
On Tue, 2005-02-15 at 15:21, Joel Fradkin wrote:
> Us? :) Can you provide some more details?
>
> Hardware configuration,
> Dell 6560 4 processor, 8 gig memory, I think I have Postgres on two raids
four processors, or two hyperthreaded cpus? My experience has been that
hyperthreading usually
On Tue, Feb 15, 2005 at 08:50:53AM -0300, Ricardo Valença de Assis wrote:
>
> I'm trying to migrate a database from one server to another but I got
> a hard problem. All the tables and sequences are migrated but the field
> last_value of ALL sequences is set to 1. Why this? The others fields of
>
16 matches
Mail list logo
