The reverse engineered code for column definitions
if incorrect for DEFAULT values.
I create table such as:
REATE TABLE public.tbl_bkgndata( id
int4 NOT NULL DEFAULT nextval('tbl_bkgndata_id_seq'::text),) WITHOUT
OIDS;
Reverse engineered column definition
is:
ALTER TABLE public.tbl_bk
Donald Fraser wrote:
The reverse engineered code for column definitions if incorrect for
DEFAULT values.
I create table such as:
REATE TABLE public.tbl_bkgndata
(
id int4 NOT NULL DEFAULT nextval('tbl_bkgndata_id_seq'::text),
) WITHOUT OIDS;
Reverse engineered column definition is:
ALTER
Hi,
I am running version
1.0.0, Win2k, english version, and postgresql 7.3.4 under cygwin.
In the
File->Options->Query->max. characters per column I have changed the
default to 5000 characters. When I run a query in a pgadminIII the columns
that I have defined as text stop displaying
Godshall Michael wrote:
Hi,
I am running version 1.0.0, Win2k, english version, and postgresql
7.3.4 under cygwin.
In the File->Options->Query->max. characters per column I have changed
the default to 5000 characters. When I run a query in a pgadminIII
the columns that I have defined as t
Title: RE: [pgadmin-support] Bug in pgadmin III displaying/exporting data from query window(tr uncating)
Ok,
In pgadminII I could choose to output the results directly to a text file without having them first displayed on the screen. That is what I was really trying to do(I normally don't t
Default value for char/varchar columns is not quoted automaticaly when
creating a table or adding new column to existing table.
-- PGAdmin --
version: PGAdmin III version 1.0.0
OS: Windows XP Professional SP1
-- postgres --
Postgres: 7.3.4 on i686-pc-linux-gnu
OS: RedHat Linux 9
- St
Dear Donald.
Thank you very much.
It will be reflected soon.
Dave Apply it?
- Original Message -
From: Donald Fraser
> The reverse engineered code for column definitions if incorrect for DEFAULT values.
> I create table such as:
(snip)
> ALTER TABLE public.tbl_bkgndata ALTER COLUMN i
