Lada 'Ray' Lostak wrote:
You can add an attribute "work-in-progress" to your tables. Then
set up views that filter out rows with work-in-progress=true.
Your production client then needs to be modified to look at
those views instead of the tables.
I also though about this, but what about performance
- Original Message -
From:
Patrick
Hatcher
To: [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 12:34
AM
Subject: [GENERAL] Pg_dumpall
problem
Did a pg_dumpall from my production database (7.3.2) and I tried to
restoreto my Dev database (7.4). I
On Thu, 20 Nov 2003, Alex wrote:
> >>Is there an easy way to write a select statement that returns me the
> >>frist free number or any within the range of 200?
> >>For example if 1-30, and 32-50 are occupied then i would like to fill in
> >>the new entry with id 31.
If you had a table with an id
Le Mercredi 19 Novembre 2003 06:10, Deibys Fernando Quintero a écrit :
> it is the best solution for japanese characters ?
You can use a Unicode database and pgAdmin3 client
which supports UTF-8 Unicode:
http://www.pgadmin.org
Best regards,
Jean-Michel
---(end of broadc
Hi there,
I want to use the RIPE whois server that uses MySQL by default. However
I'd prefer a PostgreSQL solution. :-)
Does anybody know if there exists a patch to support PostgreSQL?
Thanks,
Joachim
---(end of broadcast)---
TIP 2: you can get
The file was there, but maybe some blocks where missed (it's a fat32 fs).
Finally I reinstalled the database and the problem got solved, but now I know what to do for the next time
Thanks Martijn.
On Wed, 2003-11-19 at 21:31, Martijn van Oosterhout wrote:
On Wed, Nov 19, 2003 at 01:45:21PM
you need to install contrib/dbsize. Then you can do:
SELECT relation_size('myTable');
On Thu, 2003-11-20 at 02:30, K. Deepa wrote:
Hi All,
Is it possible find the size of a pgsql table.
TIA
signature.asc
Description: This is a digitally signed message part
don't worry!! it's just a cygwin installation for a demostration application for the sales team. Real application runs on bsd
On Thu, 2003-11-20 at 11:23, Alvaro Herrera Munoz wrote:
On Thu, Nov 20, 2003 at 10:48:08AM -0300, Franco Bruno Borghesi wrote:
> The file was there, but maybe some b
On Thu, Nov 20, 2003 at 10:48:08AM -0300, Franco Bruno Borghesi wrote:
> The file was there, but maybe some blocks where missed (it's a fat32
> fs).
> Finally I reinstalled the database and the problem got solved, but now I
> know what to do for the next time :P
Doh ... Don't run your database in
On Thu, 20 Nov 2003 16:52:37 +0900, Alex <[EMAIL PROTECTED]> wrote:
Is there an easy way to write a select statement that returns me the
frist free number or any within the range of 200?
For example if 1-30, and 32-50 are occupied then i would like to fill in
the new entry with id 3
Andrei Ivanov <[EMAIL PROTECTED]> writes:
> it seems my postgresql data has somehow become corrupted (by a forced
> shutdown I think):
> psql template1 -U shadow
> Password:
> ERROR: nodeRead: did not find '}' at end of plan node
and
> pg_dump: SQL command failed
> pg_dump: Error message from
Hallo,
I tried to compile PGSQL 7.4 and I got error (durring make):
ar: command not found
What is it? Whe I can found it?
I have:
$ uname -a
SunOS ... 5.8 Generic_108528-03 sun4u sparc SUNW,UltraSPARC-IIi-cEngine
$ make --version
GNU Make 3.80
etc.
---
Hello All,
How to test the "Multiuser testing" in
PostgreSQL?. I used the apache bench "ab" tool for this one.
The following command execute the "test.php" 50
times concurrently.
$ ab -c 1 -n 50 http://127.0.0.1/test.php
The test.php file contains the following
conten
Hi,
In 7.4, I noticed there is this ::1 and : (x8 of them)
for IPv6.
I looked at the documentation and there is nothing that says
what the ::1 is for.
Commenting out that line will prevent access to PostgreSQL
from psql unless I put trust for that line.
This is what I had in 7.3.4:
hostall
"ar" is a tool used to create and
maintain portable archives and libraries. PostgreSQL uses this
command to create static libraries.
Just do the following command.
# whereis ar
ar: /usr/bin/ar
#
Regs,
Durai.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
It would be helpful to both communities if there was a factual
feature-by-feature grid comparing the relative capabilities of Postgresql
7.4 and MySQL 4.x. It would probably be best to limit it to objective
measures such as "Supports sub-selects in UPDATE queries". Even features
that are supported
Is there an equivalent function for bytea columns that works like
lo_import?
Alternatively, is there a way to copy from a large object to a bytea
column from SQL?
Or maybe someone has another way of attacking this problem:
I've got some Perl code that does this:
undef $/;
$data = ;
$sth = $dbh-
hmm
thanks. I do not have in standard path, but I have it.
Do I need it for database running and must I add it into standard PATH or it is
needed only for compilation?
Jiri
Cituji z emailu od Durai <[EMAIL PROTECTED]>:
>
> "ar" is a tool used to create and maintain portable archives and librar
Kris Jurka wrote:
A useful generic function would be one something like range(min,max) that
would return a set of rows so you wouldn't have to actually have a table.
You mean like this?
CREATE OR REPLACE FUNCTION test(int,int) RETURNS SETOF int AS '
BEGIN
FOR i IN $1..$2 LOOP
RETURN NEXT i;
It is need on compilation time. If you linked the static library on
compilation to the postgresql binaries, you do not need when you running the
database.
To link the static library, Edit src/Makefile.global file, there will be a
entry like "-lpq".
Change this to like
"/postgresql-7.4/src/interfa
Thank you
Jiri
Cituji z emailu od Durai <[EMAIL PROTECTED]>:
>
> It is need on compilation time. If you linked the static library on
> compilation to the postgresql binaries, you do not need when you running the
> database.
>
> To link the static library, Edit src/Makefile.global file, there wi
Seum-Lim Gan wrote:
> Hi,
>
> In 7.4, I noticed there is this ::1 and : (x8 of them)
> for IPv6.
>
> I looked at the documentation and there is nothing that says
> what the ::1 is for.
The ::1 is a IPv6 shorthand for 127.0.0.1 (localhost).
> Commenting out that line will prevent access to P
Hi Bruce,
Thanks for the info.
I captured the netstat output below.
Looks like there is a bunch of IPv4 being used.
Any idea how this can be resolved ?
Thanks.
Gan
UDP: IPv6
Local Address Remote Address
State If
- --
Well,
now I tried to compile with tsearch2.
I do in src direcotry:
./configure
then change into contrib/tsearch2 and do
make (as I read in manual)
and I got:
$ make
make: Fatal error in reader: ../../src/Makefile.global, line 23: Illegal
dependencies for target `.SILENT'
Where is my mistake? wh
[EMAIL PROTECTED] wrote:
Well,
now I tried to compile with tsearch2.
I do in src direcotry:
./configure
do make
then change into contrib/tsearch2 and do
make (as I read in manual)
and I got:
$ make
make: Fatal error in reader: ../../src/Makefile.global, line 23: Illegal
dependencies for target
I think what happens is that when we listen on IPv4 and IPv6, that all
connections get IPv6. What OS are you using?
---
Seum-Lim Gan wrote:
> Hi Bruce,
>
> Thanks for the info.
> I captured the netstat output below.
>
> L
Hi Bruce,
We are using Sun Solaris 9 on Sparc. uname -a :
SunOS test01 5.9 Generic_112233-04 sun4u sparc SUNW,Ultra-80
Gan
At 12:29 pm -0500 2003/11/20, Bruce Momjian wrote:
I think what happens is that when we listen on IPv4 and IPv6, that all
connections get IPv6. What OS are you using?
27 matches
Mail list logo
