Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
hi there, good guess, they are still there. can i just delete them? olaf Tom Lane schrieb: Olaf Zanger [EMAIL PROTECTED] writes: it doesn't show ver_id_seq, nor own_id_seq when doing a \ds but it brings up an error "cannot create sequence) if i want to create table ver (id serial,

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
um, sorry, forgot to ask then this is a bug eh :- ? olaf Tom Lane schrieb: Olaf Zanger [EMAIL PROTECTED] writes: it doesn't show ver_id_seq, nor own_id_seq when doing a \ds but it brings up an error "cannot create sequence) if i want to create table ver (id serial, ...); What is

Re: [SQL] cannot create sequence

2001-02-15 Thread Tom Lane
Olaf Zanger [EMAIL PROTECTED] writes: good guess, they are still there. can i just delete them? Yes, if there's not any corresponding system-catalog entry for them. regards, tom lane

Re: [SQL] problem with casting

2001-02-15 Thread Josh Berkus
Ted, responce: can not cast type 'date' to 'text' Did i miss-read this section. I thought I could cast the date to text. has anyone seen this or am I missreading the docs? 'fraid so. You cannot cast Date as Text, because (presumably) the DB engine doesn't know how you want to format

[SQL] Re: [ADMIN] TPCH questions

2001-02-15 Thread Peter Eisentraut
Victor Muntes Mutero writes: select * from (select * from supplier); (for example) No subselects in FROM before 7.1. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [SQL] C/C++ interface

2001-02-15 Thread Volker Paul
Tom Lane wrote: Volker Paul [EMAIL PROTECTED] writes: Is someone maintaining the C++ interface and its documentation? Not really. Feel free to step up and lend a hand ... I found some functions of the C++ binding library that are not or scarcely documented, namely: int GetIsNull(int