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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-11-27 05:03:01 | Re: [BUGS] solaris non gcc compiler debug options |
Previous Message | Bruce Momjian | 2004-11-27 04:33:14 | Re: [BUGS] pg_autovacuum in 8beta-dev3 small bug |