> 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
> 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
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
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
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
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
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
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
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 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.)
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
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
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
> 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
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
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
[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 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
> > >
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
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
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
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
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
23 matches
Mail list logo
