Le Mercredi 27 Mars 2002 22:56, Dave Page a écrit :
> Yes, this is a bizarre 'feature' that's been bugging me on and off for
> years now. Currently, pgAdmin builds an update query by generating a WHERE
> clause using all available data. Unfortunately it periodically fails when
> there are timestam
Hi,
I migrated a few tables to postgresql. Everything
migrated fine, but tablenames that contain capitals are converted just as
is. When I create a query, postgresql doesn't seem to use those captitals
and converts them to lowercase. This makes that the table is not found in
the database
> -Original Message-
> From: Thomas Sandford [mailto:[EMAIL PROTECTED]]
> Sent: 27 March 2002 20:32
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Can't edit tables with timestamps
>
>
> Given a database created from the following SQL:
>
> CREATE TABLE "testtable" (
> "
Title: Revista Melhor
A revista MELHOR - Vida & Trabalho criou um
serviço
exclusivo para o profissional de recursos humanos.
Trata-se do
Given a database created from the following SQL:
CREATE TABLE "testtable" (
"id" integer NOT NULL,
"mytext" character varying(32),
"mytime" timestamp with time zone,
Constraint "testtable_pkey" Primary Key ("id")
);
COPY "testtable" FROM stdin;
1 \N 200
> -Original Message-
> From: Thomas Sandford [mailto:[EMAIL PROTECTED]]
> Sent: 27 March 2002 15:21
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Quotes and functions
>
>
> There seems to be a "round trip" problem when editing
> function definitions within the definition pane
There seems to be a "round trip" problem when editing function definitions
within the definition pane of the function window.
If the function text uses single quotes (') then these must be doubled up
(because of the single quotes enclosing the entire function body). However
the doubling up is rem
