Adam Seering wrote:
Thanks for the link; still trying to figure out how to use these
functions, though.
The link that you sent suggests that these commands are really only
useful for writing out data to server-side files, which isn't so much
what I want. What I really want is to lo_o
--- On Sat, 15/11/08, Tony Caduto <[EMAIL PROTECTED]> wrote:
> Hi,
> We have been running into issues where the 8.3.x versions
> of libpq.dll will not load in certain
> versions of windows and WINE(does not load at all on wine).
>
> It seems to be hit and miss on Windows XP, mostly seems to
> affe
On Sat, 2008-11-15 at 23:27 +0100, Enrico Pirozzi wrote:
> Hi all,
> Is it present on postgresql 8.3.x any implementation of an unsigned int type?
No. Just use bigint with a check constraint or a domain. There also
might be (I don't recall) a project over at http://www.pgfoundry.org/
that provides
Hi,
We have been running into issues where the 8.3.x versions of libpq.dll
will not load in certain
versions of windows and WINE(does not load at all on wine).
It seems to be hit and miss on Windows XP, mostly seems to affect SP3
and some SP2 installs of XP.
I have only been able to get arou
Hi all,
Is it present on postgresql 8.3.x any implementation of an unsigned int type?
Regards,
Enrico
--
That's one small step for man; one giant leap for mankind
www.enricopirozzi.info
[EMAIL PROTECTED]
Skype sscotty71
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Thanks Scott. Could be my I/O as I am on 15k Raptor SATA drives with
RAID 1 only.
Anyway, reindexing happened fast (12 minutes) and things are now humming along.
How long should cluster take on a db that's about 5.5GB in size? Is it
worth doing on a production db? The db is running fast now anywa
On Sat, Nov 15, 2008 at 2:45 PM, Serge Fonville
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have been using PostgreSQL for quite a while now.
> And (pure out of interest) been trying to build a Windows x64 version of it.
There was a discussion of this very subject here a few months ago, you
should look
On Sat, Nov 15, 2008 at 2:36 PM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> Hi.
>
> Per this thread:
> http://archives.postgresql.org/pgsql-general/2008-11/msg00608.php -- I
> think I understood that the time had come for my db to have a VACUUM
> FULL. (Regular autovacuum etc is working)
>
> I know
Hi,
I have been using PostgreSQL for quite a while now.
And (pure out of interest) been trying to build a Windows x64 version of it.
I suspect I either need mingw-w64 or Visual Studio.
I already found a x64 version of some of the required tools.
Unfortunately it seems 'impossible' to build an x64
Hi.
Per this thread:
http://archives.postgresql.org/pgsql-general/2008-11/msg00608.php -- I
think I understood that the time had come for my db to have a VACUUM
FULL. (Regular autovacuum etc is working)
I know a full vacuum is slow. A simple google search had suggested so.
But I had no idea it w
Hello
I am not sure, but you are first who try to work with LO inside PL.
Current LO interface works well for client side, and probably doesn't
work on server side via SPI interface - so I am sure, so some is
possible, but you need do some C hacking.
regards
Pavel Stehule
2008/11/15 Adam Seering
Klint Gore wrote:
I'm playing around with storing custom preprocessed data
structures within Large Objects. I'd like to be able to write a
custom function that will, within a query, let me select out
particular bytestrings from the middle of a Large Object (within C, I
think 'lo_lseek'
Dean Rasheed <[EMAIL PROTECTED]> writes:
>> Referential integrity actions execute as the owner of the table, so
>> anything triggered by them would execute as the owner too.
> Hmm, that opens up a very nasty gotcha, as shown by the script
> below. What user1 does looks, at first sight, fairly inno
> What's mess up is that the solution given the user DOES work.
What's messed up is that a person asking for free help from a group of
volunteers would insistently place unusual restrictions on how she will
accept that help, then lecture those who tried to help but hadn't noticed
her specific term
On Sat, Nov 15, 2008 at 9:33 AM, Scott Ribe <[EMAIL PROTECTED]> wrote:
>> And what does this have to do with CC? The CCs come in without
>> passing the listserver and I do not want this mail!
>
> And if someone makes a mistake and accidentally emails you directly, WHILE
> TRYING TO HELP YOU AND AN
> And what does this have to do with CC? The CCs come in without
> passing the listserver and I do not want this mail!
And if someone makes a mistake and accidentally emails you directly, WHILE
TRYING TO HELP YOU AND ANSWER YOUR QUESTION, perhaps you should react
gracefully instead of being a whi
Hello
I have some "for x in select ..." loops which compares current record
with previous ones. Is it possible to check if such loop is reaching
final pass?
Now, I check "found" variable after the loop and usually duplicate part
of it's code.
--
Regards,
Tomasz Myrta
--
Sent via pgsql-gen
paulo matadr wrote:
>
> Let me see, for example one insert type (inser into table2 (select *
> from table1), where table have size 26megas,make 226megas for archives
> files.
> (i made a test with parameter wal_bufffer before this is defaul value
> 64k and the same commando make 640megas of archi
> Referential integrity actions execute as the owner of the table, so
> anything triggered by them would execute as the owner too.
>
> regards, tom lane
Hmm, that opens up a very nasty gotcha, as shown by the script
below. What user1 does looks, at first sight, fairly innoc
19 matches
Mail list logo