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
simple.sql
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
