[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 broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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 though initdb was run by windows installer Regds mallah test=# \d t_b Table "public.t_b" Column | Type | Modifiers +-+--- a | integer | Tablespace: "space" test=# ALTER TABLE t_b SET TABLESPACE pg_default; ALTER TABLE test=# SELECT version(); version -- PostgreSQL 8.0.0beta1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) (1 row) test=# Maybe its only win32 version? Here what i tried: CREATE TABLE test (name varchar(100)); CREATE TABLE CREATE TABLESPACE test LOCATION 'C:\\tmp\\ts_test'; CREATE TABLESPACE \db List of tablespaces Name| Owner |Location +--+ pg_default | postgres | pg_global | postgres | test | postgres | C:/tmp/ts_test (3 rows) ALTER TABLE test SET TABLESPACE test; ALTER TABLE \d+ test Table "public.test" Column | Type | Modifiers | Description ++---+- name | character varying(100) | | Contains OIDs: yes Tablespace: "test" ALTER TABLE test SET TABLESPACE pg_default; ERROR: could not create relation 1663/317186/1317654: Permission denied select version(); version -- PostgreSQL 8.0.0beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1) (1 row) Thanks and regards Christian ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[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 suggestions? Best regards, Christian ---(end of broadcast)--- TIP 8: explain analyze is your friend
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 logs when run as service. Best regards, Christian ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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 reason why libpgtcl is not tclstub enabled? Maybe I 'll try to build it with stubs... Regards, Christian ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[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 says ERROR: SET AUTOCOMMIT TO OFF is no longer supported. Thanks and best regards, Christian ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[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 posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly