Hi,
-- Brennan Stewart <[EMAIL PROTECTED]> wrote:
> Before I analyze these tools, I would appreciate input from the community
> on what sort of information is important for Postgresql users to know about
> these design&administration tools. Sample list (just a few from my own)
> operating system
Hi,
> Has anyone heard any more about this problem? I also haven't gotten
> anything from pgsql-general since Oct. 1. The other lists seem to be
> working fine for me.
I got since about one hour mails to an old account, which I disabled months
ago.
Perhaps someone took an old backup?
Ciao
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I want to change a column from text to bytea; since it seems that alter
table can't change the column type, i have to add a temporary column and
copy the data from the old one to the new, delete the old and rename the
new.
But it seems that Post
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
- -- Alvar Freude <[EMAIL PROTECTED]> wrote:
> But it seems that Postgres can't cast text to bytea:
>
> odem=> UPDATE forum_gtree SET gid2=gid::bytea;
> ERROR: Cannot cast type text to bytea
I tryed it wit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
the following I posted already on pgsql-bugs -- perhaps someone has a good
workaround or fix or can say me that I'm wrong?
There seems to be a bug in handling bytea columns with index and the
like-operator.
When an index scan on a bytea column i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- -- Dr NoName <[EMAIL PROTECTED]> wrote:
> Help!
you may look in the archives; one day ago there was the same question.
Ciao
Alvar
- --
** Alvar C.H. Freude -- http://alvar.a-blast.org/ -- http://odem.org/
** Berufsverbot? http://odem.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
- -- "Joe \"Nuke Me Xemu\" Foster" <[EMAIL PROTECTED]> wrote:
> Here's an alternative which may not perform very well but may
> still be better than risking a full table-scan...
I use exactly this method in a forum software, and it performs VERY
Hi,
I'm new on this list, so if the questions are better on some other
lists, please let me know!
Are there somewhere detailed informations about arrays?
Has Postgres some special array functions like push, shift, unshift ...
in Perl?
How it is possible to use arrays in subselects? I tested
Hi,
I'm thinking about, what might be faster on SELECTs: a column with index
which is NOT NULL and takes the value of 0 or a column which can take
the NULL value instead of 0, also with index.
My feeling sais, that 0 and NOT NULL should be a lot more faster, but
perhaps it's not true?
bye
Al
Hi,
>
> Secondly, how can i have stadistics of how many times an users has got
> into the privated directory. (any suggestion) Perhaps could be a script
> to write into the database. ?¿?
for this, you can use the standard Apache logfiles, if you don't need it
inside the Database.
For auth, I g
Hi,
> > try to make the commit every 500 or 1000 inserts. It seems to me, that
> > PG slow down if there are lots of MBs waiting for commit ...
>
> MB == Memory Buffers?
> If so then it shouldn't be the case for 7.0.X with Tom' work in bufmgr area.
Megabytes :-)
tested in 7.1
The inserts slo
Hi,
Konstantinos Agouros schrieb:
>
> When I insert I do something like $dbh->{'AutoCommit'} = 0 and every 100,000
> entries or so I do a commit.
try to make the commit every 500 or 1000 inserts. It seems to me, that
PG slow down if there are lots of MBs waiting for commit ...
And also try to
Hi,
what is the best method to make concurrent inserts to a table with
unique/primary key?
Scenario:
I write a DBI logger for Apache, and this uses a table for all referers:
CREATE TABLE referer (
id SERIAL,
referer varchar(2048) NOT NULL PRIMARY KEY
);
so, you can im
Hi,
Richard Huxton wrote:
>
> > CREATE TABLE referer (
> >id SERIAL,
> >referer varchar(2048) NOT NULL PRIMARY KEY
> >);
[...]
>
> Why have you got id as a serial if referer is your primary key? Oh - I
> suppose it's easier to reference a serial of course, less data to carry
> aroun
14 matches
Mail list logo
