[GENERAL] Error defining composite types and returning ROWTYPEs

2005-06-18 Thread Geoffrey Giesemann
CREATE TABLE test_table ( some_column integer, another_column text ); CREATE TYPE test_type as ( some_type test_table.some_column%TYPE ); Gives me: ERROR: syntax error at or near "%" at character 62 LINE 2: some_type test_table.some_column%TYPE I also can't define rowtypes as return t

Re: [GENERAL] libpq.so.3 problem, PostgreSQL >= 8.0.2 and RPM

2005-06-18 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 17 Jun 2005, Karl O. Pinc wrote: http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-2PGDG.i686.rpm is the compatibility RPM that fixes the problem which arose with PostgreSQL 8.0.2 . With 8.0.2, the major number of libpq

Re: [GENERAL] Help: chinese character set support (EUC_TW to/from

2005-06-18 Thread eric
You're right about it. After a 8.0.3 re-installation, the issue seems to have gone. See screen output: euc_tw=# \d contacts Table "public.contacts" Column | Type | Modifiers +---+--- id | integer | name | character

[GENERAL] Replication

2005-06-18 Thread mojoscoobydoo
I have been searching for the ability for replication between postgresql database servers. Many of the solutions That I have seen either work only un*x or requires an expensive commercial license. I am looking something rather short term and maybe for a long term solution.   I came across th

Re: [GENERAL] Error defining composite types and returning ROWTYPEs

2005-06-18 Thread Tom Lane
Geoffrey Giesemann <[EMAIL PROTECTED]> writes: > CREATE TYPE test_type as ( >some_type test_table.some_column%TYPE > ); > Gives me: > ERROR: syntax error at or near "%" at character 62 > LINE 2: some_type test_table.some_column%TYPE > I also can't define rowtypes as return types on functio

Re: [GENERAL] Replication

2005-06-18 Thread Bruno Wolff III
On Fri, Jun 17, 2005 at 22:54:59 -0700, Jeffery Reedy <[EMAIL PROTECTED]> wrote: > I have been searching for the ability for replication between postgresql > database servers. Many of the solutions That I have seen either work only > un*x or requires an expensive commercial license. I am lookin

Re: [GENERAL] Viewing non-system objects in psql

2005-06-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > P.S. The use of capital "s" is possible a source of some of the resistance. It > seems like a lowercase "s" or something else that doesn't need multiple > keystrokes would be a lot easier to type. Is there some limitation on the > \command parser t

Re: [GENERAL] Replication

2005-06-18 Thread brew
Jeffery. > I have been searching for the ability for replication between postgresql > database servers. Many of the solutions That I have seen either work > only un*x or requires an expensive commercial license. I am looking > something rather short term and maybe for a long term solution. I

[GENERAL] PgAdmin 1.2.2 on MacOS X with PG 8.0.3

2005-06-18 Thread Jerry LeVan
Hi, I just tried PgAdmin 1.2.2 on my Mac OS 10.4.1 and PG 8.0.3. It appears that typing into into the bottom row of the info grid brings down the application. This is the first time I have tried this application Am I unique with this problem? Jerry ---(end of broadcas

[GENERAL] ALTER FUNCTION semantics

2005-06-18 Thread Karl O. Pinc
Hi, The semantics of ALTER FUNCTION are not clear to me. I'm too lazy to test the semantics. Will somebody please explain how it works? I see two issues. What it does and when it does it. The documentation says ALTER FUNCTION "changes the definition of a function", which could be read to imp

Re: [GENERAL] PgAdmin 1.2.2 on MacOS X with PG 8.0.3

2005-06-18 Thread John DeSoi
On Jun 18, 2005, at 3:18 PM, Jerry LeVan wrote: I just tried PgAdmin 1.2.2 on my Mac OS 10.4.1 and PG 8.0.3. It appears that typing into into the bottom row of the info grid brings down the application. This is the first time I have tried this application Am I unique with this problem? I'

[GENERAL] Anyone use pgcluster in production?

2005-06-18 Thread Gregory Youngblood
I was wondering how many people have PGCluster used in production environments. How stable is it? Are there any problems? Are there any versions that should be avoided? Which is the better choice for production use right now, 1.1 or 1.3? Are there any gotchas to be avoided? I am evaluatin