Hi. I'm seeing a couple of strange things.
default encoding: unicode
locale: en_AU
running psql from localhost, I appear able to create a sequence, but I
get an error whenever I try to use it. This code runs fine on linux
(though the linux DB is v7.5.X).
In addition, the log snippet below shows more strangeness when I try
to create a new database. This is strange as the 'call' database was
itself created while running the attached script (starting in
template1). If it's important, the below code was run after the
attached code was run (with errors relating to the sequence)
call=# create sequence testseq;
CREATE SEQUENCE
call=# create table testtab1 (id integer default 1);
CREATE TABLE
call=# create table testtab2 (id integer default nextval('testseq'));
ERROR: could not open relation 1663/17270/16719: No such file or directory
call=# create database testdb
call-# ;
CREATE DATABASE
call=# \c testdb
could not receive server response to SSL negotiation packet: Software caused con
nection abort (0x00002745/10053)
Previous connection kept
call=# \c testdb
could not receive server response to SSL negotiation packet: Software caused con
nection abort (0x00002745/10053)
Previous connection kept