x27;t want to do it in
> view. Can somebody help me?
>
> Regards
> skarthi
The problem is with your use of the substr() function. You are passing it a
field of type bit (week_flag) where the function needs a text type. See the
documentation for bit functions-
http://www.postgresql.org
t null
> offdate | character varying(8) | not null
> lat | double precision | not null
> lon | double precision | not null
> elev | double precision | not null default 0
> regist_code | character(1) | not null default ' '
width of the column.
http://docs.ingres.com/sqlref/ColumnFormats#o1232
---
> --
> Adrian Klaver
> [EMAIL PROTECTED]
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
atement='none';
>
> 2009-05-21 08:56:55 IDT ERROR: permission denied to set parameter
> "log_statement"
>
> 2009-05-21 08:56:55 IDT STATEMENT: SET log_statement='none';
>
>
>
> Any help (or guidelines for additional required information) is
> app
ats.html#MONITORING-STATS-VIEWS
My guess is you are being caught by this;
pg_stat_activity
"Furthermore, these columns are only visible if the user examining the view is
a
superuser or the same as the user owning the process being reported on. '
--
Adrian Klaver
adrian.kla...@gmail.com
; Thanks
>
>
>
> Sandy Test
>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
www.postgresql.org/docs/9.0/interactive/sql-explain.html
I believe you are looking for:
explain (ANALYZE, FORMAT YAML) create table...
>
> Does anybody has an idea how to retrieve the output of explain within pgsql
> and store this in a variable?
> An alternative would be any other way
helpful, to put things into context.
>
> Advance thanks for your help.
>
> Chaitanya Kulkarni
>
--
Adrian Klaver
adrian.kla...@gmail.com
is the actual error message?
How did you install the 9.1 versus 9.0 databases?
Related to the above question do the 9.0 and 9.1 have the same storage type
(float or integer) for datetime values?
>
> Thanks and regards,
>
> C P Kulkarni
--
Adrian Klaver
adrian.kla...@
ing?
FYI, there is a Postgres ODBC list:
http://archives.postgresql.org/pgsql-odbc/
>
> C P Kulkarni
>
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
e path
in your script.
*pg_dump: aborting because of server version mismatch*
-e
All database backups complete!
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
://jdbc.postgresql.org/documentation/91/datasource.html#ds-intro
Thanks,
Frank
/Database Administrator/
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
o database "production".
production=#
I do not use the JDBC driver much, but from what I read in the link I
sent you, you can set up a non-pooling DataSource to which you can add
predefined datasources and then switch as needed.
Thanks,
Frank
--
Adrian Klaver
adrian.kla...@gmail.com
code and is very basic at this point. There is also the
dblink module(http://www.postgresql.org/docs/9.2/static/dblink.html).
-Frank
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
14 matches
Mail list logo
