Skip site navigation (1) Skip section navigation (2)

Re: Sequence creation bug: 8.0.0beta4 win32

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: nfarrell(at)eml(dot)cc
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Sequence creation bug: 8.0.0beta4 win32
Date: 2004-11-27 04:49:13
Message-ID: 200411270449.iAR4nDS02245@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)postgresql(dot)org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2004-11-27 05:03:01
Subject: Re: [BUGS] solaris non gcc compiler debug options
Previous:From: Bruce MomjianDate: 2004-11-27 04:33:14
Subject: Re: [BUGS] pg_autovacuum in 8beta-dev3 small bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group