Dear twosk
I heard from somone that i could use PostgreSQL, but I cannot find any information
that confirms or denies it.
AFAIK There was a discussion on the same topic in Dec2003 please search
the list and you will geta solution
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Her
I have a very similar problem. I put the following SQL into a
function:
SELECT VS.*,VL.TEL1,SC.CONTRACT_ID,SC.CONTRACT_REF, SC.MAX_HOURS,
SC.MIN_HOURS,
(SELECT COUNT(*) FROM TIMESHEET_DETAIL
JOIN MAIN_ORDER ON (MAIN_ORDER.ORDER_ID = TIMESHEET_DETAIL.ORDER_ID
AND MAIN_ORDER.CLIENT_ID = $3)
WHERE
[EMAIL PROTECTED] ("twosk") writes:
> I have a question, because i cannot find any information in online docs
> (maybe i'm just blind :P).
> I'm want to build application with embedded database, but i also need a
> possibility to have one global database, which can be accessed from internet
> (abil
Henrik Farre <[EMAIL PROTECTED]> writes:
> I just been choosen as sys adm on a small network. We have a old Sun Ultra
> 1 running postgresql 7.1.3. I would like to migrate the database to a new
> machine and a newer version of postgresql. But when I run the pg_dumpall
> command I get the followerin
SCO is acting on advice from attorneys as well.
My last post.;^)
>>> Richard Welty <[EMAIL PROTECTED]> 02/17/04 05:38PM >>>
On Wed, 18 Feb 2004 00:30:58 - Greg Sabino Mullane <[EMAIL PROTECTED]> wrote:
attribution of my quote of Theo de Raadt got stripped some how:
> >"Free means free"
>
[EMAIL PROTECTED] (jack turer) writes:
> I have a database in pgsql (7.3.2) on redhat 9.
> When I try a 'pg_dump mydb' to back up the database, I get:
> -bash-2.05b$ pg_dump -v mydb | more
> pg_dump: saving database definition
> pg_dump: reading namespaces
> pg_dump: reading user-defined types
> p
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Tue, Feb 17, 2004 at 03:39:25PM -0700, Linh Luong wrote:
>> 1. I have been reading and the max size of a tuple is 8K.
> That hasn't been true for ages. Use a newer PostgreSQL; any modern
> one will have the TOAST capability and won't have this lim
Tom Lane wrote:
Bill Moran <[EMAIL PROTECTED]> writes:
Some of the plpgsql functions I've created work fine on 7.4, but
fail on 7.3.4. Specifically, when I use a "FOR var IN select LOOP"
loop with a LONG select statement, it works fine on 7.4, but
bonks with "missing .. at end of SQL expression"
On Tue, 17 Feb 2004, Linh Luong wrote:
> Hi All,
>
> 1. I have been reading and the max size of a tuple is 8K.
> I have also read that I can it to a larger size in some config file. Where is
> this file? is it called pg_config.h and is the variable called BLKSZ??
You'd have to set the way bac
On Wed, Feb 18, 2004 at 11:58:24AM -0500, Randall Skelton wrote:
> Greetings all,
>
> I am trying to do what should be a simple join but the tables are very
> large and it is taking a long, long time. I have the feeling that I
> have stuffed up something in the syntax.
>
> Here is what I have:
On Tue, Feb 17, 2004 at 11:15:13AM -0800, Ashish Mahabal wrote:
>
> Thanx Mark.
>
> Thats what I ended up doing. But it seems silly that the name space for
> system columns and user columns are not separate. Its just like saying
> that you can not have the same column name in 2 different tables.
On Fri, Feb 20, 2004 at 09:56:03PM +0200, Antonios Christofides wrote:
> Tom Lane wrote:
> > Feel free to send in a docs patch ...
>
> I'll do that. I took a look at the PgSQL developer pages to see how it's
> co-ordinated and the FAQ tells me to read HACKERS for six months :-) I
> don't want to d
On Tue, 17 Feb 2004, Chris Browne wrote:
> [EMAIL PROTECTED] (Jan Wieck) writes:
> >>> P.S. For example MySQL Databse have the commercial license for that.
> >
> > P.P.S. BSE is Bovine Spongiform Encephalopathy, also known as Mad Cow
> > Disease. Even if MySQL has a few features that might be desc
On Thu, Feb 19, 2004 at 20:39:13 +0300,
anwar <[EMAIL PROTECTED]> wrote:
> How can i get a list of database in postgresql
psql -l
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
anwar schrieb:
How can i get a list of database in postgresql
anwar
psql -l
for details see: http://www.postgresql.org/docs/7.4/static/app-psql.html
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Thank you all for replying. I appreciate the tips. Apologies to those who
were offended by the html formating.
Scott, quick question. The reason I assumed insert would be "safer" than
copy is because the docs say that in the case of copy it fails on a single
corrupted row whereas insert won't?
S
I just been choosen as sys adm on a small network. We have a old Sun Ultra
1 running postgresql 7.1.3. I would like to migrate the database to a new
machine and a newer version of postgresql. But when I run the pg_dumpall
command I get the followering error, after a while:
WARNING: owner of type '
Greetings all,
I am trying to do what should be a simple join but the tables are very
large and it is taking a long, long time. I have the feeling that I
have stuffed up something in the syntax.
Here is what I have:
telemetry=> select (tq1.timestamp = tq2.timestamp) as timestamp,
tq1.value a
On Fri, 20 Feb 2004, Sally Sally wrote:
> Thank you all for replying. I appreciate the tips. Apologies to those who
> were offended by the html formating.
> Scott, quick question. The reason I assumed insert would be "safer" than
> copy is because the docs say that in the case of copy it fails o
On Fri, 20 Feb 2004, twosk wrote:
> Hi,
>
> I have a question, because i cannot find any information in online docs
> (maybe i'm just blind :P).
> I'm want to build application with embedded database, but i also need a
> possibility to have one global database, which can be accessed from internet
On Wed, Feb 18, 2004 at 08:58:28PM -, Simon Windsor wrote:
> for MASTER-MASTER
None. Postgres-R is intended to offer it, but it requires work
still.
> and MASTER-SLAVE(Multiple) replication.
All the rest, except for contrib/rserv, which does only one slave. I
have used the erserver on
On Tue, Feb 17, 2004 at 03:39:25PM -0700, Linh Luong wrote:
> Hi All,
>
> 1. I have been reading and the max size of a tuple is 8K.
That hasn't been true for ages. Use a newer PostgreSQL; any modern
one will have the TOAST capability and won't have this limitation.
A
--
Andrew Sullivan
--
[EMAIL PROTECTED] (pativo) wrote in message news:<[EMAIL PROTECTED]>...
Hello and thanks to all!
I'm amused that I get so many responses.
Ok, at time I use a plpgsql function (isAHex(VARCHAR)) which checks only
if the length is even.
So I think I should implement the following.
===8<-
Hi All,
1. I have been reading and the max size of a tuple is 8K.
I have also read that I can it to a larger size in some config file. Where is
this file? is it called pg_config.h and is the variable called BLKSZ??
2. Is there a way I can find the actual size of the tuple? Do you go into each
I've got a bit of a strange problem that's causing me some MAJOR
headaches.
I'm developing the server-side of a large database application in
PostgreSQL. This consists of a C daemon, and a LOT of stored
functions in the database.
I'm developing this in conjunction with another company, who is
deve
Thanx Mark.
Thats what I ended up doing. But it seems silly that the name space for
system columns and user columns are not separate. Its just like saying
that you can not have the same column name in 2 different tables.
Just like I can say table1.myCol and table2.myCol, there should have been
a
I have a database in pgsql (7.3.2) on redhat 9.
When I try a 'pg_dump mydb' to back up the database, I get:
pg_dump: could not find namespace with OID 2200
Verbose version is:
-bash-2.05b$ pg_dump -v mydb | more
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user
Hi
I am fairly news to Postgres, but have spent many years
using Oracle (15) and MySQL(5).
Whilst I find Postgres very easy to ‘pickup’, the
number of replication options are puzzling.
There are a number of replication options available to
Postgres. Can anyone on this list advis
Hi,
I have a question, because i cannot find any information in online docs
(maybe i'm just blind :P).
I'm want to build application with embedded database, but i also need a
possibility to have one global database, which can be accessed from internet
(ability to synchronize between remote and loc
How can i get a list of database in postgresql
anwar
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the
30 matches
Mail list logo
