On Fri, 26 Nov 2004 22:35:45 -0600 [EMAIL PROTECTED] wrote:
> 1. is this architecture (relying heavily on dynamically created tables) sound
> enough to yield a production quality database?
i've seen this method used in _extremely large_ production databases, such
as the ones at my current contract
I am new to the databasing market, and am currently working on a complex
database that relies heavily on dynamically created tables for data storage. My
partner and I have therefore been trying to find a front end utility that can
handle using tables with names that aren't known at compile time.
On Fri, 26 Nov 2004, Tom Lane wrote:
> > My understanding was that row-level lock at UPDATE statement is somehow
> > atomic and it locks all rows matched at once.
>
> Nope.
>
> > But what's the solution? How can I force UPDATEs to lock rows in the same
> > order? There's no ORDER BY clause for UPD
Kamil Kaczkowski <[EMAIL PROTECTED]> writes:
>> Another possible explanation is if the UPDATE
>> command can update more than one row --- in that case different backends
>> might happen to reach the target rows in different orders.
> Yes, this UPDATE changes several rows, I didn't know this can be
On Friday 26 November 2004 03:11 pm, Tom Lane wrote:
> Adrian Klaver <[EMAIL PROTECTED]> writes:
> > Sorry should have been more explicit. The dump loaded functions depending
> > on plsh before the function that created the language. In fact it did not
> > instalI the language at all.
>
> Ah. Look
On Fri, 26 Nov 2004, Tom Lane wrote:
> Kamil Kaczkowski <[EMAIL PROTECTED]> writes:
> > I have problems with deadlocks caused by(at least I think so) row-level
> > locks and I can't find the reason.
>
> The failure seems clearly a deadlock on row-level locks. Are you
> certain you've removed all
Kamil Kaczkowski <[EMAIL PROTECTED]> writes:
> I have problems with deadlocks caused by(at least I think so) row-level
> locks and I can't find the reason.
The failure seems clearly a deadlock on row-level locks. Are you
certain you've removed all relevant FKs (those pointing to the table
as well
Jonathan Daugherty <[EMAIL PROTECTED]> writes:
> The problem is that I don't want to spend a lot of time and memory
> building such a query (in C). I would like to know if there is a way to
> take this huge chunk of data and get it into the database in a less
> memory-intensive way. I suppose
Kenneth Tanzer <[EMAIL PROTECTED]> writes:
> But what about these two queries:
> SELECT substring('a' FROM 'a?|a?');
> This returns a greedy 'a', similar to the example above. But then why does
> SELECT substring('ba' FROM 'a?|a?');
> return a non-greedy empty string?
You're ignoring the
Adrian Klaver <[EMAIL PROTECTED]> writes:
> Sorry should have been more explicit. The dump loaded functions depending on
> plsh before the function that created the language. In fact it did not
> instalI the language at all.
Ah. Looking back at your first message, I see you'd installed plsh int
Aguien puede ayudarme a obtener el resultado del
llamado dinamico de una funcion?.
Este es el caso, Resulta que tengo tres funciones
F1(), F2(), F3() y quiero ejecutar dinamicamente una
de ellas.
Inicialmente construi una sentencia Update a una Tabla
y luego recuperaba el valor de la tabla asi:
Place, erase of the group;
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
---(end of broadcast)---
TIP 5: Ha
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Glen Eustace)
wrote:
> I am trying to setup slony-1 and need some off list assistance from
> someone who has got things going ( or at least knows more than me :-).
>
> I am running 7.4.6 on both master and slave but when I run the slon
OK. I've been trying to get my mind around this, and think about ways
to improve the documentation (more about that below). I'm pretty sure
that I can see the general concept now, and am almost convinced that it
really does work as described. I guess I really don't like the whole RE
inheriti
Hello,
I have a PL/PgSQL function that I need to call with some ARRAY
parameters. These array values are very large -- typically thousands of
elements. Each element is a 4-element array. This function is called
to do some sanity checking on the array data and use the individual
elements to d
I am having some trouble pulling some data out from the database. I have
tried against both 7.4.5, 8.0b4 and 8.0b5 and get the same result.
I have used both the v308 and CVS HEAD of the JDBC driver.
When I SELECT from a certain table, I see this JDBC exception:
"Invalid character data was found.
On Friday 26 November 2004 10:26 am, Tom Lane wrote:
> Adrian Klaver <[EMAIL PROTECTED]> writes:
> > I used the pg_dump from Postgres 8.0beta5 to dump the data from a version
> > 7.4.0 database. Both databases are located on SuSE Linux machines. The
> > pg_restore to the 8.0 version went very well
on 11/26/04 8:16 AM, [EMAIL PROTECTED] purportedly said:
>> As for PHP, you need to have the browser and PHP agree on what
>> character set they're going to use. Then you set the client encoding
>> appropriately and PostgreSQL will make sure you get the information you
>> expect.
>
> Im not sure,
I am trying to setup slony-1 and need some off list assistance from
someone who has got things going ( or at least knows more than me :-).
I am running 7.4.6 on both master and slave but when I run the slonik
script, I get the error.
:5: Initializing the cluster
:7: PGRES_FATAL_ERROR create schem
diya das <[EMAIL PROTECTED]> writes:
> My pgsql function
> does an insert to a table and I have opened a
> transaction block before calling my function from the
> client. When the insert operation fails due to unique
> key violation the whole transaction aborts. Is there a
> way I can handle this e
Nevermind, I just upgraded to 7.4 and everything is just fine now
thanx anyway
El Vie 26 Nov 2004 12:24, j0rd1 adame escribió:
> Hi,
>
> When I add a FK to a table and then try to do \d table
> i get this
>
> ERROR: Function pg_catalog.pg_get_triggerdef(oid) does not exist
> Unable to id
Nikola Milutinovic <[EMAIL PROTECTED]> writes:
> - PostgreSQL 7.3.2 MDK5
> ...
> A couple of days ago, disk became full, since we were not doing VACUUM
> on the DB at all. So, I deleted all records from the 3 tables the DB has
> and performed "VACUUM FULL ANALYZE". This reclaimed the space.
The
Adrian Klaver <[EMAIL PROTECTED]> writes:
> I used the pg_dump from Postgres 8.0beta5 to dump the data from a version
> 7.4.0 database. Both databases are located on SuSE Linux machines. The
> pg_restore to the 8.0 version went very well with the exception of the
> languages. I have plpgsql and
Hi,
When I add a FK to a table and then try to do \d table
i get this
ERROR: Function pg_catalog.pg_get_triggerdef(oid) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
i have googled for this without any
Hello!
Every one.
I met some difficult questions when I was developing an application.
We have an old table object whose definition is:
CREATE TABLE object (
name name, -- object’s name
pid oid, -- parent’s object ID
Hi,
I am just a beginner in postgreSQL and writing some
functions in PL/pgSQL. I use the libpq interface in
the client to call this funtions. My pgsql function
does an insert to a table and I have opened a
transaction block before calling my function from the
client. When the insert operation f
On Fri, Nov 26, 2004 at 03:16:25PM +, Adam Witney wrote:
>
> Hi Martijn, thanks for your quick reply...
>
> > As for PHP, you need to have the browser and PHP agree on what
> > character set they're going to use. Then you set the client encoding
> > appropriately and PostgreSQL will make sure
Hi Martijn, thanks for your quick reply...
> As for PHP, you need to have the browser and PHP agree on what
> character set they're going to use. Then you set the client encoding
> appropriately and PostgreSQL will make sure you get the information you
> expect.
Im not sure, where do I set the c
On Fri, Nov 26, 2004 at 02:52:18PM +, Adam Witney wrote:
> Do I have to have created the database with UNICODE encoding to do this?
> Also, is there anything in the PHP I have to adjust to be able to store the
> data and display the data?
Obviously, your database needs to be able to store the
Hi,
I have a database fronted with PHP. I want the user to be able to put
scientific notation characters (greek letters really) and store them in the
database.
Do I have to have created the database with UNICODE encoding to do this?
Also, is there anything in the PHP I have to adjust to be able
On Fri, Nov 26, 2004 at 02:00:48PM +0100, Pierre-Frédéric Caillaud wrote:
>
> It seems this issue has been mentionned several times lately...
> I'd propose something to do to avoid it :
>
> * When TRUNCAT'ing a table :
> - the row-count is reset to 0 (of course !)
It seems this issue has been mentionned several times lately...
I'd propose something to do to avoid it :
* When TRUNCAT'ing a table :
- the row-count is reset to 0 (of course !)
- however, the column stats are kept, on the basis that the data which
will be inserted later in the
Ramesh Patel wrote:
Dear All
I have Redhat 9.0 and i use Postgresql and PHP .
This Database ranning last two year. now i have some speed problem.
Now i am new in Postgresql so How to Config a PostgreSQL.conf file.
my Hardver is
P IV server, 1 GB RAM , 72 GB SCGI HDD.
and I am use Web Applic
Dear AllI have Redhat 9.0 and i use Postgresql and PHP
.This Database ranning last two year. now i have some speed
problem.Now i am new in Postgresql so How to Config a
PostgreSQL.conf file.my Hardver is P IV server, 1 GB RAM ,
72 GB SCGI HDD. and I am use Web Application.if Possible
then g
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
> My suggestion is to VACUUM (FULL) the table after you've deleted the data.
> Then fill up the table and do a ANALYZE when you're done filling it.
For now you might be able to improve matters by doing an ANALYZE even while
it's busy doing the im
Hi Nix,
The problem is, that while doing the vacuum full ANALYZE the table was
empty. It therefore gathered statistics of a situation which isn't there
anymore when you fill up the table. In an empty or small table, it is
normal to do sequential scans. Which you most of the time don't want in
a
it did.. thanks.. generally a weeks process turned out to be less than a
day..
On Thursday 25 November 2004 15:06, Christopher Kings-Lynne wrote:
> > update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in
> > (select
> > mobile_num from LOADED_MOBILE_NUMBERS)
>
> Change t
From: "Nikola Milutinovic" <[EMAIL PROTECTED]>
> There is one DB and one DB user. The DB is cleared and loaded with the
> data of same volume each month (monthly report). The volume is not small
> and it usually takes 3 hours to load. Loading is done with SQL files
> which use transactions, 10
38 matches
Mail list logo
