Hello pgAdmin III list,
Recently, I found that Default Values of Function Arguments are garbled if they
contain unquoted commas. This happens in the Function Property Dialog as well
as using the CREATE script menu item.
1. Example, where Default is garbled:CREATE OR REPLACE FUNCTION blah(foo
Version: PgAdmin III 0.8.0 Devel (Jul 30 2003)
Adding NOT NULL columns or columns with default values to existing tables
does not work. Reason: PgAdmin III creates unsupported version of ALTER
TABLE SQL statement.
Regards,
Matej Rizman
---(end of broadcast
> -Original Message-
> From: George T. Gibson [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2002 21:54
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Default Values
>
>
> Having some trouble with default values.
>
> My table already exists. I wa
Having some trouble with default values.
My table already exists. I want to update default values so I go to the
table properties box and enter the new value for date - CURRENT_DATE.
Clicked OK and in the Log view I get:
1/30/2002 4:42:43 PM - SQL (jbsdata): ALTER TABLE "note&q