mmm... I don't understand. The query brings a resultset just like the one you asked.
When you say that 'there's no guarantee that A field is sorted or unique...', what do you mean? The query doesn't care about the "A" field, it just needs "UID" to be a candidate key.
And I still don't und
I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system,
installed from rpms.
There seemed to be some files required for installation of tsearch
missing so I downloaded the src bundle too.
Tsearch2 then compiled ok but now the command:
psql mydb < tsearch2.sql
fails with a messa
On Tue, Aug 05, 2003 at 21:00:53 -0300,
The Hermit Hacker <[EMAIL PROTECTED]> wrote:
>
> Just a quick note to everyone that v7.4 is now official in Beta Freeze,
> with the first Bundle available for download, testing and bug reports ...
http://developer.postgresql.org/beta.php doesn't point to
On 6 Aug 2003 at 14:34, Jan Oksfeldt Jonasen wrote:
> Hi,
> I'm a very new user of the PostgreSQL database, but I've quickly
> encountered what I consider an pretty odd error. Let it be said, this is
> using the PeerDirect PostgreSQL Beta 4 using Win2K SP3, so it's bound to
> have certain issue
You are correct Tom, vtquotehistory is a view of tquotehistory, and I am
trying to log in this example. Sorry I didn't point that out. The view is a
straight view with no WHERE clause or criteria of any kind. The UPDATE does
cause the OLD record to become updated to whatever changes have been set a
On Wed, Aug 06, 2003 at 11:28:23 -0300,
Kolus Maximiliano <[EMAIL PROTECTED]> wrote:
>
> I'm about to install postgres on a box that has daemontools on it
> and I would like to use it. Is there anybody here already running postgres
> from daemontools? Is it advisable? Do you have any probl
Bad form to reply to my own posting i know but -
I notice that the integer dictionary can accept MAXLEN for the longest
number that is considered a valid integer. Can i set MAXLEN for the en
dictionary to be the longest word i want indexed?
I think i'd need to create a new dictionary...?
>
Hi,
v7.3.3
$ pg_dump -Ft -v test1 | gzip > test1.pdmp.tar.gz
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user-defined types
[snip]
pg_dump: dumping contents of table t_lane_tx2
pg_dump: dumping contents of table t_lane_tx
pg_dump: [tar archiver] could not writ
We recently started using daemontools to manage the herd of postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.
We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/ mimics "pg_c
Don't know the answer to your question, but I thought I would just pipe
in and say that if this is an SMP (has multiple processors) Linux box
you don't want to use ext3!!!
I used ext3 on my SMP box here at work and now I can't have children (I
guess it would help if I got a wife first)!!
But i
On Wed, 6 Aug 2003, Peter Eisentraut wrote:
> scott.marlowe writes:
>
> > Do we need official permission to call the language plPHP by the way?
>
> Can someone explain to me why language handler modules for PostgreSQL are
> always called "PL/Language"? Consider if someone wrote a language binding
> > If you could replicate/rsync pg_xlog to another machine, you could get
it
> > correctly in case of failover.
>
> Argh.. I forgot.. Simple option is to sync the pg_xlog while doing
failover. It
> might add some 10 odd sec to failover process but should be bullet proof..
>
> I don't know if PG i
On Wed, Aug 06, 2003 at 03:06:12PM +0100, Jan Oksfeldt Jonasen wrote:
> At 01:40 PM 8/6/2003, Peter Eisentraut wrote:
> >You need to double-quote the names or they will be converted to lower
> >case.
> >
>
> Thank you both. The reason why the initial table creation have quoted
> columns names is
Ron Johnson <[EMAIL PROTECTED]> writes:
> $ pg_dump -Ft -v test1 | gzip > test1.pdmp.tar.gz
> pg_dump: saving database definition
> pg_dump: reading namespaces
> pg_dump: reading user-defined types
> [snip]
> pg_dump: dumping contents of table t_lane_tx2
> pg_dump: dumping contents of table t_lane_
I've encountered this a few times with 7.2 and 7.3.
If I do pg_dump of some large (> 100Mb - the bigger the more likely)
database, and it gets interrupted for some reason (e.g. the target disk
fills up), the source database become corrupt. I start getting errors
like:
open of /var/lib/pgsql/data/
Hello,
You really don't want to do this. 7.3.x is much more stable,
offers better support for various things and handles load much better.
If you need a 7.3.x host look at (plug) www.commandprompt.com
or even phHoster.com
J
Ian Barwick wrote:
On Tuesday 15 July 2003 09:51, Stefan Armbruster wr
Hi,
> Why would you want to do that?
>
> Why not do it an easier way and dump the database and restore it into
> your new database?
>
> There's got to be a lot of stuff to consider when doing something as
> radical as renaming a database.
He is not talking about renaming his database, he is talki
Hi All,
I updated postgre from 7.2.4 to 7.3.2 in my RHLinux7.3 system and updated
current pghba.conf and postgresql.conf files as per my need. But If I try to
connect through PHP which was connecting earlier with 7.2.4 is giving the
following error
Fatal error: Call to undefined function: pg_conn
18 matches
Mail list logo
