Maciek Sakrejda writes:
> I seem to be missing something. Does standard_conforming_strings not
> apply during COPY?
It does not. That setting is about literal strings in SQL commands.
The COPY escaping rules do not depend on it.
regards, tom lane
--
Sent via pgsql-gene
On Thu, Sep 23, 2010 at 2:17 PM, Tom Lane wrote:
> Scott Marlowe writes:
>> I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
>> panic on failing to add a right sibling in an index. Log output:
>
>> PANIC: failed to add item to the right sibling in index "logged_in_uid"
>> S
Ok, so, stupid question: how does all this interact with COPY escaping
rules[1]?:
Backslash characters (\) can be used in the COPY data to quote
data characters that might otherwise be taken as row or column
delimiters. In particular, the following characters must be preceded
by a backslash
Yes indeed, pg_query returns "t" or "f" as strings when selecting
boolean columns.
I was able to switch over to PDO with only an afternoon's work and it works
perfectly for boolean columns, returning values that are properly interpreted
as true and false by php, and by json_encode. I'm all set now
Hi Tom,
Thanks very much for your assistance, your suggestion worked a treat. I have
updated the gevel people.
Regards
Andrew
On 2010-09-23, at 2:05 PM, Tom Lane wrote:
> Andrew Hunter writes:
>> Here is the content of the gevel Makefile
>
>> subdir = contrib/gevel
>> top_builddir = ../..
On Sat, 2010-09-11 at 14:21 -0700, Gabe Nell wrote:
> Is there a way to get this without using hot standby?
Why would you want to avoid using hot standby?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-general mai
On September 23, 2010 01:49:50 pm kongs...@stud.ntnu.no wrote:
> Hi,
> I have a copy of "/usr/local/pgsql/data" from old server. Is it
> possible to do a dump of the sql databases in this directory, so that
> I can easily migrate them to my current system?
>
You should be able to launch a postmas
kongs...@stud.ntnu.no wrote:
> Hi,
> I have a copy of "/usr/local/pgsql/data" from old server. Is it
> possible to do a dump of the sql databases in this directory, so that
> I can easily migrate them to my current system?
Yes, run pg_dumpall, save it, and load it into the new system. You
rea
Hi,
I have a copy of "/usr/local/pgsql/data" from old server. Is it
possible to do a dump of the sql databases in this directory, so that
I can easily migrate them to my current system?
-Håvard Wahl Kongsgård
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
Scott Marlowe writes:
> I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
> panic on failing to add a right sibling in an index. Log output:
> PANIC: failed to add item to the right sibling in index "logged_in_uid"
> STATEMENT: INSERT INTO logged_in ...
If you can apply th
Andrew Hunter writes:
> Here is the content of the gevel Makefile
> subdir = contrib/gevel
> top_builddir = ../..
> include $(top_builddir)/src/Makefile.global
> MODULES = gevel
> DATA_built = gevel.sql
> DOCS = README.gevel
> REGRESS = gevel
> include $(top_srcdir)/contrib/contrib-global.mk
O
On Thu, 2010-09-23 at 12:45 +0200, A B wrote:
> Hello.
>
> If I have a table like this
>
> create table fleet ( ship_id integer, location point);
I recommend taking a look into PostGIS: http://postgis.org
Regards,
Jeff Davis
--
Sent via pgsql-general mailing list (pgsql-general@po
On Thu, Sep 23, 2010 at 2:28 PM, Scott Marlowe wrote:
> I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
> panic on failing to add a right sibling in an index. Log output:
>
> PANIC: failed to add item to the right sibling in index "logged_in_uid"
> STATEMENT: INSERT INTO l
On 2010-09-23, at 10:27 AM, Tom Lane wrote:
> Andrew Hunter writes:
>> On 2010-09-22, at 9:56 PM, Tom Lane wrote:
>>> Andrew Hunter writes:
I have been trying to install the Gevel module but am getting an error
when running make on the gevel files download.
The error is:
/co
I've got a problem with pg 8.4.4 crashing with a sig 6 abort due to a
panic on failing to add a right sibling in an index. Log output:
PANIC: failed to add item to the right sibling in index "logged_in_uid"
STATEMENT: INSERT INTO logged_in ...
Now, the column that's failing here is a serial th
>> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
>> there is no mention about that in the release notes.
>
> the assumption is 'no' on rc->rc or rc-releases generally unless
> specifically indicated in the release notes that you must do so. it
> never hurts to keep
>> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
>> there is no mention about that in the release notes.
>
> No, there were no system catalog changes between 9.0rc1 and 9.0.
thank you bruce.
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@post
>> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
>> there is no mention about that in the release notes.
>
> No, there were no system catalog changes between 9.0rc1 and 9.0.
thank you bruce.
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@pos
On Tue, Sep 21, 2010 at 12:23 PM, Lincoln Yeoh wrote:
> To me what would also be useful would be synchronous notifications.
>
> This would allow many programs to wait for events to happen rather than all
> of them polling the database (and wasting CPU cycles, battery life, etc).
> You could still
Andrew Hunter writes:
> On 2010-09-22, at 9:56 PM, Tom Lane wrote:
>> Andrew Hunter writes:
>>> I have been trying to install the Gevel module but am getting an error when
>>> running make on the gevel files download.
>>> The error is:
>>> /contrib/contrib-global.mk: No such file or directory.
>
Jan Otto wrote:
> hi,
>
> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
> there is no mention about that in the release notes.
No, there were no system catalog changes between 9.0rc1 and 9.0.
--
Bruce Momjian http://momjian.us
EnterpriseDB
On Thu, Sep 23, 2010 at 11:14 AM, Jan Otto wrote:
> hi,
>
> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
> there is no mention about that in the release notes.
the assumption is 'no' on rc->rc or rc-releases generally unless
specifically indicated in the release n
Thom Brown wrote:
> On 23 September 2010 10:51, Boris wrote:
> > Hello,
> >
> > I have Debian Linux (unstable) server, and I am trying to upgrade 8.4
> > version
> > database to 9.0, all developer packages for both versions were installed, as
> > well as client ( postgresql-server-dev-8.4
> > pos
On Thu, 16 Sep 2010 06:22:15 -0700, Andreas wrote:
It's not only typos to catch. There is variation in the way to write
things that not necessarily are wrong.
e.g.
Miller's Bakery
Bakery Miller
Bakery Miller, Ltd.
Bakery Miller and sons
Bakery Smith (formerly Miller)
and the usual
Strawberry
On 23 September 2010 10:51, Boris wrote:
> Hello,
>
> I have Debian Linux (unstable) server, and I am trying to upgrade 8.4 version
> database to 9.0, all developer packages for both versions were installed, as
> well as client ( postgresql-server-dev-8.4
> postgresql-client-8.4 postgresql-server-
There is already a bug filed for this:
http://bugs.debian.org/597600
According to mpitt (the maintainer), the supported upgrade path is to use
pg_upgradecluster
On Thu, Sep 23, 2010 at 3:21 PM, Boris wrote:
> Hello,
>
> I have Debian Linux (unstable) server, and I am trying to upgrade 8.4
> v
Chris Barnes writes:
> I am attempting to drop an foreign key on a table and it sits for hours and
> doesn't drop or put anything into the log.
Dropping a foreign key is fast in itself, but it requires exclusive lock
on both the referencing and referenced tables. Look to see what is
blocking th
On Thu, Sep 23, 2010 at 11:01 AM, Chris Barnes
wrote:
> I am attempting to drop an foreign key on a table and it sits for hours and
> doesn't drop or put anything into the log.
>
Does the pg_stat_activity view show that it is waiting for a lock? It
will need to lock both the origin and destinati
Hello,
I have Debian Linux (unstable) server, and I am trying to upgrade 8.4 version
database to 9.0, all developer packages for both versions were installed, as
well as client ( postgresql-server-dev-8.4
postgresql-client-8.4 postgresql-server-dev-9.0 postgresql-client-9.0).
Here is the comma
hi,
is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
there is no mention about that in the release notes.
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsq
Sorry,
I am running the following.
[postg...@pgprd01 pgcheck]$ psql --version
psql (PostgreSQL) 8.4.2
contains support for command-line editing
[postg...@pgprd01 pgcheck]$ uname -a
Linux system.name.com 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64
x86_64 x86_64 GNU/Linux
From:
I am having an odd problem that I have seen before. It usually clears itself
after I restart postgres.
I am attempting to drop an foreign key on a table and it sits for hours and
doesn't drop or put anything into the log.
Killing the alter puts an error in, but it doesn't time out and it cause
On Thu, Sep 23, 2010 at 16:20, Martin A. Brooks wrote:
> Hi
>
> I did not see this feature on the TODO page on the wiki. I apologise if I
> have overlooked something similar.
>
> I would like postgres to have a cron-like feature for scheduling things to
> happen at particular times.
>
> An exampl
Hi
I did not see this feature on the TODO page on the wiki. I apologise if I
have overlooked something similar.
I would like postgres to have a cron-like feature for scheduling things to
happen at particular times.
An example of this might be routinely purging data from tables, or
vacuuming spe
Actually, I found the feature matrix on the wiki, which serves my purpose
pretty well--reminder of major new features that I might not have adopted...
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql
2010/9/23 Raymond O'Donnell :
> On 23/09/2010 13:55, Grzegorz Jaśkiewicz wrote:
>>
>> or even better, learn English properly and contribute your translation.
>> I'm not whining that there's no Polish translation.
>>
>> French people are somewhat specific in that matter, don't get me
>> started on a
On 23/09/2010 13:55, Grzegorz Jaśkiewicz wrote:
or even better, learn English properly and contribute your translation.
I'm not whining that there's no Polish translation.
French people are somewhat specific in that matter, don't get me
started on aviation (cos it drives me insane).
:-) I
Le 23/09/2010 14:42, Vick Khera a écrit :
> On Thu, Sep 23, 2010 at 3:15 AM, Guillaume Lelarge
> wrote:
>> Nope, that's the first time we have this. Marc Cousin already did this
>> in french for the 8.4 release. Unfortunately, it's only available in
>> french. For those reading french, it's availa
or even better, learn English properly and contribute your translation.
I'm not whining that there's no Polish translation.
French people are somewhat specific in that matter, don't get me
started on aviation (cos it drives me insane).
--
Sent via pgsql-general mailing list (pgsql-general@p
On Thu, Sep 23, 2010 at 3:15 AM, Guillaume Lelarge
wrote:
> Nope, that's the first time we have this. Marc Cousin already did this
> in french for the 8.4 release. Unfortunately, it's only available in
> french. For those reading french, it's available here:
>
>
> http://blog.postgresql.fr/index.p
Hello.
If I have a table like this
create table fleet ( ship_id integer, location point);
and fill it with a lot of ships and their locations and then want to
create an index on this to speed up operations on finding ships within
a certain region (let's say its a rectangular region), how do I
Thanks Tom,
I found the right way to kill the process.
Regards,
Atul Goel
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 22 September 2010 17:43
To: Atul Goel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Kill -9 for a session process caused all the sessio
On 23/09/2010 02:00, Adrian Klaver wrote:
On Wednesday 22 September 2010 5:40:55 pm David Wilson wrote:
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaverwrote:
From here;
http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html
I believe the question relates to changing the string
Le 23/09/2010 01:28, Scott Ribe a écrit :
> The what's new in 9.0 document on the wiki is great. Is there anything
> similar for 8.4 & 8.3 & so on?
>
Nope, that's the first time we have this. Marc Cousin already did this
in french for the 8.4 release. Unfortunately, it's only available in
french
44 matches
Mail list logo
