Re: [SQL] cannot create sequence
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, ...); What is the *exact* text of the error message? (That ain't it.) I am guessing that a Unix file matching the desired sequence name got left around in your database directory, and that removing this file would allow you to create the sequence. However, I can't duplicate any such problem by following the procedure you describe in 7.0.2... regards, tom lane -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com
Re: [SQL] cannot create sequence
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 the *exact* text of the error message? (That ain't it.) I am guessing that a Unix file matching the desired sequence name got left around in your database directory, and that removing this file would allow you to create the sequence. However, I can't duplicate any such problem by following the procedure you describe in 7.0.2... regards, tom lane -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com
Re: [SQL] cannot create sequence
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
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 the date. Instead, use the to_char builtin function, as defined in the docs: http://www.postgresql.org/users-lounge/docs/7.0/postgres/functions2976.htm Share Enjoy! -Josh Berkus -- __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
[SQL] Re: [ADMIN] TPCH questions
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
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 tup_num, int field_num); int GetIsNull(int tup_num, const char* field_name); int GetLine(char* string, int length); void PutLine(const char* string); const char* OidStatus(); int EndCopy(); I would like to complete the documentation at these points, and maybe add some small example C++ programs. In which form should I write the documentation and where should I send it? (I have no possibility at the moment to test SGML documents, i.e. convert them to HTML.) Regards, Volker Paul