Actually I never managed this command to be executed by the
database:
testme=> create table mama (a char(15))
testme-> \g
CREATE
testme=> truncate mama
testme-> \g
ERROR: parser: parse error at or near "truncate"
testme=> select * from mama
testme-> \g
a
-
(0 rows)
testme=> truncate table mama
"Ben Fox" <[EMAIL PROTECTED]> writes:
> I am having a hard time using pgaccess on LinuxPPC. I installed
> the 7.0.2 RPMs and have sucsessfully created new users and
> databases. However, when trying to open a database, create or view
> tables in pgaccess, I get the following error window:
>
I am having a hard time using pgaccess on LinuxPPC. I installed the 7.0.2
RPMs and have sucsessfully created new users and databases. However, when
trying to open a database, create or view tables in pgaccess, I get the
following error window:
ERROR: getattproperties: no attribute tupl
On Sun, 22 Oct 2000, Bruce Momjian wrote:
> > Palle Girgensohn <[EMAIL PROTECTED]> writes:
> > > GNU gdb 4.18
> > > Program terminated with signal 11, Segmentation fault.
> > > (gdb) bt
> > > #0 0x8136eb2 in GetTemplateEncoding ()
> > > #1 0x8136d66 in pg_mb2wchar_with_len ()
> > > #2 0x8
Sorry, I mistyped that query in my bug report, damaging its credibility,
but the bug is actually there when you use "MI" for minutes:
template1=# select to_char(timestamp '2000-01-01 13:45:00', 'HH12:MI pm');
to_char
--
01:45 am
-
Sam Hokin . mailto:[EMAIL PROTECTED]
There seems to be a bug in 7.0.2 in the to_char(timestamp,text) function
when one uses the "am" or "pm" template for times between 12:00 and 14:00:
template1=# select to_char(timestamp '2000-01-01 13:00:00', 'HH12:MM pm');
to_char
--
01:01 am
Any times between 12:00 and 14:00 show "a
