> e.g.
> pg_shadow_usename_index
> pg_stat_activity
> pg_stat_database
>
They are system views and correspond to no file.
See PostgreSQL's documents.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Hi,
It seems that there is a problem when executing a dynamic commands
containing a transaction...
Here's a simple example...
CREATE OR REPLACE FUNCTION fct_trig2()
RETURNS TRIGGER AS '
BEGIN
EXECUTE ''BEGIN;''
|| ''CREATE TABLE t2_'' || NEW.id::TEXT || ''(''
|| '' CONSTRAINT pkt2_'' |
What is the best replication option out there today for postgresql.
Have been trying to get rserv working and that hasn't been the
easiest.
Would like to run 7.4.1.
Any suggestions?
-Steve
---(end of broadcast)---
TIP 3: if posting/reading throug
I'm having some odd issues, but I'm not sure exactly the cause of them,
but postgres is the component in the system that is throwing the errors,
so I thought I'd start here.
I have built a web application that uses postgres (7.3.2) as its
backend, with the front being an Apache2/mod_perl soluti
On Sat, Feb 14, 2004 at 04:35:58PM -0500, Michael L. Artz wrote:
> I'm having some odd issues, but I'm not sure exactly the cause of them,
> but postgres is the component in the system that is throwing the errors,
> so I thought I'd start here.
> with the corresponding postgresql.log entry bein
On Tue, 10 Feb 2004, mike wrote:
> I have setup a database that I am the owner of, and I am trying to setup
> constraints and it doesn't seem to be working
>
> Example
>
> - Table: public."Invoice_Header"
>
> -- DROP TABLE public."Invoice_Header";
>
> CREATE TABLE public."Invoice_Header"
> (
>
Nope. PostgreSQL is BSD licensed.
On Feb 10, 2004, at 11:40 AM, Artemy wrote:
What about the PostgreSQL License. If I use the database for the
commercial purpose, Do
I have to purchase the license?.
P.S. For example MySQL Databse have the commercial license for that.
Best Regards
Artjom Smekal
PostgreSQL has BSD license. Tha means do what do you want :)
Oleg
On Tue, 10 Feb 2004, Artemy wrote:
> What about the PostgreSQL License. If I use the database for the commercial purpose,
> Do
> I have to purchase the license?.
>
> P.S. For example MySQL Databse have the commercial licen
"Michael L. Artz" <[EMAIL PROTECTED]> writes:
> Anway, DBD::Pg throws random errors into my logs, along the lines of
> what is below (the lines beginning with SQL are debug statements from
> the script, and are the lines references by the DBD error.
> LOG: statement: SELECT session
On Saturday 14 February 2004 22:35, Michael L. Artz wrote:
(...)
> If anyone has seen anything like this before (i.e. random errors in a
> similar apache/mod_perl) situation, or might have any pointers as to
> where to look next, let me know. What would cause postgres to return an
> error for a se
I had this same problem not long ago, and it caused me go with PostgreSQL over MySQL on a project. The problem you're describing does not exist in PostgreSQL. Creating a new index on a table does not require recreating the other indexes. MySQL also has the same problem if you add or drop columns
On 15. feb 2004, at 18:18, Tom Lane wrote:
A workaround you could think about is invoking the LO functions via
ordinary SELECT commands, ignoring libpq's LO API altogether. This
would have been rather painful in pre-7.4 releases since you'd have
to be willing to deal with quoting and dequoting "by
Chris Fossenier wrote:
I currently have a client with a database that must hold 125 million records
and all tallied about 250 fields.
The database has been normalized and indexed appropriately.
If any of you have worked with MySQL, you will have discovered that indexing
is very limited. You ca
I'm trying to make myself a dictionary for tsearch2 that converts
numbers to their english word equivalents. This seems to be working
great, except that I can't figure out how to make my lexize function
return multiple lexemes. For instance, I'd like "100" to get converted
to {one,hundred}, not {"o
Okay, so I was actually able to answer this question on my own, in a
manner of speaking. It seems the way to do this is to merely return a
larger char** array, with one element for each word. But I was having
trouble with postgres crashing, because (I think) it tries to free each
element independen
15 matches
Mail list logo
