Sequence creation bug: 8.0.0beta4 win32

From: Nick Farrell <nicholas(dot)farrell(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Sequence creation bug: 8.0.0beta4 win32
Date: 2004-10-27 02:33:50
Message-ID: d14a1dfc04102619334e27fdec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 Content-Type Size
simple.sql application/octet-stream 1.8 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jan Wieck 2004-10-27 03:37:28 Re: [Slony1-general] Thread-safety detection on HP-UX
Previous Message Sil Lee 2004-10-27 02:01:57 copy command PANIC in --encoding='utf8' createdb option