The following functions failed the regression tests:
float 8
geometry
abstime
select_implicit
select_having
select_views
rules
This is right out of the tutorial:
COPY INTO weather FROM '/home/user/weather.txt'
USING DELIMITERS '|';
I build a table (simulation_stock_tb) which uses float8's and execute
the following:
pma=> copy INTO simulation_stock_tb from '/prgs/db/cps/load_ready3'
USING DELIMITERS ' ';
Using the SAME syntax as the "weather" example I get this error msg.
ERROR: parser: parse error at or near "into"
pma=>
What is the connection (if any) between the float8 in the regression
test and the "parse" error above?
THANKS for your help!
Lynn P. Tilby
Lynn P. Tilby (Lead Programmer/Analyst)
National Data Corporation / Health Information Services
Data Warehousing Solutions
Office: 602 381-9629
Pager: 602 205-1692
Cell: 480 510-4392
Home O: 480 632-8635
Home: 480 632-8633
ltilby@simatics.com (work)
lynn@sol.createv.com (personal)
(text/plain)