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

From: "minfrin(at)sharp(dot)fm" <root(at)localhost(dot)localdomain>
To: undisclosed-recipients:;
Subject:
Date: 2002-03-16 15:32:11
Message-ID: 200203161532.g2GFWBU04037@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports(at)postgresql(dot)org(dot)

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches(at)postgresql(dot)org instead.  Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Graham Leggett
Your email address	:	minfrin(at)sharp(dot)fm


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	: PPC G3

  Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.4.18pre1

  PostgreSQL version (example: PostgreSQL-7.1.3): PostgreSQL-7.1.3

  Compiler used (example:  gcc 2.95.2)		:


Please enter a FULL description of your problem:
------------------------------------------------

COPY complains that a relation does not exist, just after that table
is created.



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------

If the following file contents are issued to psql:

CREATE SEQUENCE "ContainerDetail_sequence" start 27 increment 1 maxvalue 2147483647
minvalue 1  cache 1 ;

CREATE TABLE ContainerDetail (
	RecordID int DEFAULT nextval('ContainerDetail_sequence') NOT NULL,
	PackList varchar (35)  NOT NULL ,
	ExternalDim varchar (35)  NULL ,
	InternalDim varchar (35)  NULL ,
	ExternalVol decimal(18, 4) NULL ,
	InternalVol decimal(18, 4) NULL
)
;

COPY "ContainerDetail" FROM '/tmp/ContainerDetail' USING DELIMITERS ',';

The above bombs out like so:

CREATE
CREATE
ERROR:  Relation 'ContainerDetail' does not exist

(Unless I am doing something really stupid) the error is saying that a table
does not exist when it does.

The same problem exists if the data is imported from stdin.



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------



pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-03-16 17:18:03
Subject: Bug #621: why postgreSQL stored databases in digital filenames?
Previous:From: Vadim MikheevDate: 2002-03-16 06:04:09
Subject: Re: [BUGS] Bug #613: Sequence values fall back to previously chec

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