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
-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
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
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
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
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
-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
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
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
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
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'
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
12 matches
Mail list logo