On 02/20/2014 10:29 AM, Daniel Cardno wrote:
How do I go about deleting the user?
I don't know, I don't use Windows.
--
Vik
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/20/2014 11:24 AM, Daniel Cardno wrote:
is this not a help line?
On 20 February 2014 09:31, Vik Fearing vik.fear...@dalibo.com
mailto:vik.fear...@dalibo.com wrote:
On 02/20/2014 10:29 AM, Daniel Cardno wrote:
How do I go about deleting the user?
I don't know, I don't
Dev Kumkar wrote:
Succeeds but as replied earlier it creates database with LC_COLLATE =
'English_United States.1252' which corresponds to Latin1.
Despite windows-1252 being a monobyte encoding sharing most
of LATIN1 codes and character set, it does not mean that
English_United
Thanks Alban, Sameer.
My use of partitions should have been more of a side note really.
I was particularly interested in wether the query planner could optimise a
date_folded equality expression into a range query - for the case where it
could benefit from an existing index on the non-folded
On Fri, Feb 14, 2014 at 7:26 PM, Reece Hart re...@harts.net wrote:
I should be able to chase pg_depends entries to create this ordering, right?
Not always, there may be circular dependencies between them.
Regards,
Marti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Thu, Feb 20, 2014 at 4:34 PM, Daniel Verite dan...@manitou-mail.orgwrote:
Despite windows-1252 being a monobyte encoding sharing most
of LATIN1 codes and character set, it does not mean that
English_United States.1252 is limited to this character set.
You may use UTF-8 databases with that
On Thu, Feb 20, 2014 at 3:53 AM, Adrian Klaver adrian.kla...@aklaver.comwrote:
Each driver will have its own behavior. For an explanation of the JDBC
behavior see here:
http://www.postgresql.org/message-id/4b2f2ced.10...@opencloud.com
Per Andrews posts, the least surprise behavior is to
On Thu, Feb 20, 2014 at 3:55 AM, Terence Ferraro
terencejferr...@gmail.comwrote:
Or, if you don't mind a little patching: http://pastebin.com/5AyaX2RF
That restores the pre-9.1 functionality of determining the timezone on
postmaster start. As has been pointed out, their new stuff is more
inline:
On Thu, Feb 20, 2014 at 3:57 AM, Tom Lane t...@sss.pgh.pa.us wrote:
The functionality of determining an IANA timezone name equivalent to the
platform's behavior is currently embedded in initdb and isn't separately
accessible. So you've got several options:
Hmm, actually was looking
On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver adrian.kla...@aklaver.comwrote:
It depends on how you are declaring the timestamp field. If you do not use
with time zone then the input value is open to interpretation and is not
'anchored' to a point in time.
Example
My time zone is
On Thu, Feb 20, 2014 at 3:04 AM, Gavin Flower gavinflo...@archidevsys.co.nz
wrote:
Upgrade servers to Linux? :-P
Actually that's not the solution but running away from it.
There is a heavy footprint of customers and huge market on windows too and
so not that easy to migrate and convince in
There is nothing in the pg_log.
Log files contains : 2014-02-20 10:58:55 IST LOG: received fast shutdown
request
2014-02-20 10:58:55 IST LOG: aborting any
active transactions
2014-02-20 10:58:55 IST LOG: autovacuum
How do I go about deleting the user?
On 20 February 2014 01:09, Vik Fearing vik.fear...@dalibo.com wrote:
On 02/19/2014 08:01 PM, Daniel Cardno wrote:
Hi,
I have recently changed from HEM2 to PT4, during the changeover i
uninstalled Postgres and HM2, i then went on to install PT4 and
is this not a help line?
On 20 February 2014 09:31, Vik Fearing vik.fear...@dalibo.com wrote:
On 02/20/2014 10:29 AM, Daniel Cardno wrote:
How do I go about deleting the user?
I don't know, I don't use Windows.
--
Vik
saravanan Chow, 20.02.2014 06:41:
There is nothing in the pg_log.
Log files contains : 2014-02-20 10:58:55 IST LOG: received fast shutdown
request
2014-02-20 10:58:55 IST LOG: aborting any
active transactions
2014-02-20
Hey,
could you please explain what you mean by Congrats on the availability of
postgis in de postgresql apt reporsitory?
It would be very great,
but I can't find postgis package in
http://apt.postgresql.org/pub/repos/apt/dists/
Thanks,
Rémi-C
2014-02-20 16:45 GMT+01:00 Willy-Bas Loos
On 02/20/2014 04:29 AM, Dev Kumkar wrote:
On Thu, Feb 20, 2014 at 3:53 AM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
Each driver will have its own behavior. For an explanation of the
JDBC behavior see here:
Hi,
Congrats on the availability of postgis in de postgresql apt reporsitory,
this is great work!
I have one question about versions and upgrade sof postgis.
Since the package names are equal to those in debian and ubuntu
(postgresql-x.x-postgis), how will new versions of postgis and upgrades be
On 02/20/2014 04:59 AM, Dev Kumkar wrote:
On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
It depends on how you are declaring the timestamp field. If you do
not use with time zone then the input value is open to
We recently upgraded to version 8.4.18 within our product but this upgrade has
caused SSL connections to fail when OpenSSL is in FIPS mode.
We receive the following error:
2014-02-20 01:44:23 PST [9339]: [1-1] db=[unknown],user=[unknown] LOG: could
not accept SSL connection: decryption failed
On Thu, Feb 20, 2014 at 4:57 PM, Rémi Cura remi.c...@gmail.com wrote:
could you please explain what you mean by Congrats on the availability of
postgis in de postgresql apt reporsitory?
It would be very great,
but I can't find postgis package in
http://apt.postgresql.org/pub/repos/apt/dists/
On Thu, Feb 20, 2014 at 4:45 PM, Willy-Bas Loos willy...@gmail.com wrote:
Since the package names are equal to those in debian and ubuntu
(postgresql-x.x-postgis), how will new versions of postgis and upgrades be
handled?
please excuse me, i was being silly.
the package names are actually:
So cool ^^
Going to simplify a lot install and upgrades !
Cheers,
Rémi-C
2014-02-20 17:47 GMT+01:00 Willy-Bas Loos willy...@gmail.com:
On Thu, Feb 20, 2014 at 4:45 PM, Willy-Bas Loos willy...@gmail.comwrote:
Since the package names are equal to those in debian and ubuntu
On Thu, Feb 20, 2014 at 9:30 PM, Adrian Klaver adrian.kla...@aklaver.comwrote:
So what is your requirement?
Do you have a specific application/use for the databases you are
installing?
There are two interfaces for the database. One is from the ODBC driver and
other is from the JDBC driver.
On 21/02/14 02:04, Dev Kumkar wrote:
On Thu, Feb 20, 2014 at 3:04 AM, Gavin Flower
gavinflo...@archidevsys.co.nz mailto:gavinflo...@archidevsys.co.nz
wrote:
Upgrade servers to Linux? :-P
Actually that's not the solution but running away from it.
There is a heavy footprint of customers
On Fri, Feb 21, 2014 at 12:14:42AM +0530, Dev Kumkar wrote:
These are the two clients which I have currently who communicate with
database.
Do you control the client code? If so, why not set the TimeZone
locally when you connect? That's the right way to handle this,
really.
A
--
Andrew
On Fri, Feb 21, 2014 at 12:14 AM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
On 21/02/14 02:04, Dev Kumkar wrote:
On Thu, Feb 20, 2014 at 3:04 AM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
Upgrade servers to Linux? :-P
Actually that's not the solution but running
On 02/20/2014 11:40 AM, Dev Kumkar wrote:
Hmm. Don't want to digress here and loose the topic context.
Here would really appreciate if there are any suggestions for UTF-8
collation on Windows?
Well I dug out a Windows machine and tried to get what you wanted, to no
avail. As far as I know
On Fri, Feb 21, 2014 at 1:26 AM, Adrian Klaver adrian.kla...@aklaver.comwrote:
Well I dug out a Windows machine and tried to get what you wanted, to no
avail. As far as I know there is no UTF8 collation, it is an encoding. What
you want if I am following, is the en_US locale (or equivalent for
On 02/20/2014 11:40 AM, Dev Kumkar wrote:
Hmm. Don't want to digress here and loose the topic context.
Here would really appreciate if there are any suggestions for UTF-8
collation on Windows?
Just had idea, not sure how feasible it is in your situation though. Run
Postgres in a Linux VM
On 02/20/2014 12:27 PM, Dev Kumkar wrote:
On Fri, Feb 21, 2014 at 1:26 AM, Adrian Klaver
adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote:
Well I dug out a Windows machine and tried to get what you wanted,
to no avail. As far as I know there is no UTF8 collation, it is
We are assessing how to migrate our current (and very old) Oracle Database
10.1.2.4 to Postgres. Our question/concern is the data to be migrated is used
extensively by custom applications written with Oracle Forms 6i. Will Postgres
work with Forms 6i? If not, what options would you
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
migrated is used extensively by custom applications written with
Oracle Forms 6i. Will Postgres work with Forms
On Fri, Feb 21, 2014 at 12:43 AM, Andrew Sullivan a...@crankycanuck.cawrote:
Do you control the client code? If so, why not set the TimeZone
locally when you connect? That's the right way to handle this,
really.
Agree. So find the OS timezone at programming level and set accordingly.
This
On 02/20/2014 12:53 PM, John R Pierce wrote:
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
migrated is used extensively by custom applications written with
We recently upgraded to version 8.4.18 within our product but this upgrade
has caused SSL connections to fail when OpenSSL is in FIPS mode.
We receive the following error:
2014-02-20 01:44:23 PST [9339]: [1-1] db=[unknown],user=[unknown] LOG:
could not accept SSL connection: decryption failed or
On Thu, 2014-02-20 at 14:03 -0800, Joshua D. Drake wrote:
On 02/20/2014 12:53 PM, John R Pierce wrote:
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
when I used vacuumdb -d db1 -z -v /BACKUP/script/db1.$LOG_DATE.log 21
it occued this error [automatic vacuum of table db1.public.a: could not
(re)acquire exclusive lock for truncat]
and table db1.public.a and all behind db1.public.a tables did not do
analyzing.
I want to know:
1.why table
I want to make a float(n) type that emulates the mssql float type. The storage
requirements are documented as 4 bytes for 1 = n =24, and 8 bytes for 25 = n
= 53. If I understand correctly, my options for emulating this in postgres are:
1. declare as variable length. Storage is then 8 bytes (4
James Harper james.har...@bendigoit.com.au writes:
I want to make a float(n) type that emulates the mssql float type. The
storage requirements are documented as 4 bytes for 1 = n =24, and 8
bytes for 25 = n = 53.
Haven't we got that already?
regression=# create table t1 (f1 float(5), f2
James Harper james.har...@bendigoit.com.au writes:
I want to make a float(n) type that emulates the mssql float type. The
storage requirements are documented as 4 bytes for 1 = n =24, and 8
bytes for 25 = n = 53.
Haven't we got that already?
regression=# create table t1 (f1
41 matches
Mail list logo