If it worked in 9.3.22 and now it's failed in 9.3.22, then I'd look to see
if something has changed in data.sql.
On 03/27/2018 06:22 AM, Blake McBride wrote:
Hi,
I have been using PostgreSQL for many years but all of a sudden a db load
script I've been using no longer works. What id does (essentially) is:
psql postgres postgres
drop database test;
create database test;
\c test
\i data.sql
\dt
\q
I tested this with a small data.sql and it worked fine. However, when I
use a real (much larger) data.sql then \dt replies "No relations" ! I
found this if I stick an extra '\c test' after the '\i data.sql' it works.
The data.sql is a PostgreSQL dump from another database. When the '\i
data.sql' is done, the prompt still shows 'test#' so it's not like I've
changed databases.
I only have one schema, 'public'.
Can't figure out why a simple example works but a large file requires an
extra \c.
Sure appreciate any help.
Blake McBride
--
Angular momentum makes the world go 'round.
