I could not reproduce any of your problems on Win32 or Unix. Are you
still seeing these failures?
---------------------------------------------------------------------------
Nick Farrell wrote:
> 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
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073