In 7.4.3, if I rename a column which references another table,
constraint trigger fails on update or delete from main table.
There are a couple of similar (and about rename table itself) reports
for 7.0, 7.1 (as Tom Lane said, rename table is fixed in 7.2), but I
see no more reports since 2001.
H
Dear Mr
when i first used postgresql after it was installed ,it was ok.But when i
shut down it and then i couldn't used it again.The error message was that IpcMemoryCreate: shmget(key=5432001, size=1499136, 03600) failed: Function not i
mplemented.What should i do? The postgresql was insta
Platform used : Redhat Linux 7.2 kernel 2.4.20-28.7
Version Postgresql: postgresql-7.3.4-2PGDG
Problem:
--The following rule was created:--
create rule tbl_notities_project_id as
on insert to tbl_project_1
do
insert into tbl_notities (project_id) values (new.project_id);
--tbl_project_
Hello,
I have problem while configuring the PostGreSQL 7.4.2 on HPUX 11.11
(PARISC).
I am starting the configuration with the belwo command.
./configure --prefix=/usr/local/pgsql --without-readline --without-zlib
.**Starts the configurations
NOW.***
On Sat, 2004-07-17 at 14:30, Tom Lane wrote:
> David Newall <[EMAIL PROTECTED]> writes:
> > select * from a join b optimises differently to select * from a join
> > (select * from b) as b
>
> The above claim is provably false. Now, if you throw in some more
> tables and sprinkle in a LEFT JOIN in
On Sat, 2004-07-17 at 13:34, Tom Lane wrote:
> I suspect the real issue is that the implied join order is not the same.
With respect, the real issue is that using the view takes 100 times
longer than not using it.
> The view-based query is really
>
> a LEFT JOIN (b LEFT JOIN c LEFT JOIN d
I've been using large objects in PostgreSQL in two applications, and
I've found a couple things about the API frustrating:
0) In "Oid lo_creat(PGconn *conn, int mode)," why is there a mode on
lo_create? The mode is determined when the object is lo_open()ed,
right?
(By the way, the example in
On Sun, Jul 18, 2004 at 06:04:11PM +0200, Peter Eisentraut wrote:
> PostgreSQL Bugs List wrote:
> > on my Slackware 10 Linux PC with processor Intel Celeron 400.
> > When i do ./configure it is going OK.
> > When I do gmake - the window shows that gmake is doing some same
> > operations about 2-
PostgreSQL Bugs List wrote:
> on my Slackware 10 Linux PC with processor Intel Celeron 400.
> When i do ./configure it is going OK.
> When I do gmake - the window shows that gmake is doing some same
> operations about 2-3 hours without stopping and I stop the gmake with
> control-d and I have a
The following bug has been logged online:
Bug reference: 1196
Logged by: Ertan Geldiev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Slackware Linux 10
Description:I can not to install Postgresql-7.4.3
Details:
on my Slackware 10 L
PostgreSQL Bugs List wrote:
> this constraint doesn't work correctly : 'FOREIGN KEY (id_1, id_2)
> REFERENCES table_1 ON DELETE CASCADE'
> adding records into table_2 the database sometimes said that there is
> no corresponding record in table_1, but there is.
Please provide a concrete, reproducib
The following bug has been logged online:
Bug reference: 1195
Logged by: Michael Groth
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: debian
Description:foreignkey-bug
Details:
hello,
this constraint doesn't work correctly : 'FOREIG
12 matches
Mail list logo
