Hi all,
Is there an easy way to copy a large object to a new one, having a new
OID and it's content independent from the original ?
The large object API functions would only allow to stream the original
to the client and stream it back to the server for the copy, which is
not really optimal... I
On Mon, Apr 14, 2008 at 09:10:52PM -0400, Tom Lane wrote:
> Actually, your mistake is in imagining that timestamptz represents the
> timezone explicitly ... it doesn't.
Which really is a great pity :-(
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E40
> Is there an easy way to copy a large object to a new one, having a new
> OID and it's content independent from the original ?
So my current solution would be:
CREATE OR REPLACE FUNCTION copy_blob(p_blobId OID)
RETURNS OID AS '
DECLARE
v_NewOID BIGINT;
BEGIN
SELECT lo_create(0) INTO v_Ne
[snip]
> DECLARE
> v_NewOID BIGINT;
^^
small correction: v_NewOID should be of type OID:
DECLARE
v_NewOID OID;
BIGINT would of course work too as long as there is implicit cast from
it to/from OID, which seems to be the case on 8.2.
Cheers,
Csaba.
--
Se
On Mon, Apr 14, 2008 at 09:39:57PM -0400, Tom Lane wrote:
> considering alignment...). ISTM that we have defined timestamptz
> in such a way that it solves many real-world problems, and timestamp
> also solves real-world problems,
No doubt about it.
> but the use-case for a timestamp plus an exp
On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> Of course, the actual time stored in the database in UTC is
> quite correct - it was indeed 3pm in location B when it was
> 7am in London. But we need to know the original local time
> (and also be able to know UTC since we want to
Hi there,
small problem with installing the tablefunc libs.
I have a 8.3.1 running on my Mac 10.5.
Now, I would like to add tablefunc.
Last time, I did it the following way:
# in the downloaded postgres package directory
$ ./compile
# in the tablefunc dir
$ USE_PGXS=1 sudo make
$ USE_PGXS=1
On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> Yes, I know about tagged types but have shyed away from them
> so far courtesy of them not being adjustable after the fact.
What do you mean by this? Adjustable in what way?
Truly, taggedtypes are a really useful feature but I thi
On Tuesday 15 April 2008 6:31 am, Sam Mason wrote:
> On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> > Of course, the actual time stored in the database in UTC is
> > quite correct - it was indeed 3pm in location B when it was
> > 7am in London. But we need to know the original l
On Tue, Apr 15, 2008 at 02:31:22PM +0100, Sam Mason wrote:
> On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> > Of course, the actual time stored in the database in UTC is
> > quite correct - it was indeed 3pm in location B when it was
> > 7am in London. But we need to know the o
On Mon, Apr 14, 2008 at 5:21 AM, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> I think there's something sub-optimal with generate_series.
> In the following, "documents" is a table with more than 12 rows,
> vacuumed and analyzed before the queries.
everything is working exactly as intended. wh
Added to TODO:
* Allow XML to accept more liberal DOCTYPE specifications
http://archives.postgresql.org/pgsql-general/2008-02/msg00347.php
---
Lawrence Oluyede wrote:
> As specified in the W3C Recommendation for XML the
On Tue, Apr 15, 2008 at 03:43:05PM +0200, Martijn van Oosterhout wrote:
> On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> > Yes, I know about tagged types but have shyed away from them
> > so far courtesy of them not being adjustable after the fact.
>
> What do you mean by this
On Tue, Apr 15, 2008 at 04:04:20PM +0200, Karsten Hilbert wrote:
> On Tue, Apr 15, 2008 at 02:31:22PM +0100, Sam Mason wrote:
> > On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> > > Of course, the actual time stored in the database in UTC is
> > > quite correct - it was indeed 3p
On Tue, Apr 15, 2008 at 06:48:27AM -0700, Adrian Klaver wrote:
> On Tuesday 15 April 2008 6:31 am, Sam Mason wrote:
> > My reasoning goes something like this: The WITH and WITHOUT clauses
> > seem to be the opposite of my naive understanding of their purpose. I'd
> > think that if you specify WIT
We are evaluating open source databases for use within our organization.
Can anyone tell me if postgresql have a precompiler for Micro focus
Cobol for Unix V 4.1 revision 040? Is there a list of these someplace?
I poked around on the postgres site.
Thanks
Craig
___
So I thought, "lets learn a bit of Python", and I stumbled upon
a choice of these two libraries. Whch would you suggest?
How do they differ?
By the looks of descriptions I am slightly inclined towards
psycopg2, but I would feel better if I talked with people
who actually used these libraries.
On Tue, Apr 15, 2008 at 04:23:42PM +0200, Karsten Hilbert wrote:
> When you delete a tagged type some cruft is left behind
> (not in the system catalog though).
>
> Perhaps I confuse this with some limitation of a previous
> implementation of the enum type. Also perhaps I was
> misguid
On Apr 15, 2008, at 10:27 AM, Dawid Kuroczko wrote:
So I thought, "lets learn a bit of Python", and I stumbled upon
a choice of these two libraries. Whch would you suggest?
How do they differ?
By the looks of descriptions I am slightly inclined towards
psycopg2, but I would feel better if I ta
Dawid Kuroczko wrote:
So I thought, "lets learn a bit of Python", and I stumbled upon
a choice of these two libraries. Whch would you suggest?
How do they differ?
Well, pygresql seems unmaintained since mid 2006 and the psycopg2 site
is currently and regularly down. Neither inspires confiden
Just a side note:
pyPgSQL is broken with standard_conforming_strings = on
(see groups.google.com/group/trac-dev)
2008/4/15, Dawid Kuroczko <[EMAIL PROTECTED]>:
> So I thought, "lets learn a bit of Python", and I stumbled upon
> a choice of these two libraries. Whch would you suggest?
> How do
I have Postgresql database that I would like to link to the geometry side of
Postgis. (This has little comparison to geography)
Does anyone know of a tool or documentation that could get me started??
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On Tue, Apr 15, 2008 at 10:37 AM, Ferry, Craig <[EMAIL PROTECTED]> wrote:
> We are evaluating open source databases for use within our organization.
> Can anyone tell me if postgresql have a precompiler for Micro focus Cobol
> for Unix V 4.1 revision 040? Is there a list of these someplace? I po
On Tue, Apr 15, 2008 at 09:21:19AM -0700, Steve Crawford wrote:
>> So I thought, "lets learn a bit of Python", and I stumbled upon
>> a choice of these two libraries. Whch would you suggest?
>> How do they differ?
>>
> Well, pygresql seems unmaintained since mid 2006 and the psycopg2 site
>
Ferry, Craig wrote:
> We are evaluating open source databases for use within our organization.
> Can anyone tell me if postgresql have a precompiler for Micro focus
> Cobol for Unix V 4.1 revision 040? Is there a list of these someplace?
> I poked around on the postgres site.
I see some people m
Version 8.3.1:
Is there a distinction between "ORIGIN" and "LOCAL" as related to
session_replication_role, and if so, what is it? I am unable to understand
from the documentation any distinction between the two settings.
TIA
--
Terry Lee Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hess
>I have Postgresql database that I would like to link to the geometry side of
>Postgis. (This has little comparison to geography)
>Does anyone know of a tool or documentation that could get me started??
>Bob
Bob,
I don't quite understand your question. Are you not sure how to install
PostGIS,
[GENERAL] Not GeographyI have PostgreSQL, c/w the geometry attachment,
installed on Win XP. I need to get started using it. I am best able to do that
by example, however a simple (geometry for dummies) description or a tool would
also help.
I am on the Postgis list but everyone there seems to b
I just made a typo in psql, and it resulted in something I wouldn't have
expected.
js=# \timimng
Showing only tuples.
js=# \t
Tuples only is off.
I also wouldn't have expected \timimng to have been interpreted as
\timing, which I tried to type in the first place, but perhaps a typo
like this
Try this
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01
As far as tools for viewing the data go, I would recommend Quantum GIS if you
are a beginner.
http://qgis.org/index.php?option=com_content&task=view&id=65&Itemid=71
Hope that helps,
Regina
_
Colin Wetherbee wrote:
I just made a typo in psql, and it resulted in something I wouldn't have
expected.
Oh, um, this was in the 8.3.1 psql.
Colin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/p
On Tue, 15 Apr 2008, Dawid Kuroczko wrote:
So I thought, "lets learn a bit of Python", and I stumbled upon
a choice of these two libraries. Whch would you suggest?
Use psycopg2. It's better maintained and has a better feature set at this
point. I would specifically recommend that you look
On Apr 14, 2:17 pm, [EMAIL PROTECTED] ("David Wilson") wrote:
> For instance, your count of distinct userids is probably not using the
> index you just created. If it still isn't using it after you ANALYZE
> the table, try rewriting the query using group by (select count(*)
> from (select userid fr
On Apr 14, 12:34 pm, Chris Browne <[EMAIL PROTECTED]> wrote:
> If the entire purpose of your application is to run COUNT(*)
haha. no. I see your point.
I'll be doing statistical functions on group-by's. So I'll go back
and give it another try with queries like those. And I'll use some of
the
Let me just start off by saying that I *want* to use postgresql.
That's my goal. I do not want to use SQLServer. I'm posting this
message not to slam postgres, but to ask for someone to help me figure
out what I'm doing wrong.
I've used postgres for several years as the backend to web
applicatio
local system: 8.2.7
remote system: 8.2.5
problem:
I have a small database with some tables. one of the tables had no
primary key, but a column with a fitting sequence (was created with serial).
so I added a primary key to it and it is visible and working.
but, when I dump some of the tables (4,
Hi all,
I migrate from 8.1 to 8.3.
In 8.2.7 and previous there are functions int4_text() and int8_text(),
in 8.3.0 they are missing (not documented that they are removed in the release
notes).
What I'm supposed to use instead of int8_text() now?
(I use my own datatype which is similar to varchar/
Hi all, i'll try a second time to post tips on the problem i'm facing
Fisrt sorry for my impatience; i first try to reed deeply as i can the
docs and then i tryed to setup a test env to run a PITR, but it didn't
work as is expected to.
Now i'm getting confused, so i really need help in tr
Colin Wetherbee <[EMAIL PROTECTED]> writes:
> I just made a typo in psql, and it resulted in something I wouldn't have
> expected.
> js=# \timimng
> Showing only tuples.
This is related to the discussion about whether to require a space
between a backslash command name and its arguments ...
[EMAIL PROTECTED] (Terry Lee Tucker) writes:
> Is there a distinction between "ORIGIN" and "LOCAL" as related to
> session_replication_role, and if so, what is it? I am unable to understand
> from the documentation any distinction between the two settings.
The intent is that a system that is the
On Tuesday 15 April 2008 14:26, Chris Browne wrote:
> [EMAIL PROTECTED] (Terry Lee Tucker) writes:
> > Is there a distinction between "ORIGIN" and "LOCAL" as related to
> > session_replication_role, and if so, what is it? I am unable to
> > understand from the documentation any distinction between
On Tue, Apr 15, 2008 at 1:36 PM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Ferry, Craig wrote:
> > We are evaluating open source databases for use within our organization.
> > Can anyone tell me if postgresql have a precompiler for Micro focus
> > Cobol for Unix V 4.1 revision 040? Is there a
I need to do a simple query and output to a file.
No problem.
But how do I encrypt one column's output?
There are lots of developer related links here, and info to "use the /
contrib pgcrypto", but I'm not a PG developer and I failed to find any
info on HOW TO USE that library function...
T
Tom Lane wrote:
Colin Wetherbee <[EMAIL PROTECTED]> writes:
I just made a typo in psql, and it resulted in something I
wouldn't have expected.
js=# \timimng Showing only tuples.
This is related to the discussion about whether to require a space
between a backslash command name and its argu
Colin Wetherbee <[EMAIL PROTECTED]> writes:
> I just thought I'd report it here in case it wasn't supposed to
> happen, but from what you say, it seems like it's a "feature".
Well, it's more of a historical hangover. Personally I'd not have
much problem with breaking backward compatibility on th
Tom Lane wrote:
Colin Wetherbee <[EMAIL PROTECTED]> writes:
I just thought I'd report it here in case it wasn't supposed to
happen, but from what you say, it seems like it's a "feature".
Well, it's more of a historical hangover. Personally I'd not have
much problem with breaking backward com
Hi.
I am trouble with my server postres on linux. It crashed!. I have folder
postgres installation that was my server. Is possible recovery data from folder
postgres installation? For example folder data?
Any can help me
Note: Sorry my bad english.
Thank you!
___
Stefan Schwarzer wrote:
> ld: file not found: ../../src/backend/postgres
It appears to be trying to link to the postgres executable (which is
presumably built with --export-dynamic to usefully permit that). The
postgres executable doesn't appear to be there.
At a guess, the module expects to be
Michael Enke wrote:
> Hi all,
> I migrate from 8.1 to 8.3.
> In 8.2.7 and previous there are functions int4_text() and int8_text(),
> in 8.3.0 they are missing (not documented that they are removed in the
> release notes).
> What I'm supposed to use instead of int8_text() now?
Probably an explicit
Orlando Solarte wrote:
> Hi.
>
> I am trouble with my server postres on linux. It crashed!. I have folder
> postgres installation that was my server. Is possible recovery data from
> folder postgres installation? For example folder data?
Unfortunately you have provided very little information.
ld: file not found: ../../src/backend/postgres
It appears to be trying to link to the postgres executable (which is
presumably built with --export-dynamic to usefully permit that). The
postgres executable doesn't appear to be there.
At a guess, the module expects to be built from a particular l
Stefan Schwarzer wrote:
>>> ld: file not found: ../../src/backend/postgres
>>
>> It appears to be trying to link to the postgres executable (which is
>> presumably built with --export-dynamic to usefully permit that). The
>> postgres executable doesn't appear to be there.
>>
>> At a guess, the modu
Ralph Smith wrote:
I need to do a simple query and output to a file.
No problem.
But how do I encrypt one column's output?
There are lots of developer related links here, and info to "use the
/contrib pgcrypto", but I'm not a PG developer and I failed to find any
info on HOW TO USE that libra
53 matches
Mail list logo
