| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
| Cc: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Two 'identical' DB's not acting identically |
| Date: | 2003-04-15 13:43:53 |
| Message-ID: | 7513.1050414233@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> I forgot to mention that the test db was created this way:
> - on the live db do a pg_dump TAL > dump
> - copy dump file to test database server
> - on the test db do a createdb TEST; psql TEST < dump
> This way the two dbs will have the schemas no?
You would think they'd be the same ...
Are both servers the same version of Postgres? (And which version would
that be, exactly?) Does EXPLAIN of the problem query show the same
results on both?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-15 13:51:18 | Re: Two 'identical' DB's not acting identically |
| Previous Message | Dave Cramer | 2003-04-15 13:40:29 | qualified column names |