Tom Lane-2 wrote:
>
> miller_2555 writes:
>> So this does not work well apparently.
>
> The only obvious thing wrong with your example is failing to preserve
> ownership/permissions of the moved files. I think the upper directories
> are probably not readable by Postgres so it's choking.
>
Thank you very much. It seems it is better to save it on file system.
2009/9/9 Yaroslav Tykhiy
> On 09/09/2009, at 10:43 AM, John R Pierce wrote:
>
> 纪晓曦 wrote:
>>
>>> Can I save images in the postgres? How to define? Does the format
>>> matters? Can I save JPG/PNG?How?
>>>
>>
>> you can save i
miller_2555 writes:
> So this does not work well apparently.
The only obvious thing wrong with your example is failing to preserve
ownership/permissions of the moved files. I think the upper directories
are probably not readable by Postgres so it's choking.
BTW, Postgres *already* refers to tab
Yaroslav Tykhiy wrote:
By the way, folks, do you think there may be performance gain or loss
from rewriting this with an explicit JOIN? E.g.:
SELECT DISTINCT foo.foo_id, foo.name FROM foo JOIN bar ON foo.bar_id =
bar.bar_id WHERE bar.name='martini';
I would expect that to be more efficient
On 09/09/2009, at 10:43 AM, John R Pierce wrote:
纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format
matters? Can I save JPG/PNG?How?
you can save images as BYTEA data, and the format is totally up to
your application, as postgres just treats it as a block of bytes
On 09/09/2009, at 9:02 AM, David W Noon wrote:
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
Is it possible to join tables in the where clause of a statement?
[snip]
Given a statement as follows:
SELECT foo.foo_id, foo.name
FROM
miller_2555 wrote:
>
> Hi -
> I have a database and used symbolic links in the tablespace
> definitions. I just wanted to validate that I can move the database
> objects to a different physical volume by the following:
> 1) issuing `pg_ctl stop`
> 2) hard copying the tablespace fi
纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format
matters? Can I save JPG/PNG?How?
you can save images as BYTEA data, and the format is totally up to your
application, as postgres just treats it as a block of bytes.however,
I generally find it easier to store m
On Sep 8, 2009, at 4:02 PM, David W Noon wrote:
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
Is it possible to join tables in the where clause of a statement?
[snip]
Given a statement as follows:
SELECT foo.foo_id, foo.name
FRO
Can I save images in the postgres? How to define? Does the format matters?
Can I save JPG/PNG?How?
PG DBAs:
We've been discussing getting rid of VACUUM FULL as a utility on the
hackers list. Please read about it, and comment if you can see any
issues with your use of PostgreSQL if 8.5 doesn't have VACUUM FULL.
http://it.toolbox.com/blogs/database-soup/getting-rid-of-vacuum-full-feedback-neede
Andrus wrote:
In some servers 8.4 pg_dump exits without any message if running from
Task Scheduler.
To explore this, I created scheduler task containing line
cmd
After that I can type manually commands:
C:\MyApp\pg_dump>dir /w
..
[.] [..] comerr32.dll
gssapi32.dll
Richard Broersma wrote:
>
> For those experienced using natural primary key designs, what update
> strategies do you use when updating related tuples within a
> transaction when the primary key is also subject to changes?
>
> For example consider a table is vertically partitioned into two or
On Tue, 8 Sep 2009 14:25:20 -0700, Scott Frankel wrote about [GENERAL]
where clauses and multiple tables:
>Is it possible to join tables in the where clause of a statement?
[snip]
>Given a statement as follows:
>
> SELECT foo.foo_id, foo.name
> FROM foo, bar
> WHERE foo.bar_id = bar.bar_id
>
Scott Frankel-3 wrote:
>
> Is it possible to join tables in the where clause of a statement
>
> I've explored the "where exists" clause, but that's not supported by
> the application toolkit I'm using. AFAIK, I've only got access to
> where ...
>
> Thanks in advance!
> Scott
>
Not entire
Hello,
Is it possible to join tables in the where clause of a statement?
I ask because I have a situation where I only have access to the where
clause of a select statement on a single table, yet I want to perform
a join on multiple tables. eg:
Given a statement as follows:
SELECT foo
For those experienced using natural primary key designs, what update
strategies do you use when updating related tuples within a
transaction when the primary key is also subject to changes?
For example consider a table is vertically partitioned into two or
more segments (all related on the natura
Hi -
I have a database and used symbolic links in the tablespace definitions.
I just wanted to validate that I can move the database objects to a
different physical volume by the following:
1) issuing `pg_ctl stop`
2) hard copying the tablespace files from one drive to another
Alan McKay escribió:
> OK, looks like the time window is exactly when we run vacuum. That
> has been running now for a couple of months no problem, but the last 2
> weekends we've been doing massive data loads which could be
> complicating things.
>
> Is vacuum a good candidate for what could be
OK, looks like the time window is exactly when we run vacuum. That
has been running now for a couple of months no problem, but the last 2
weekends we've been doing massive data loads which could be
complicating things.
Is vacuum a good candidate for what could be locking up the tables?
Here is
try without the ccache? perhaps it is pulling in some stuff you don't expect.
On Mon, Sep 7, 2009 at 12:35 PM, Robert Creager wrote:
> Upgraded to Snow Leopard Saturday, and am having problems building now.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On Tue, Sep 08, 2009 at 10:32:53AM -0700, David Fetter wrote:
> On Tue, Sep 08, 2009 at 10:30:21AM -0700, David Fetter wrote:
> > Folks,
> >
> > For those of you who can't attend in person, we'll be streaming audio
> > and video and having a chat for tonight's SFPUG meeting on how the
> > planner
Scott Frankel wrote:
> Is it possible to perform a select in the where clause of a statement?
> I have a situation where I've got one arm tied behind my
> back: I can only have a single table in the select and from
> clauses, but the where clause appears to be freed from that
> restriction.
>
On Tue, Sep 08, 2009 at 10:30:21AM -0700, David Fetter wrote:
> Folks,
>
> For those of you who can't attend in person, we'll be streaming audio
> and video and having a chat for tonight's SFPUG meeting on how the
> planner uses statistics.
>
> Video:
>
> http://media.postgresql.org/sfpug/stream
Folks,
For those of you who can't attend in person, we'll be streaming audio
and video and having a chat for tonight's SFPUG meeting on how the
planner uses statistics.
Video:
http://media.postgresql.org/sfpug/streaming
Chat:
irc://irc.freenode.net/sfpug
Cheers,
David.
--
David Fetter http:
Hello,
Is it possible to perform a select in the where clause of a statement?
I have a situation where I've got one arm tied behind my back: I can
only have a single table in the select and from clauses, but the where
clause appears to be freed from that restriction.
Given a statement as
In some servers 8.4 pg_dump exits without any message if running from Task
Scheduler.
To explore this, I created scheduler task containing line
cmd
After that I can type manually commands:
C:\MyApp\pg_dump>dir /w
..
[.] [..] comerr32.dll
gssapi32.dll k5sprt32.dll
On Tue, Sep 08, 2009 at 05:58:01PM +0200, Kristian Larsson wrote:
> On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
> > I think the whole thing is a bit of a crock; adding integers to inet
> > addresses doesn't make a lot of sense logically. Perhaps what is
> > really wanted is functions
On Tue, Sep 08, 2009 at 05:58:00PM +0200, Kristian Larsson wrote:
> On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
> > Alvaro Herrera writes:
> > > I'd say this is just a missing feature.
> >
> > I think the whole thing is a bit of a crock; adding integers to inet
> > addresses doesn't
On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
> Alvaro Herrera writes:
> > I'd say this is just a missing feature.
>
> I think the whole thing is a bit of a crock; adding integers to inet
> addresses doesn't make a lot of sense logically. Perhaps what is
> really wanted is functions
On Tue, Sep 08, 2009 at 11:06:36AM -0400, Alvaro Herrera wrote:
> Kristian Larsson wrote:
>
> > And poking in pg_operator / pg_type seems to confirm this:
> >
> > nils=# SELECT (SELECT typname FROM pg_type WHERE typelem=oprleft), oprname,
> > (SELECT typname FROM pg_type WHERE typelem=oprright)
On Tue, Sep 08, 2009 at 06:29:28AM -0700, BlackMage wrote:
>
> I have a question about ordering by date. I have a table with two fields and
> some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B
Alvaro Herrera writes:
> I'd say this is just a missing feature.
I think the whole thing is a bit of a crock; adding integers to inet
addresses doesn't make a lot of sense logically. Perhaps what is
really wanted is functions on CIDR net identifiers, for instance
first_address('10/8') =
[ please CC the mailing list and not the list owner, they answer
mailing list questions not PG questions ]
On Tue, Sep 08, 2009 at 10:31:50AM -0400, Jia Chen wrote:
> Sam Mason wrote:
> >I don't think you need to go that far. I'd just do an "initdb"
> >somewhere on the removable disk and then
Kristian Larsson wrote:
> And poking in pg_operator / pg_type seems to confirm this:
>
> nils=# SELECT (SELECT typname FROM pg_type WHERE typelem=oprleft), oprname,
> (SELECT typname FROM pg_type WHERE typelem=oprright) FROM pg_operator WHERE
> oprleft=(SELECT typelem FROM pg_type WHERE typname
Kristian
assuming the max size of 8 byte integer is
http://www.postgresql.org/docs/8.1/static/datatype.html
bigint8 byteslarge-range integer-9223372036854775808 to 9223372036854775807
i dont know if a IPV6 address
99 99 99 99would fit into
9,223,372,
On Tue, Sep 08, 2009 at 06:29:28AM -0700, BlackMage wrote:
> I want to order by date and then by name, so I want the result A,B,C,D. The
> problem is when I do a 'SELECT * FROM table_name ORDER BY Event_Date, DESC',
> it includes the actual time (HH:MM:SS) so the order comes out B,A,D,C.
>
> So wh
On Tuesday 08 September 2009 6:29:28 am BlackMage wrote:
> I have a question about ordering by date. I have a table with two fields
> and some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B
In response to BlackMage :
>
> I have a question about ordering by date. I have a table with two fields and
> some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B |2009-0
In response to BlackMage :
>
> I have a question about ordering by date. I have a table with two fields and
> some date
>
> Name(character varying) | Event_Date(timestamp with timezone)
> A |2009-09-10 5:30:00
> B |2009-
I have a question about ordering by date. I have a table with two fields and
some date
Name(character varying) | Event_Date(timestamp with timezone)
A |2009-09-10 5:30:00
B |2009-09-10- 00:00:00
C
Hello!
I'm having some trouble with the inet data type and its
operators. Right now I'm relying on operations such as
kll=# SELECT '10.0.0.0/24'::inet + (2^(32-24))::integer;
?column?
-
10.0.1.0/24
(1 row)
to get the "next" available /24. This works all fine and dandy
for IPv
-- Forwarded message --
From: Markus Pscheidt
Date: 2009/9/8
Subject: Re: [GENERAL] Fail to start Postgres on Ubuntu kernel
2.6.28-15-generic
To: Filip Rembiałkowski
>
> quite a common problem... see
> http://www.postgresql.org/docs/8.3/static/kernel-resources.html
>
> obvious
On Tue, Sep 08, 2009 at 08:52:23AM +, Jasen Betts wrote:
> On 2009-09-08, Jia Chen wrote:
> > Now, I want to store PostgreSQL data on an external drive because I work
> > both on my office machine and on my home machine a lot. This way, I can
> > always bring my external drive to either loc
2009/9/8 Markus Pscheidt
>
> Hello,
>
> while on Ubuntu kernel 2.6.28-14-generic Postgres 8.3.7-1 works fine, it
> doesn't start on Ubuntu 9.04, kernel 2.6.28-15-generic. Following is the log
> output of 'sudo /etc/init.d/postgresql-8.3 start':
>
> Begin of log ==>
> 2009-09-08 08:17:52 CAT LOG:
Markus Pscheidt wrote:
> Hello,
>
> while on Ubuntu kernel 2.6.28-14-generic Postgres 8.3.7-1 works fine, it
> doesn't start on Ubuntu 9.04, kernel 2.6.28-15-generic. Following is the log
> output of 'sudo /etc/init.d/postgresql-8.3 start':
> 2009-09-08 08:17:52 CAT FATAL: could not create share
On 2009-09-08, Jia Chen wrote:
> Hi there,
>
> As a beginner of PostgreSQL, I installed PostgreSQL 8.3.7 on Ubuntu 9.04
> by using sudo apt-get install.
>
> Now, I want to store PostgreSQL data on an external drive because I work
> both on my office machine and on my home machine a lot. This w
On 2009-09-07, Alvaro Herrera wrote:
> Jasen Betts wrote:
>> On 2009-09-03, S Arvind wrote:
>> > --001636ed7465170dcf0472ab404d
>> > Content-Type: text/plain; charset=ISO-8859-1
>> >
>> > I have 2 doubts related to Filsesytem and Postgres data folder
>> >
>> > 1.Currently in CentOS, our postgres
hi jerry,
try killing mDNSResponder before restarting postgres:
sudo killall mDNSResponder
hopefully apple fixes this dns-problems in 10.6.1.
regards, jan otto
The rascal gets respawned immediately ;(
Of course it will be respawned, but all the cache is disposed (the
broken entries too
Hello,
while on Ubuntu kernel 2.6.28-14-generic Postgres 8.3.7-1 works fine, it
doesn't start on Ubuntu 9.04, kernel 2.6.28-15-generic. Following is the log
output of 'sudo /etc/init.d/postgresql-8.3 start':
Begin of log ==>
2009-09-08 08:17:52 CAT LOG: could not load root certificate file
"root
50 matches
Mail list logo
