[ADMIN] Backup and Restore

2003-06-05 Thread David A. Leedom
I am using 7.2.x. When I run pg_dump on a database the objects are not loaded in the correct dependency order. S when I run pg_restore it fails because objects that are needed have not been restored yet (ie. trieds to restore a view that points to a table that has not yet been restored

Re: [ADMIN] capture vacuumdb verbose output

2003-06-05 Thread Shankar K
Thanks Jonathan, tom... --- Jonathan Gardner <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Monday 02 June 2003 12:25, Tom Lane wrote: > > Shankar K <[EMAIL PROTECTED]> writes: > > > i'm trying to log the verbose output of vaccumdb > to a > > > file along with

Re: [ADMIN] ALTER TABLE

2003-06-05 Thread Victor Yegorov
* Martins Zarins <[EMAIL PROTECTED]> [05.06.2003 10:18]: > Hello! > Can someone explain me, why last ALTER fails? > > work=# \d rdu > Table "rdu" >Column|Type | Modifiers > >

Re: [ADMIN] ALTER TABLE

2003-06-05 Thread A.Bhuvaneswaran
> work=# ALTER TABLE rdu ADD CONSTRAINT rdu_finish_time CHECK ((start_time <= > finish_time) OR finish_time IS NULL); > ERROR: AlterTableAddConstraint: rejected due to CHECK constraint > rdu_finish_time I can say that the field, finish_time have the values which conflict with the check constrai

[ADMIN] Urgent Help Needed !!!!!!!

2003-06-05 Thread Anagha Joshi
Hi, Pls. let me know immediately from which version of Postgres … C++ interfaces are moved to  the libpqxx PostgreSQL Projects.  Libpqxx is C++ client API for PostgreSQL. The standard front-end (in the sense of "language binding") for writing C++ programs that use PostgreSQL. Supersedes

[ADMIN] ALTER TABLE

2003-06-05 Thread Martins Zarins
Hello! Can someone explain me, why last ALTER fails? work=# \d rdu Table "rdu" Column|Type | Modifiers -+-+-

[ADMIN] interpret vacuum verbose output

2003-06-05 Thread Shankar K
hi all, I'm trying to evaluate the frequecy to run vacuum analyze on key tables. so if anyone could help me to interpret the output of vacuum analyze verbose output that would be great. below is the output of one of our major indexes. INFO: --Relation public.accounts-- INFO: Index accounts_u1

Re: [ADMIN] capture vacuumdb verbose output

2003-06-05 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 02 June 2003 12:25, Tom Lane wrote: > Shankar K <[EMAIL PROTECTED]> writes: > > i'm trying to log the verbose output of vaccumdb to a > > file along with other details, but i only end up with > > logging this > > I think that output will go t

[ADMIN] (OOT) test only

2003-06-05 Thread Eko Pranoto
test only === "TELKOMNet Instan memberikan diskon 40% untuk akses malam hari dari pukul 23.00 sampai 06.00. Berlaku untuk wilayah Jawa Timur mulai 1 Mei 2003 sampai 30 Juni 2003." ==