[GENERAL] encoding and locale

I'm using postgres8 with encoding 'UNICODE'. I have some problems with unsupported mutlibyte... e.g. with upper() Now I know a I cannot use every lc_ctype with every encoding, but where can I find a list of valid encoding/locale combinations? regards Christian ---(end of

Re: [GENERAL] error moving table to tablespace (8.0 beta win32 )

Rajesh Kumar Mallah wrote: > are you able to create new tables in the default tablespace ? Yes, permissions are ok. looks like a permission issue did you initdb a fresh folder see if the owner of $PGDATA/data/base is the user that running postmaster (usually postgres) . It works fine for me thoug

[GENERAL] error moving table to tablespace (8.0 beta win32 )

Hi! just playing with tablespaces... - moved a existing table to a new tablespace - tried to move it back to default tablespace (ALTER TABLE accounts SET TABLESPACE pg_default;) Got the following error in logfile: ERROR: could not create relation 1663/317186/317191: Permission denied Any suggestio

Re: [GENERAL] PostgreSQL 8.0.0 Officially Goes Beta

Thanks to all Developers, GREAT JOB! Just switched from 7.4 cygwin to 8 beta native win32 on my development system. Everything works so far! Just a small suggestion for now: Can you enable file logging (redirect_stderr = true) in the windows installer by default. I think without you'll see no lo

Re: [GENERAL] autocommit in 7.4

Tom Lane wrote: > > In psql, "\set AUTOCOMMIT off". In libpgtcl, I think you're out of luck > ... AFAIR no one got around to writing any autocommit control logic > for libpgtcl. You are of course welcome to write some and send it in if > you need it ... > Ok, I'll try to make it. Do you know any

[GENERAL] autocommit in 7.4

Hi, thanks for the new great version! Only one small problem, how can I disable autocommit in Postgres 7.4 in libpgtcl and psql? I found something about .psqlrc but how is the syntax and how can I set it for libpgtcl? BTW, SET AUTOCOMMIT TO ON still gives no error, only SET AUTOCOMMIT TO OFF s

[GENERAL] pgadmin3 on Gentoo

Hi, I'm really happy to see that pgadmin3 will run on Linux! I tried to build it on Gentoo but got errors. Was anybody of you able to build it for Gentoo or will there be an emerge file? Regards, Christian ---(end of broadcast)--- TIP 3: if postin

[GENERAL] native win32 version

Hi, sometime ago I heard that there will be a native win32 version of postgresql 7.4. Is this true or will there only be a cygwin version like now? What do you think, how stable and fast is the cygwin version? Best regards, Christian ---(end of broadcast)