Hi,
Thanks for your prompt reply.
I think I didn't explained the problem
clearly.
Actually when a client (from an application like java)
tries to access the server database which is in network
How could I solve the problem. Is 'RAISE EXCEPTION' solves
the above problem. If s
Do you know of a better way to handle multitable references?
Sure.
SET CONSTRAINTS DEFERRED;
BEGIN;
insert this
insert that
END;
That only handles single table references.
For example, I have a database with a "notes" table. This table is used
to store annotations on ANY record
Dear Bruce and others ,
Thanks For the responce and your kind help
I have a little problem i hope you would be intrested in troubleshooting it
I am using plperl and
NET::Jabber for the postgresql connection to jabber and walah!! it realy
connects and sends messages to all the targets use
resolved the previous question regarding scoring to some extent...
currently have this select;
SELECT *, (
(CASE WHEN (keywords ~* '.*MySearchString.*') THEN 5 ELSE 0 END) +
(CASE WHEN (title ~* '.*MySearchString.*') THEN 3 ELSE 0 END) +
(CASE WHEN (description ~* '.*MySearchString.*') THEN 1 ELS
Maybe the best option (specialy if you need users to control the jobs) would be to create a table like this:
CREATE TABLE batchjobs (
id SERIAL,
sql TEXT NOT NULL,
done BOOLEAN NOT NOOL DEFAULT false
);
Then you create a pl/pgsql function that iterates every "undone" record from this
On Tue, 2003-07-29 at 05:48, Andreas Jung wrote:
> On Tue, 2003-07-29 at 12:42, Shridhar Daithankar wrote:
> > On 29 Jul 2003 at 12:33, Andreas Jung wrote:
> > > we are running Postgres 7.3.3 successfully on our portal sites
> > > under Solaris. For a new project we have the requirement that
> > >
[EMAIL PROTECTED] writes:
> I have this problem with a nightly script that dumps the db:
> pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to
> timestamp
> pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb,
> usesuper, CAST(valuntil AS timestamp) FROM pg_sha
On Mon, 28 Jul 2003, Terence Chang wrote:
> hi Scott:
>
> Would you be kind to tell me what commercial replication package out there?
> Thanks!
>
> Basically, my server will not be 24x7. So it is ok to shut down the machine.
> And we only want to clone the database for a brand new machine.
The
Deepa K wrote:
Hi,
Thanks for your prompt reply.
I think I didn't explained the problem
clearly.
Actually when a client (from an application like java)
tries to access the server database which is in network
How could I solve the problem. Is 'RAISE EXCEPTION' solves
the above
> So, how can you possibly tell when looking at your note which entry it
> applies to?
That's easy - these are always referred from the table, never to the
table. In the few instances where I go the other way, it's limited to 2
or 3 tables, and I do separate joins combined with a UNION.
> When y
If I understand your idea, and Postgres, this is like saying you want multiple backend processes, and definite, "NO". As far as I know, one connection == 1 xaction.
Andreas Jung wrote:
hi,
we are running Postgres 7.3.3 successfully on our portal sites
under Solaris. For a new project we have the
How does line completion gets to psql?
At my FreeBSD machines when I build the PostgreSQL port I have always had
line completion. Now I need to do some work on a Linux SUSE machine (which
I don't administer) and psql doesn't have line completion.
The person that manages the machine installed from
Jonathan Bartlett wrote:
In the few instances where I go the other way, it's limited to 2
or 3 tables, and I do separate joins combined with a UNION.
If you can combine your queries with a union, your table layouts must be
very similar if not identical.
Why not put everything into the same tab
On Wed, 2003-07-23 at 16:55, Steve Crawford wrote:
> I'm searching for projects that would serve as good PostgreSQL examples. In
> fact it would be nice to have a place on the PostgreSQL web page that
> featured some good examples. (If such a place exists and I missed it, please
> let me know.)
On Tuesday 29 July 2003 16:58, Francisco Reyes wrote:
> How does line completion gets to psql?
> At my FreeBSD machines when I build the PostgreSQL port I have always had
> line completion. Now I need to do some work on a Linux SUSE machine (which
> I don't administer) and psql doesn't have line co
On Tuesday 29 July 2003 17:58, Francisco Reyes wrote:
> How does line completion gets to psql?
> At my FreeBSD machines when I build the PostgreSQL port I have always had
> line completion. Now I need to do some work on a Linux SUSE machine (which
> I don't administer) and psql doesn't have line co
Hi...
SELECT sum(relpages)* (PAGESIZE) FROM pg_class
WHERE relkind='r' AND relname = 'table'
I want to know how many disk space is a database table using something
like above
where (PAGESIZE) is the postgresql page size value.
how can I get the ??? value...
- I now default value for (PAGESIZE) i
Hello,
I am planning to implement a system, where there is one Master database running on a
Linux box with as many resources as necessary, and there are one or more client pc
computers,with processor speed of 100 Mhz, memory of 32-64 Mbytes and a 10Mb/s network
card.
The major task is that
NOTE - after writing all this, I did think of a possible solution, but I'm
not sure if PG can handle it. If I made a table called "object" with one
column, the object_id, and then had EVERY table inherit from this table.
Then, I could have my constraints set up against this master table. (I'm
not
Jonathan Bartlett wrote:
NOTE - after writing all this, I did think of a possible solution, but I'm
not sure if PG can handle it. If I made a table called "object" with one
column, the object_id, and then had EVERY table inherit from this table.
Then, I could have my constraints set up against th
On 29/07/2003 18:04 [EMAIL PROTECTED] wrote:
Hello,
I am planning to implement a system, where there is one Master database
running on a Linux box with as many resources as necessary, and there are
one or more client pc computers,with processor speed of 100 Mhz, memory
of 32-64 Mbytes and a 10Mb
> Your programmers must be really smart :-)
> Are you saying that you have never seen a person writing a piece of sql
> like:
> insert into mytable (id, data) select max(id) + 1 from mytable, 'mydata'
> ???
>
> If so, you must be really lucky :-)
>
I would never hire such a person.
> Exactly. But
> Not *one* table. I never advocated that. It is perfectly normal to split
> your data into different tables *vertically* (i.e. things that do not
> have any intersection between their data, should go into different
> tables), but it very rarely (if at all) makes any sense to split it
> *horizontal
23 matches
Mail list logo
