Re: [pgadmin-support] Can't edit tables with timestamps

2002-03-27 Thread Jean-Michel POURE
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

[pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-27 Thread Marc Cuypers
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

Re: [pgadmin-support] Can't edit tables with timestamps

2002-03-27 Thread Dave Page
> -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" ( > "

[pgadmin-support]

2002-03-27 Thread Revista Melhor Vida & Trabalho
Title: Revista Melhor   A revista MELHOR - Vida & Trabalho criou um serviço exclusivo para o profissional de recursos humanos. Trata-se do

[pgadmin-support] Can't edit tables with timestamps

2002-03-27 Thread Thomas Sandford
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

Re: [pgadmin-support] Quotes and functions

2002-03-27 Thread Dave Page
> -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

[pgadmin-support] Quotes and functions

2002-03-27 Thread Thomas Sandford
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