Duane Lee - EGOVX <[EMAIL PROTECTED]> writes:
> I'm trying to insert data into an empty table but I keep getting the error:
> ERROR: could not open relation with OID 42939
More detail please? For starters, what PG version is this?
> I have a couple of constraints on the table but what I'm ente
On Fri, Feb 27, 2004 at 01:45:07PM -0500, Joe Maldonado wrote:
> Hello all!
>
> when asking postgres to aggregate totals accross 4.5 or so Million
> records. The visible effect is that the postmaster will grow to the
> 3GB process limit and die without a core :(.
> I have seen
Interesting article, notice the "never have to reboot it" line.
http://www.smh.com.au/articles/2004/06/07/1086460218113.html?oneclick=true
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Wed, Feb 25, 2004 at 04:11:37AM +, Humble Geek wrote:
> Assume XXX is the id from the first insert. How do I get that number? Not
> currval('someSeq') - 'cause someone else may have performed an insert - but
> the id for that specific insert.
Read the documentation carefully, currval() doe
It's OK, I'm an idiot.
I read s many times that you need to get the data types in the query the same as
the column
types or indexes won't work. So I go and get it wrong!
I had defined the parameter to the function as timestamp (equivalent to SQLServer
datetime), but the
column data type is
Both oracle and MS-SQL server have a variant datatype which
allows the insertion of any data type except BLOBs. A short integer is
concatenated onto the front of the piece of data being inserted into the
variant (SQL Server) or anytype(Oracle) which defines the type of data in the
field.
On Saturday 28 February 2004 08:36, Rajat Katyal wrote:
> Ya, through application we can provide field input validation but iam
> working on the tool which transfers the data from some specifed database to
> another. Here user itself wants if value is too long for the target column
> then truncates
http://archives.postgresql.org/pgsql-general/2003-11/msg00581.php
In the above Jan Wieck mentions a bug that occurs in pg 7.3.4 that
causes a crashing backend to hang around in the stats until the slot is
reused, due to the message that tells that the backend terminates is
never sent to the collec
Title: Help in finding the error
I'm trying to insert data into an empty table but I keep getting the error:
ERROR: could not open relation with OID 42939
I have a couple of constraints on the table but what I'm entering doesn't violate those. Can someone tell me where in the system catal
Sezai YILMAZ <[EMAIL PROTECTED]> writes:
> I changed the three hash indexes to btree.
> The performance is increased about 2 times (in PostgreSQL 7.3.4 1905
> rows/s).
> Concurrent inserts now work.
Concurrent inserts should work with hash indexes in 7.4, though not 7.3.
The slowdown you report
No you cannot.
But look at this for a pointer:
select 'hi' || (select substring('hello1234567890' from '[0-9]+$'))
where 'hello1234567890' ~* '[a-z]+([0-9+])';
CSN wrote:
Can you use backreferences in regular expressions like
so?
update table set title='foobar ' || \1 where title ~*
'[a-z]+([0-9]+)
Is there a way to segregate users by database or schema so that in a hosting
situation you could keep different customers apart? Otherwise, the
unpleasant alternative is to run separate instances of Postgres.
---(end of broadcast)---
TIP 4: Don't 'k
David Garamond wrote:
Peter Eisentraut wrote:
1) If we just ship the PostgreSQL binaries in our product(without
source code), do we need to include the BSD licence text anywhere?
Yes. The license says "... provided that the above copyright notice
and this paragraph and the following two paragraph
On Tue, Jun 08, 2004 at 05:51:22PM -0400, Michelle Murrain wrote:
> I'd like to make 'courseid' in this second table a foreign key,
> referencing 'courseid' in the first table. So I did this command:
>
> charter_dev2=# ALTER TABLE coursesevaluations ADD CONSTRAINT rc_ce
> FOREIGN KEY (courseid)
Hello
I need high throughput while inserting into PostgreSQL. Because of that I
did some PostgreSQL insert performance tests.
-- Test schema
create table logs (
logid serial primary key,
ctime integer not null,
stime int
Can you use backreferences in regular expressions like
so?
update table set title='foobar ' || \1 where title ~*
'[a-z]+([0-9]+)';
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
---
"Campano, Troy" <[EMAIL PROTECTED]> wrote:
>
> Hello,
> I'm trying to set up PostgreSQL for proof of concept according to our
> standards.
> I need to create a user for database01 that has the ability to create
> any objects they want.
> They can create tables, views, indexes, etc.
>
> Then I n
"Scot L. Harris" <[EMAIL PROTECTED]> wrote:
>
[snip]
>
> Yes I have tried it without quoting the PGDATA2. Same result.
>
> I have also tried the full path but the flag is apparently not set to
> allow that.
>
> Besides the error I am getting it appears to me that postmaster would
> not be able
Shridhar Daithankar wrote:
Karam Chand wrote:
I searched the sitebut i couldnt find a
link...where can I get compiled libraries for libpq
and its coreresponding header files for Windows.
HTH
Shridhar
Try at the OLE DB project.
http://gborg.postgresql.org/project/oledb/projdisplay.php. That w
Title: Prevent users from creating tables
Hello,
I’m trying to set up PostgreSQL for proof of concept according to our standards.
I need to create a user for database01 that has the ability to create any objects they want.
They can create tables, views, indexes, etc.
Then I need a second
On Tue, 2004-06-08 at 14:34, Richard Huxton wrote:
>
> 1. Have you tried not quoting PGDATA2 (I seem to remember it being picky
> about such things).
>
> 2. Are you aware you can use a full path (/vhost/database/data) instead
> of PGDATA2? This requires setting a compile-time flag though.
Tha
Scot L. Harris wrote:
I am running postgresql 7.2.4 on a Redhat 8.0 system.
I have been looking for a way to setup another database besides the
initial one setup under /var/lib/pgsql/data on a different file system.
I have found a few references to configuring a separate PGDATA2
environment variabl
I am running postgresql 7.2.4 on a Redhat 8.0 system.
I have been looking for a way to setup another database besides the
initial one setup under /var/lib/pgsql/data on a different file system.
I have found a few references to configuring a separate PGDATA2
environment variable and running the in
Well I am working to address the problem, sorry if I am not doing it
fast enough. I spoke with the gborg maintainer and found out that the
top 5 is based on page views for a project rather than cvs activity.
While I've no doubt you've been more active on slony development, I am
not so sure that pg
Sorry...
the function is pg_get_indexdef and i found the docs
for it.
Thanks .
Karam
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Karam Chand <[EMAIL PROTECTED]> writes:
> > How do I display the field(s) used to create an
> index,
>
> The pg_get_index_def function is the easiest way.
>
>
On 6/8/2004 11:49 AM, Robert Treat wrote:
Well I am working to address the problem, sorry if I am not doing it
fast enough. I spoke with the gborg maintainer and found out that the
top 5 is based on page views for a project rather than cvs activity.
Aha ... and let me guess, the algorithm does NOT
I guess I have to address a slightly broader audience, or do I conclude
from the total lack of interest in this matter that nobody cares if we
promote something here as one of our "top five" flagship projects, that
is inactive for years and still a prototype implementation against
PostgreSQL 6.
27 matches
Mail list logo
