You'll probably be best off explicitly providing schema names for your common
functions, e.g. SELECT * FROM common.mytable . Depending on your app,
that could be better from a security point of view in PostgreSQL as well,
if you want to prevent your users from sneakily replacing the common
On Sat, 22 Jan 2005, Tino Wildenhain wrote:
INSERT INTO test (id, name)
SELECT COALESCE(MAX(id)+1, 1), 'name' FROM test
Ofcourse this gives problems when two clients are inserting a record at
the same time. (duplicate primary keys) But, i can't use a sequence in my
application (the pk
Ralph van Etten wrote:
I agree that a serial would be better.
But I think there are situations where a serial isn't convenient
Like when you want an primary key which consists of the current
year and an sequence number. Like ('05', 1), ('05', 2), ('05', 3) etc.
With a sequence you must write extra
On Sun, Jan 23, 2005 at 10:23:50 +0100,
Ralph van Etten [EMAIL PROTECTED] wrote:
But I think there are situations where a serial isn't convenient
Like when you want an primary key which consists of the current
year and an sequence number. Like ('05', 1), ('05', 2), ('05', 3) etc.
With a
On Sat, Jan 22, 2005 at 10:25:30PM -0600, Quinton Lawson wrote:
By default, Windows XP installs the QoS Packet Scheduler service. It
is not installed by default on Windows 2000. After I installed QoS
Packet Scheduler on the Windows 2000 machine, the latency problem
vanished.
Maybe this
While not an FAQ (yet?) I find it interesting that installing a QoS packet
scheduler would _improve_ response - (I'm assuming there's no other
concurrent traffic other than DB traffic).
Anyone know why this would be the case or have any ideas? Might it improve
performance for other network
On Sun, 23 Jan 2005 09:46:29 +0200, Jarkko Elfving [EMAIL PROTECTED] wrote:
On Sun, 2005-01-23 at 02:15 -0500, Tom Lane wrote:
Uh, /var/lib/pgsql should have been created for you by RPM installation.
I'm starting to think you have a corrupted postgresql-server RPM.
Also, in your prior
On Sun, Jan 23, 2005 at 07:46:26AM -0800, Lonni J Friedman wrote:
On Sun, 23 Jan 2005 09:46:29 +0200, Jarkko Elfving [EMAIL PROTECTED] wrote:
I'm thinking you're trying to hack too much on your own that the RPMs
do automagically. All you should need to do is install the RPMs,
start
Tom Lane wrote:
Niederland [EMAIL PROTECTED] writes:
System: the released Postgres 8.0, winXP
Using:
pg_dump --format=t --blobs myDB DBFile
pg_restore --create -dbname=crm DBFile
Resulted in:
pg_restore: [archiver] unsupported version (1.13) in file header
Come to think of it,
On Sun, 23 Jan 2005 12:57:18 -0300, Alvaro Herrera
[EMAIL PROTECTED] wrote:
On Sun, Jan 23, 2005 at 07:46:26AM -0800, Lonni J Friedman wrote:
On Sun, 23 Jan 2005 09:46:29 +0200, Jarkko Elfving [EMAIL PROTECTED]
wrote:
I'm thinking you're trying to hack too much on your own that the RPMs
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sun, 23 Jan 2005, Lonni J Friedman wrote:
snip
I'd suggest uninstalling all postgresql RPMs, deleting /var/lib/pgsql,
reinstalling the RPMs and then just start /etc/init.d/postgresql. If
that fails to work, then set PGLOG in
Alvaro Herrera [EMAIL PROTECTED] writes:
... But this is strange and unexpected:
Also I run a /usr/bin/postgres -V but this doesn't give any results.
Yeah, I thought so too. I was able to reproduce it just now, though,
with selinux enforcement on (sudo /usr/sbin/setenforce 1). Currently
Tom Lane [EMAIL PROTECTED] writes:
... running yum update to see if it still happens with the latest
selinux-policy-targeted ... if so there will be a bug report opened
soon, and not against postgres ;-)
Filed as
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=145901
Now initdb had been
Am Sonntag, den 23.01.2005, 07:46 -0800 schrieb Lonni J Friedman:
...
I'd suggest uninstalling all postgresql RPMs, deleting /var/lib/pgsql,
reinstalling the RPMs and then just start /etc/init.d/postgresql. If
that fails to work, then set PGLOG in /etc/init.d/postgresql to
something other
Chris wrote:
I know this isn't entirely postgresql specific, but it wouldn't be on
another list either so here goes...
I am writing an open source application where I would like to support
at least oracle, and possibly firebird or DB2, in addition to
postgresql which will be the default. I'm not
How are foreign key constraints built? In loading my database into
PostgreSQL 8.0, on the command:
ALTER TABLE ONLY TABLEA
ADD CONSTRAINT $1 FOREIGN KEY (mkey) REFERENCES tableb(mkey) ON DELETE
CASCADE;
I ended up with the following in pg_tmp as it is adding the constraint:
-rw---1
Wes [EMAIL PROTECTED] writes:
There's no problem here, I'd just like to understand what it is doing.
Either a hash or merge join between the two tables, to verify that all
the keys in the referencing table exist in the referenced table. The
intermediate data is evidently spilling to disk.
I
On Sun, 2005-01-23 at 08:20 -0800, Lonni J Friedman wrote:
Where did you get these RPMs?
I'd downloaded it from PostgreSQL's mirror ftp -site (UK).
I'm now starting this re-installing what you guys are suggesting to me.
I will reply in here how I'm succeeded or not succeeded.
One more
Jarkko Elfving [EMAIL PROTECTED] writes:
One more question: Tom Laine suggest me to switching off the SE-Linux
policy enforcement (I will upgrade my system reqularly, so I think that
I have the latest versions of SE-Linux - I hope) - but, is this SE-Linux
how important service? Friend of my do
Hi.
First thing I would to thanks to Tom Lane, Lonni Friedman and Alvaro
Herrera for helping me out for my Postgre upgrading/re-installing
problem.
Re-Installation were succeed (I did turning off the SE-Linux policy
enforcement via the Security Level GUI) and after re-installing the
PostgreSQL I
When declaring a cursor is there a way to return the number of rows that
the declared cursor consists of ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
Hello,
sorry for the trivial question. Is there any difference between varchar
and text types in practice? I couldn't find.
Mage
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Sun, Jan 23, 2005 at 10:09:14PM +0100, Mage wrote:
Hi,
sorry for the trivial question. Is there any difference between varchar
and text types in practice? I couldn't find.
No.
--
Alvaro Herrera ([EMAIL PROTECTED])
Y dijo Dios: Que sea Satanás, para que la gente no me culpe de todo a mí.
On Sun, Jan 23, 2005 at 02:01:41PM -0500, Tom Lane wrote:
Wes [EMAIL PROTECTED] writes:
There's no problem here, I'd just like to understand what it is doing.
Either a hash or merge join between the two tables, to verify that all
the keys in the referencing table exist in the referenced
On Sun, Jan 23, 2005 at 03:19:10PM -0600, Jim C. Nasby wrote:
People have this weird notion that an index-based plan is always faster
than anything else. If you like you can try the operation with set
enable_seqscan = off, but I bet it will take longer.
Well, every other database I've
Christoffer Gurell [EMAIL PROTECTED] writes:
When declaring a cursor is there a way to return the number of rows that
the declared cursor consists of ?
Not without actually scanning the result, if that's what you meant.
regards, tom lane
On Sun, Jan 23, 2005 at 06:45:36PM -0300, Alvaro Herrera wrote:
On Sun, Jan 23, 2005 at 03:19:10PM -0600, Jim C. Nasby wrote:
People have this weird notion that an index-based plan is always faster
than anything else. If you like you can try the operation with set
enable_seqscan =
Hi everybody.
It's my first message, I hope I'm in the right ml.
I'm using postgresql 7.4.6 on gentoo 2004.2.
I've set nls use flag in make.conf.
I want to set locale to it_IT so that when I issue select to_char(some_date,
'Day') from some_table I see for example Lunedì instead of Monday (Lunedì
On Sun, Jan 23, 2005 at 11:08:24PM +0100, kamal wrote:
Hi,
I want to set locale to it_IT so that when I issue select to_char(some_date,
'Day') from some_table I see for example Lunedì instead of Monday
(Lunedì
is the italian translation for Monday)...
I don't think to_char() knows about
I don't think to_char() knows about i18n/l10n yet. So you'd need to
patch it, or convince somebody to do it for you.
Ah, ok, I see. I can't do it. I think I'll write it in PL/pgSQL.
Thank you very much.
Kamal
6X velocizzare la
I am developing a new image datatype in postgres which contains a binary
field for storing image data and some other fields for additional information
about the image, like size, resolution, etc. I was hoping that the clients can
saving their time by directly retrieving these information from
On Sun, Jan 23, 2005 at 04:34:44PM -0700, Yu Pan wrote:
I am developing a new image datatype in postgres which contains a binary
field for storing image data and some other fields for additional information
about the image, like size, resolution, etc. I was hoping that the clients
can
Hello Yu Pu,
Am 2005-01-23 16:34:44, schrieb Yu Pan:
I am developing a new image datatype in postgres which contains a binary
field for storing image data and some other fields for additional information
about the image, like size, resolution, etc. I was hoping that the clients
can
Richard Huxton dev@archonet.com writes:
Hmm - wonder if there might be some memory leak in updates to the R-tree
Yup, found one. The attached patch is against 7.4.
regards, tom lane
Index: rtree.c
===
RCS
I have a table with 500,000 records which has some invalid records, I had wrote
a program to check it, by the program I get all OIDs of the redundant records,
so I use delete from tableXXX where oid =XXX1 or oid =XXX2 or oid =XXX3 ... or
oid=XXX1000, but it take me a long time to complete
When grilled further on (Mon, 24 Jan 2005 12:29:12 +0800),
Öܵ½¾© [EMAIL PROTECTED] confessed:
I have a table with 500,000 records which has some invalid records, I had
wrote a program to check it, by the program I get all OIDs of the redundant
records, so I use delete from tableXXX where oid
On Mon, Jan 24, 2005 at 12:29:12PM +0800, Öܵ½¾© wrote:
I have a table with 500,000 records which has some invalid records,
I had wrote a program to check it, by the program I get all OIDs of
the redundant records, so I use delete from tableXXX where oid =XXX1
or oid =XXX2 or oid =XXX3 ...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I've just upgraded two servers to 8.0.0, using PGDG RPMs.
One of them is working well; however I'm experiencing problems in the
other one.
I first thought that this was a VACUMM issue; but then I saw that I can't
execute any command.
First
On Sun, 23 Jan 2005, William Yu wrote:
Ralph van Etten wrote:
I agree that a serial would be better.
But I think there are situations where a serial isn't convenient
Like when you want an primary key which consists of the current
year and an sequence number. Like ('05', 1), ('05', 2),
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 24 Jan 2005, Devrim GUNDUZ wrote:
I've just upgraded two servers to 8.0.0, using PGDG RPMs.
One of them is working well; however I'm experiencing problems in the
other one.
snip
(scratching head)
I've changed statement_timeout value from 5
40 matches
Mail list logo