On Thu, Nov 30, 2000 at 04:22:20PM +0300, Alex Bolenok wrote:
> peroon=# SELECT OVERLAPS('yesterday', 'today', 'today', 'tomorrow');
> ERROR: parser: parse error at or near "overlaps"
Try using it as an operator instead of a function:
test=# select ('yesterday'::timestamp, 'today'::timestamp)
Hans-Jürgen Schönig schrieb:
> ...
> I am writing a perl program that should insert data into a database. It
> works perfectly well when starting the script manually. When the
> starting the script as cron (same user), it collapses ($fehler = 32 512
> which I don't know and can't find).
>
> $fehl
On Thu, Nov 30, 2000 at 12:16:39PM -0800, Mikheev, Vadim wrote:
> Oracle & Interbase have savepoints. Hopefully PG will also have them in 7.2
A feature that I liked from using Faircom's Ctree (granted not an SQL based
DB or one with built in relations) was auto-save points. So, if something
fail
> Please forgive my ignorance (I haven't used Postgres for that long), but
> what are shm and sem?
shared memory and semaphores,interresting tidbit on Linux (2.4.0-test
series at least) is that shared memory can be a nodev filesystem (like proc or
devfs):
/dev/ide/host0/bus0/target0/lun0/part2 o
I know I bothered with this, but I just don't get it.
Lets say I have a test table like this in a certain database:
CREATE TABLE test (
id_test SERIAL,
blob_text oid
);
Now I want to insert a good chunk of text in the blob_text field with PHP.
PHP has some postgres functions like p
localhost[/usr/local/pgsql/data]# psql test dbuser
Password:
psql: The Data Base System is shutting down
localhost[/usr/local/pgsql/data]#
-
I am getting weird DB shutdowns. Anybody experience this before ? Any ideas
welcome. What could this
> I was wondering if you could tell me where to get the CVS version
of
> the ODBC driver -- I have almost implemented foreign key support
> (SQLForeignKeys), but I did it on the ODBC source available on the
> postgres server. I browsed the postgres CVS repository via the
web,
> but couldn't fin
> I'm running PostgreSQL 7.0.2 on Caldera eDesktop 2.4.
> when I try to use the SQL COPY command in psql, I get
> an error message informing me that the backend could
> not open the file for reading. I think the error
> number was 13 - Permission denied. I changed the
> permissions of the direc
On 1 Dec 2000, at 12:00, Ed Loehr wrote:
> How well is the recently-added PostgreSQL functionality supporting
> referential integrity (RI) working. Any serious bugs? Any major
> hinderances? Other impressions?
>
> I'd be particularly interested in hearing from people who've
> implemented larg
Larry Rosenman wrote:
> * Dave Smith <[EMAIL PROTECTED]> [001201 12:11]:
>
>> Ok so thanks to Larry I managed to get postgresql compiled and running
>> on SCO. Now I'm trying to compile a small 'C' program. When I link I get
>>
>> cc -L/usr/local/pgsql/lib -lpq -lm -o t_postgresql t_postgresql
* Dave Smith <[EMAIL PROTECTED]> [001201 13:05]:
> Larry Rosenman wrote:
>
> > * Dave Smith <[EMAIL PROTECTED]> [001201 12:11]:
> >
> >> Ok so thanks to Larry I managed to get postgresql compiled and running
> >> on SCO. Now I'm trying to compile a small 'C' program. When I link I get
> >>
> >
* Dave Smith <[EMAIL PROTECTED]> [001201 12:11]:
> Ok so thanks to Larry I managed to get postgresql compiled and running
> on SCO. Now I'm trying to compile a small 'C' program. When I link I get
>
> cc -L/usr/local/pgsql/lib -lpq -lm -o t_postgresql t_postgresql.o
> post_util.o
> undefined
I'd like to set up a database so that two users can create, alter,
drop, and grant on any table, regardless of which of the two users
initially created the table. Is this possible?
(The documentation has a blank spot under "Database Privileges".)
Zach
--
[EMAIL PROTECTED] Zachary Beane
* Dave Smith <[EMAIL PROTECTED]> [001201 10:18] wrote:
> Ok so thanks to Larry I managed to get postgresql compiled and running
> on SCO. Now I'm trying to compile a small 'C' program. When I link I get
>
> cc -L/usr/local/pgsql/lib -lpq -lm -o t_postgresql t_postgresql.o
> post_util.o
> undefi
Ok so thanks to Larry I managed to get postgresql compiled and running
on SCO. Now I'm trying to compile a small 'C' program. When I link I get
cc -L/usr/local/pgsql/lib -lpq -lm -o t_postgresql t_postgresql.o
post_util.o
undefined first referenced
symbol
> > What's nice about PostgreSQL is that, while it hasn't always had
> > every SQL92 feature (like outer joins, etc.), it seems to have less
> > legacy, nonstandard stuff wired in. :-)
>
> Oh man, you have n idea. PostgreSQL is legacy headquarters. ;-)
Yes, yes, I know about *some* of them
How well is the recently-added PostgreSQL functionality supporting
referential integrity (RI) working. Any serious bugs? Any major
hinderances? Other impressions?
I'd be particularly interested in hearing from people who've implemented
larger schemas using RI (say, more than 30 tables and 50 f
> > Than you can connect to any of the postgres on your cluster, for
> >example: > round robin.
> >
> >Hmm... But is this really what we want to do? This is less than ideal
for
> >several reasons (if I understand what you're saying correctly).
Replication
> >is off-line for a start, and it only wo
This worked for me:
update pg_attribute set atttypmod = 104 where attname = 'column_name' and
attrelid = (select oid from pg_class where relname = 'tablename');
to set a varchar column 'columnname' in 'tablename' to a size of 100.
Tamsin
> -Original Message-
> From: [EMAIL PROTECTED]
>From: "Gordan Bobic" To: Subject: Re: [GENERAL] Database cluster? Date:
>Fri, 1 Dec 2000 10:13:55 -
>
> > I've succesfully pacthed linux kernel 2.2.17 with DIPC and modified >
>postgresql's src (src/backend/storage/ipc/ipc.c) to create distributed >
>shm and sem.
>
>Please forgive my ig
Thanks - It's a fairly small table so I decided to create a new field and
update the table. My syntax was
UPDATE tablename SET new_column = old_column WHERE uid = uid;
However it says: Relation 'tablename' does not have attribute 'new_column'
If i do \d tablename, it shows the new column. Did I m
I don't know if you can use ALTER TABLE to do this
but you could rename the old column, add a new column with
the right name and size and use an UPDATE statement to
copy the data in.
Unfortunately I had problems dropping the old column since
ALTER TABLE xxx DROP COLUMN is not implemented i
On Friday 01 December 2000 10:23, [EMAIL PROTECTED] wrote:
> This seems like a simple enough thing, and I'm sure it's been answered,
> but I couldn't find anything that helped in the archives. Basically, I
> have a column in my table that was, once upon a time, large enough, but
> now, I need to i
Joel Burton writes:
> What's nice about PostgreSQL is that, while it hasn't always had
> every SQL92 feature (like outer joins, etc.), it seems to have less
> legacy, nonstandard stuff wired in. :-)
Oh man, you have n idea. PostgreSQL is legacy headquarters. ;-)
--
Peter Eisentraut
Andrew Gould <[EMAIL PROTECTED]> writes:
> I'm running PostgreSQL 7.0.2 on Caldera eDesktop 2.4.
> when I try to use the SQL COPY command in psql, I get
> an error message informing me that the backend could
> not open the file for reading. I think the error
> number was 13 - Permission denied.
This seems like a simple enough thing, and I'm sure it's been answered,
but I couldn't find anything that helped in the archives. Basically, I
have a column in my table that was, once upon a time, large enough, but
now, I need to increase the site of the column. How can I do that?
Thanks,
Joe
> "Frank" == Frank Joerdens <[EMAIL PROTECTED]> writes:
Frank> Which forum is that? I'm asking because I am currently
Frank> trying to migrate from PHP to Openacs, or integrate the two
Frank> somehow (lurking on this list has convinced me that openacs
Frank> deserves a hard lo
Have you looked at intermezzo? http://www.inter-mezzo.org/
Valter Mazzola wrote:
> I've succesfully pacthed linux kernel 2.2.17 with DIPC and modified
> postgresql's src (src/backend/storage/ipc/ipc.c) to create distributed
> shm and sem.
>
> The strategy is then to start a postgresql that cr
Hi,
...
> > > That is what transactions are for. If any errors occur, then the
> > > transacction is aborted. You are supposed to use transactions when you
want
> > > either everything to occur (the whole transaction), or nothing, if an
> > > error occurs.
And thats wrong!
The caller should hav
29 matches
Mail list logo
