Forwarded to HACKERS and BUGS lists.
> Dear postgreSQL developers,
>
> I like your postgreSQL very much, but I have some problems. Please
> help
> me!
>
> My first problem:
> If I create end destroy a table several times (for instance
> table
> ANALOG), after some trials I can't create this table (ANJALOG) again.
> When I list my tables with \dt command (in psql), psql says that I
> haven't got any tables at all. Despite the fact that I haven't got any
> tables, I can't create table ANALOG, but I can create another table
> (for
> instance BOCI).
I'm on a Redhat 5.0 system running PG6.3.1 and I cannot recreate your
problem. I tried 40 create table/drop table's in a row and had no
problem (thank goodness for readline). You might want to try a 'vacuum
analyze;' and try the create again.
> My second problem:
> I can't create a table with name group.
> If I write:
> create table group (puszi int);
> then psql says:
> ERROR: parser: parse error at or near 'group'
>
'group' is reserved in PGSQL. The developers might have a workaround
for you, but it might just be easier to change the name of the table.
Add a prefix or a suffix i.e. mygroup, user_group, t_group, group_man,
group_t, ...
> I can't decide, that I've committed some errors or there are some bugs
> in postgreSQL.
> Please help me, and tell me what to do! Please notify me, when you
> will
> issue your next version of postgreSQL (I have 6.3)!
We are up to 6.3.2 with some patches, you might want to upgrade it could
solve your problem with the table creation.
> Thank you for your attention.
>
> Gyorgy Lendvary
>
> e-mail: lendvary-g@prolan.hu
>
> P.S.: I'm sorry my terrible English, but I'm Hungarian!
Not a problem, I'm a Texan and I understand you just fine.
I'll bet you every cent that I have that your English is better than my
Hungarian.
Hope this helps,
-DEJ
> --
> Official WWW Site: http://www.postgresql.org
> Online Docs & FAQ: http://www.postgresql.org/docs
> Searchable Lists: http://www.postgresql.org/mhonarc