[EMAIL PROTECTED] writes:
> Is the syntax "schema_name.index_name" for create unique index wrong,
> unsupported or what?
Yes.
Put the schema name on the table, instead.
regards, tom lane
---(end of broadcast)---
TIP 1: sub
On Sep 12, 2004, at 2:48 PM, Michael Glaesemann wrote:
On Sep 12, 2004, at 5:42 AM, [EMAIL PROTECTED] wrote:
Is the syntax "schema_name.index_name" for create unique index wrong,
unsupported or what? I know is doesn't work as postgres kicks me back
a syntax error each time (version 7.3.2 & 7.4.5)
On Sep 12, 2004, at 5:42 AM, [EMAIL PROTECTED] wrote:
Is the syntax "schema_name.index_name" for create unique index wrong,
unsupported or what? I know is doesn't work as postgres kicks me back
a syntax error each time (version 7.3.2 & 7.4.5). -sigh-
Could you give a full example (including the e
Is the syntax "schema_name.index_name" for create unique index wrong,
unsupported or what? I know is doesn't work as postgres kicks me back a
syntax error each time (version 7.3.2 & 7.4.5). -sigh-
---(end of broadcast)---
TIP 2: you can get off all
the inquirer <[EMAIL PROTECTED]> writes:
> ERROR: syntax error at or near "$1" at character 14
> CONTEXT: PL/pgSQL function "create_author" line 7 at
> SQL statement
PL/pgSQL errors are sometimes obscure. I'll try to comment on what
looks wrong to me...
> CREATE OR REPLACE FUNCTION create_autho
the inquirer wrote:
I am trying to create a function that creates a user
and adds a row to a table. It produces no warnings or
errors when I create the function but when I attempt
to execute it I get a syntax error. I do not
understand why this is happening. Any help would be
greatly appreciate
On Sep 3, 2004, at 11:36 PM, James M Doherty wrote:
I have a project that is taking input from another system. I have
certain columns defined as 'Date' Columns. On input I will get
'00' in this field which causes the insert to fail.
00 is not a valid date, as you are aware :) This is ofte
