On Mon, 2009-07-13 at 00:53 +0100, Greg Stark wrote:
> Also counter-productive since vacuum full actually causes indexes to
> grow, not shrink.
As a result, your indexes may be quite bloated. Consider REINDEXing them
to get them back to sensible sizes, then avoiding VACUUM FULL.
--
Craig Ringer
Hello
I am researching how to store the data for easy 'user-driven'
reporting (where I do not need to develop application for
every user request).
The data will typically be number ranges and text strings with
unique Id for each row
I hope there will be a lot of data :-).
So in that anticipati
On Mon, Jul 13, 2009 at 2:05 AM, Philippe Lang wrote:
> Hi,
>
> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
> there a chance we can see one day "START WITH... CONNECT BY" in
> Postgresql, or is that something 100% oracle-specific?
There is a commercial / proprietary
On Mon, Jul 13, 2009 at 2:05 AM, Philippe Lang wrote:
> Hi,
>
> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
> there a chance we can see one day "START WITH... CONNECT BY" in
> Postgresql, or is that something 100% oracle-specific?
There is a commercial / proprietary
Hi,
I need to do some reporting for projects that have some columns that
stay the same for every project and then every project brings along some
project specific stuff.
Now I've got a big view for everyone of those about 100 projects (and
growing) that is about 80% the same as every other view
FYI, for general email readers, I am sending pg_migrator reports to
hackers instead of having them be dealt with on the 'general' list.
---
Tilmann Singer wrote:
> I tried the latest pg_migrator
> (http://pgfoundry.org/frs/d
Hi -
This is probably more helpful - the pg_largeobject table only changed after
vacuumlo, not before. When comparing pre- and post- pg_migrator databases
(no vacuum or vacuumlo):
select * from pg_largeobject where loid = '24696063';
in the pre- there are three rows, having pageno 0 through 3, i
I tried the latest pg_migrator
(http://pgfoundry.org/frs/download.php/2291/pg_migrator-8.4.tgz) to
migrate a database from an 8.3.7 to an 8.4.0 cluster. It finished with
a success message, and the schema and all tables seem to have been
migrated correctly.
However, all of the sequences were at the
Congratulations on the new release of benetl!
Thank you for the announcement. I see you've cross-posted to pgsql-
announce as well, which is the appropriate list for announcements. In
the future, please don't include discussion lists in product
announcements. Thanks!
On Jul 13, 2009, at 17
Hi -
After what seemed to be a normal successful pg_migrator migration from 8.3.7
to 8.4.0, in either link or copy mode, vacuumlo fails on both our production
and qa databases:
Jul 1 11:17:03 db2 postgres[9321]: [14-1] LOG: duration: 175.563 ms
statement: DELETE FROM vacuum_l WHERE lo IN (SELEC
Dear all,
Benetl, a free ETL tool for files using postgreSQL, is out in version 2.9.
You can freely download it at : www.benetl.net
Benetl version 2.9 has an improved GUI and is supporting postgreSQL 8.4.
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_
> So this thought leads to a couple of other things Dan could test.
> First, see if turning off full_page_writes makes the hiccup go away.
> If so, we know the problem is in this area (though still not exactly
> which reason); if not we need another idea. That's not a good permanent
> fix though,
Martie Krukkeland wrote on 13.07.2009 21:11:
If you are using Windows:
Windows has the build in: Scheduled-Task (this is the Windows-equivelant of
the Unix-Cron).
It can be found in the Configuration-Screen.
Or simply using the "at" command
--
Sent via pgsql-general mailing list (pgsql-ge
""Raymond O'Donnell"" schreef in bericht
news:4a5b4a6f.1080...@iol.ie...
> On 13/07/2009 09:02, hendra kusuma wrote:
>> On Sat, Jul 11, 2009 at 9:03 PM, Raymond O'Donnell wrote:
>>
>>> On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote:
>>>
I want to know if you can create a store
Tom Lane wrote:
> (I believe that 8.3 takes braces too ... but it's pickier about where
> it allows dashes.)
This is what the 8.3 comment says:
/*
* We allow UUIDs in three input formats: 8x-4x-4x-4x-12x,
* {8x-4x-4x-4x-12x}, and 32x, where "nx" means n hexadecimal digits
* (only the first fo
On Mon, Jul 13, 2009 at 03:28:09PM -0400, Tom Lane wrote:
- David Kerr writes:
- > Tried w/o escaping:
- > insert into testuuid values ('{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}');
- > ERROR: invalid input syntax for uuid:
"{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}"
-
- Works for me:
-
- regression=#
On Mon, Jul 13, 2009 at 06:57:43PM +, Nelson Correia wrote:
> Running pg_dump from another machine needs much space on the DB
> host? Or it just outputs the data as it goes?
pg_dump should use very little space on the server, it just streams it
out to where ever you tell it. You could run pg_
David Kerr writes:
> Tried w/o escaping:
> insert into testuuid values ('{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}');
> ERROR: invalid input syntax for uuid: "{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}"
Works for me:
regression=# select '{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}'::uuid;
uui
In the docs for the uuid datatype it states:
(http://www.postgresql.org/docs/8.4/static/datatype-uuid.html)
PostgreSQL also accepts the following alternative forms for input: use of
upper-case digits, the standard format surrounded by braces, omitting some
or all hyphens, adding a hyphen after an
Hi all,
I need to do a backup from a big table that is in a machine with almost no disk
space.
Running pg_dump from another machine needs much space on the DB host? Or it
just outputs the data as it goes?
Is there a better way to do this?
Thanks,
Nelson
I already miss the pginstall installers from postgresql.org. they had
everything in them. I was thinking of switching over from the EnterpriseDB
installers to the postgresql installers on next rev (8.4) but now I can't
because they are not available anymore.
I am not so sure the EnterpriseDB
Tom Lane wrote:
>> I'm in the process of upgrading a Fedora 10 box to 11. So
>> far, Fedora's repository carries only 8.3.7. I am a bit he-
>> sitant to use the yum.pgsqlrpms.org repository's packages as
>> I like to keep the number of repositories as small as possi-
>> ble. So:
>> - Is there an
On Monday 13 July 2009 06:54:54 Tom Lane wrote:
> Alvaro Herrera writes:
> > If that's the problem, my 2c is that uuid_hash is too generic a name to
> > export and we should change ours.
>
> Too late for existing releases (since it would force initdb to fix the
> pg_proc entry). We could change i
Tim Landscheidt writes:
> I'm in the process of upgrading a Fedora 10 box to 11. So
> far, Fedora's repository carries only 8.3.7. I am a bit he-
> sitant to use the yum.pgsqlrpms.org repository's packages as
> I like to keep the number of repositories as small as possi-
> ble. So:
> - Is there a
Andreas escribió:
> Hi,
> I've got a similar issue with a function that uses regular-expression-magic.
> I got it from the sql list and it works but I'm just about 75% aware of how.
> Still PG complains about those \\ everywhere.
>
> Replacing every \ by || E'\\' || would make it ... cough ...
On Mon, 2009-07-13 at 12:11 +0200, Antonio Muñoz wrote:
> Can you tell me if Postgres/Postgis can use both spatial and
> alfanumeric indexes, at the same time, in the same query?
Yes, it can. Postgres will use all and any indexes available to it. In
some cases, multiple indexes of different type
Hi,
I'm in the process of upgrading a Fedora 10 box to 11. So
far, Fedora's repository carries only 8.3.7. I am a bit he-
sitant to use the yum.pgsqlrpms.org repository's packages as
I like to keep the number of repositories as small as possi-
ble. So:
- Is there any ETA for official Fedora 11 pa
Thank you for that.
Having done some further investigation I had concluded that the problem was
probably with the LIKE (~~) comparison. I created a text dump file with the -d
(use INSERT rather than COPY) option so that I could see which rows failed. All
of the rows which exercised the LIKE te
Alvaro Herrera writes:
> If that's the problem, my 2c is that uuid_hash is too generic a name to
> export and we should change ours.
Too late for existing releases (since it would force initdb to fix the
pg_proc entry). We could change it in HEAD, but how much will that
really help?
Hi,
I've got a similar issue with a function that uses regular-expression-magic.
I got it from the sql list and it works but I'm just about 75% aware of how.
Still PG complains about those \\ everywhere.
Replacing every \ by || E'\\' || would make it ... cough ... not
looking cuter as it all
On 13/07/2009 09:02, hendra kusuma wrote:
> On Sat, Jul 11, 2009 at 9:03 PM, Raymond O'Donnell wrote:
>
>> On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote:
>>
>>> I want to know if you can create a store procedure that run
>>> automatically after a certain time, something like a timer
David Fetter, 13.07.2009 16:32:
START WITH is Oracle specific whereas recursive CTEs are an ANSI
Standard (supported by PostgreSQL, Firebird and SQL Server).
Not to mention DB2. I'm not sure how close Firebird is to actually
shipping them...
Interesting, didn't know DB2 had them as well.
On Sunday 12 July 2009 13:19:50 Phoenix Kiula wrote:
> Hi. I *always* get an error moving my current fully utf-8 database
> data into a new DB.
>
> My server has the version 8.3 with a five year old DB. Everything, all
> collation, LC_LOCALE etc are all utf8.
>
> When I install a new Postgresql 8.4
Dimitri Fontaine wrote:
> Mel Flynn writes:
>
> > Is there a way in the API to tell the backend that "uuid_hash function is
> > implemented by the foo__uuid_hash function" so that backwards compatibility
> > isn't broken?
>
> Yes.
> http://www.postgresql.org/docs/8.3/interactive/xfunc-c.html
On Mon, Jul 13, 2009 at 08:23:56AM +0200, Thomas Kellerer wrote:
> Philippe Lang, 13.07.2009 08:05:
>> Hi,
>>
>> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks!
>> :)), is there a chance we can see one day "START WITH... CONNECT
>> BY" in Postgresql, or is that something 100% oracl
2009/7/13 Tom Lane :
> No, you're misinterpreting the message. What that code likely means
> is that something is trying to use SPI and finding plpgsql already
> connected. In other words, plpgsql forgets to do a SPI_push() before
> calling something that might try to use SPI re-entrantly. It sh
Alan Millington writes:
> CONSTRAINT "RP_DATE_check" CHECK (date IS NULL AND accuracy = '?'::bpchar OR
> date IS NOT NULL AND date > '1099-12-31'::date AND (accuracy = 'D'::bpchar OR
> accuracy = 'M'::bpchar AND date::text ~~ '%-01'::text OR (accuracy =
> 'Y'::bpchar OR accuracy = '?'::bpchar)
Michael Gould wrote:
> I would like to know what the formal method of requesting new features are
> for Postgres and how are decisions made which features are included in a
> future release or not.
Uh, you usually ask for the feature on the bugs or hackers email lists,
and if we consider it useful
Marek Lewczuk writes:
>>> I have made an upgrade to PG 8.4 and following error was thrown during
>>> execution of some pl/pgsql function:
>>> ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT
>>
> I can't prepare an example, cause I can't reproduce this error in an
> example, but in production
> > Details:
> >
> > In addition to the existing aggregate functions (avg, stddev etc),
> it would
> > be nice if postgres could return further information. For example,
> the
> > quartiles, percentiles, and median.
[Spotts, Christopher]
If you're interested in doing real stat work in postgres, tr
I would like to know what the formal method of requesting new features are
for Postgres and how are decisions made which features are included in a
future release or not.
Best Regards
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
--
Sent vi
I'm using PostgreSQl NPGSQL and C#.
Does the Rowsaffected return value work correctly when running a stored
procedure to Insert, Update or Delete. According to the documentation, it
should work with Insert, Update and Delete querys via ExecNonQuery, but
can't find out if it should work if you do t
2009/7/10 Tom Lane :
> Marek Lewczuk writes:
>> I have made an upgrade to PG 8.4 and following error was thrown during
>> execution of some pl/pgsql function:
>> ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT
>
> Really? Could we see a self-contained example?
Really... And what is very prob
> I don't get it,
> you mean even if the field contain some data, it would be set to null
> if your update statement do not update the field?
Exactly. In my example, I have a record that shows current status and
can be updated by multiple processes. The only thing that is relevant
when I look at i
On Monday 13. July 2009, Jasen Betts wrote:
>you should wait. 8.4 is in debian now so should be in ubuntu RSN.
One day I'm sure it will even be available in Gentoo.
*sigh*
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
--
Sent via pgsq
Hi all.
Can you tell me if Postgres/Postgis can use both spatial and alfanumeric
indexes, at the same time, in the same query?
Thanks in advance.
On 2009-07-10, Jorge Arangoitia Fernandez Baca
wrote:
>
> --Apple-Mail-5-516743627
> Content-Type: text/plain;
> charset=US-ASCII;
> format=flowed;
> delsp=yes
> Content-Transfer-Encoding: 7bit
>
> Hi
>
> I want to know if you can create a store procedure that run
> automatica
I am running Postgres 8.1.4 on Windows XP Professional Service Pack 3.
I recently tried to make a copy of an existing database. I made a dump using
pg_dump -Fc, I created a new database from template0, and attempted to restore
into it using pg_restore. The tables were created and about half we
On 2009-07-10, Tim Uckun wrote:
> I don't see any ubuntu packages for 8.4 in the default repositories.
>
> Does anybody know if they will be upgrading the postgresql package to
> 8.4 or creating a new package for it.
As 8.4 is not data-compatible with 8.3, it will be a new package.
if ubuntu are
2009/7/13 Scott Marlowe :
> On Mon, Jul 13, 2009 at 3:35 AM, Pavel Stehule wrote:
>> 2009/7/13 Philippe Lang :
>>> Hi,
>>>
>>> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
>>> there a chance we can see one day "START WITH... CONNECT BY" in
>>> Postgresql, or is that some
On Mon, Jul 13, 2009 at 3:35 AM, Pavel Stehule wrote:
> 2009/7/13 Philippe Lang :
>> Hi,
>>
>> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
>> there a chance we can see one day "START WITH... CONNECT BY" in
>> Postgresql, or is that something 100% oracle-specific?
>
> It
2009/7/13 Philippe Lang :
> Hi,
>
> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
> there a chance we can see one day "START WITH... CONNECT BY" in
> Postgresql, or is that something 100% oracle-specific?
It is not probable.
regards
Pavel Stěhule
>
> Best regards,
>
>
Mel Flynn writes:
> Is there a way in the API to tell the backend that "uuid_hash function is
> implemented by the foo__uuid_hash function" so that backwards compatibility
> isn't broken?
Yes.
http://www.postgresql.org/docs/8.3/interactive/xfunc-c.html#XFUNC-C-PGXS
For example:
CREATE OR R
On Mon, 13 Jul 2009 01:31:05 +0300, Tom Lane wrote:
> You can't do this. The problem in your case is that the INSERT happens,
> and then the rule fires and finds the inserted row, which it happily
> updates. See the manual's explanation:
> http://www.postgresql.org/docs/8.3/static/rules-update.
Phoenix Kiula wrote:
> Hi. I *always* get an error moving my current fully utf-8 database
> data into a new DB.
>
> My server has the version 8.3 with a five year old DB. Everything, all
> collation, LC_LOCALE etc are all utf8.
>
> When I install a new Postgresql 8.4 on my home Mac OSX machine (a
On Sun, Jul 12, 2009 at 5:53 PM, David Fetter wrote:
>> [mode would also be useful, as an explicit function, though we can get it
>> easily enough using count(1) order by count desc].
>
> You can get that with windowing functions, too. :)
>
>> According to google, this has been a wish since at leas
Andreas wrote:
> who should own the db objects?
> I once read one should not let postgres or any other superuser own the
> tables and what not.
> Instead one should better create a separate user role with little
> privileges to be the owner.
> I'm not quite sure why this was abvised. Maybe like n
Hi,
I'm trying to write a uuid extension using the FreeBSD libc uuid(3). I quickly
came to the conclusion it won't work, because:
/usr/include/uuid.h:54: error: conflicting types for 'uuid_hash'
../../src/include/utils/builtins.h:1010: error: previous declaration of
'uuid_hash' was here
Is ther
Hi all,
I have a .NET application that uses PG as backend using Npgsql.
I have however a small problem when inserting images into the database.
All goes fine and my images gets uploaded correctly, however after
successful upload the system needs to send out email notifications to
users based
I need to know if a field was updated in an update statement, even if it
was updated to the same value that it already contained.
Basically, I want the field to be automatically set to null if the
update statement didn't manually set it to something.
I could not figure out how to do this with a
60 matches
Mail list logo
