Hi,
I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure if
what I found with pgxml is a feature of a bug:
I've got the following table:
CREATE TABLE test
(
id int4 NOT NULL,
xml varchar(200),
CONSTRAINT pk PRIMARY KEY (id)
)
WITHOUT OIDS;
Nik [EMAIL PROTECTED] wrote
I also noticed that I am having the similar issue with SELECT
statements. Same SELECT statement will run fine 3-4 times in a row and
then get stuck and run forever with no results. But if I reload the
configuration like above, the query immediatelly returns with
Agent M wrote:
If you don't use NULL, then you don't
come across 3-valued logic--problem solved.
So was does SELECT sum(1) FROM dual WHERE false return?
/Nis
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi list
What is the comment to add OIDs to a already existing table, or i have
to recreate the table?
Thanks,
Clemens
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Friday 09 June 2006 06:34 am, Bert [EMAIL PROTECTED] thus
communicated:
-- Hi list
-- What is the comment to add OIDs to a already existing table, or i have
-- to recreate the table?
--
-- Thanks,
-- Clemens
--
--
Well, according on \h ALTER TABLE on version 7.4.6 all you can do is SET
Hi,
( Yes, I re-read the title 5 times, it sounds correct to me! :) )
I've got a SRF similar to:
---
CREATE FUNCTION srf_perl
(
IN i_a int4,
INOUT io_bint4,
OUT o_c int4
)
RETURNS SETOF record
AS
$$
Well, the Date argument against NULLs (and he never endorsed them, or
so he claims) is that they are not data- they represent the absence of
data- so why put non-data in a _data_base.
If you are asking yourself the question how you can have support
multiple meanings in a column, normalize.
On Jun 8, 2006, at 9:32 PM, David Fetter wrote:
On Thu, Jun 08, 2006 at 06:09:21PM -0700, Trent Shipley wrote:
On Thursday 2006-06-08 15:14, David Fetter wrote:
On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote:
on bag theory[1] and 3-value logic[2]. Until they come up
Thanks, so it seems that i can delete the OIDs but not insert them okay
so i have to recreate the table.
Terry Lee Tucker schrieb:
On Friday 09 June 2006 06:34 am, Bert [EMAIL PROTECTED] thus
communicated:
-- Hi list
-- What is the comment to add OIDs to a already existing table, or i have
# [EMAIL PROTECTED] / 2006-06-09 10:12:21 +0200:
Agent M wrote:
If you don't use NULL, then you don't
come across 3-valued logic--problem solved.
So was does SELECT sum(1) FROM dual WHERE false return?
You stripped this:
Some Tutorial D notions really make sense; I would love to be
Hello.I think this short manual can help youhttp://archives.postgresql.org
/pgsql-hackers-win32/2005-07/msg00022.phpI've installedversion 8.1.4withoutwin-serviceregistrationandautomaticaccountcreation,ifyoumeantthis.--Sorry for poor English.
On 6/9/06, Michael Louie Loria [EMAIL PROTECTED]
I did a clean install of 8.0.8 from ports on FreeBSD 5.4 and tried -
./010.pgsql.sh start
./010.pgsql.sh initdb
but there was no reaction.
This worked normal -
/usr/local/bin/initdb -D /usr/local/pgsql/data
Also
./010.pgsql.sh initdb
works in clean install if I put postgresql_enable=YES in
I think I got closer to the problem.
I did clean install of PostgreSQL 8.0.8 on FreeBSD 5.4, then Apache
1.3.36, then PHP 5.1.4 - all compiled from ports. Till here it all works.
Now I install just the php5-pgsql extension. Restart Apache. All works.
Reboot the FreeBSD - and Apache does core
Gavin M. Roy wrote:
It doesnt sound like an apache problem to me, it sounds like a library
version conflict happening in PHP, so apache shouldn't impact it. What
happens when you try and access pgsql functions from the cli?
Just tried a simple -
$result = pg_connect(...);
echo $result;
[EMAIL PROTECTED] wrote:
Why isn't
./010.pgsql.sh start
./010.pgsql.sh initdb
working? Am I doing something wrong?
You need to add postgresql_enable=YES to your /etc/rc.conf.
This changed in FreeBSD 6.
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F:
Alban Hertroys wrote:
[EMAIL PROTECTED] wrote:
Why isn't
./010.pgsql.sh start
./010.pgsql.sh initdb
working? Am I doing something wrong?
You need to add postgresql_enable=YES to your /etc/rc.conf.
This changed in FreeBSD 6.
I did that and it worked. Was just wondering what's wrong with
thanks.
Tom Lane wrote:
[EMAIL PROTECTED] writes:
My troubles would be solved if I could reference a SessionID from
within PG. Any hope?
Create a sequence. At session start, nextval() it to assign a session
ID for your session. Then currval() returns your session ID whenever
you need
A bit simplistic, but in a nutshelll
They are used for different things. A natural PK is used for data
integrity purposes, and if it is a single attr, it can also be a
performance enhancing index.
An artificial key is used to speed up queries, by allowing joins on a
single indexed
[EMAIL PROTECTED] wrote:
I did that and it worked. Was just wondering what's wrong with 010...
Nothing at all ;)
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your
Hi,
how can one set the global OID counter in 8.1.X? We think it would work
in 8.0.X using the COPY WITH OIDS command but this does not work in
8.1.X anymore.
We have the problem that we made a dump using 'pg_dump -o' in 8.0.X,
created a new database in 8.1.X and read back in but the global
Alban Hertroys wrote:
[EMAIL PROTECTED] wrote:
I did that and it worked. Was just wondering what's wrong with 010...
Nothing at all ;)
So you mean it is OK that 010.pgsql.sh does not work unless
postgresql_enable=YES is added to /etc/rc.conf?
---(end of
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Alban Hertroys wrote:
[EMAIL PROTECTED] wrote:
I did that and it worked. Was just wondering what's wrong with 010...
Nothing at all ;)
So you mean it is OK that 010.pgsql.sh does not work unless
postgresql_enable=YES is added to
Take some time to read the docs on the rcng system. The rulse have
changed.
Oh, thanks a lot!
Iv
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-06-09 10:12:21 +0200:
Agent M wrote:
If you don't use NULL, then you don't
come across 3-valued logic--problem solved.
So was does SELECT sum(1) FROM dual WHERE false return?
You stripped this:
Some Tutorial D notions really make
Dirk Lutzebäck wrote:
Hi,
how can one set the global OID counter in 8.1.X? We think it would work
in 8.0.X using the COPY WITH OIDS command but this does not work in
8.1.X anymore.
pg_resetxlog -o
(Postmaster stopped of course)
--
Alvaro Herrera
Alvaro Herrera [EMAIL PROTECTED] writes:
Dirk Lutzebäck wrote:
how can one set the global OID counter in 8.1.X? We think it would work
in 8.0.X using the COPY WITH OIDS command but this does not work in
8.1.X anymore.
pg_resetxlog -o
(Postmaster stopped of course)
Possibly more to the
[EMAIL PROTECTED] wrote:
I'm reading, and enjoying immensely, Fabial Pascal's book Practical
Issues in Database Management.
I also found this book very useful when I first started doing serious
database work. For a more thorough treatment of many of these issues,
see An Introduction to
I cannot figure this out I am trying to do a silent
install.
Here is my command
msiexec /i postgresql-8.1-int.msi /qb /log install.log
INTERNALLAUNCH=1 ADDLOCAL=server,psql SERVICEDOMAIN=%COMPUTERNAME%
SERVICEPASSWORD=SecretWindowsPassword123
SUPERPASSWORD=VerySecret
Also, Date mentions the notion that tables don't have to be mapped to
individual files. For example, if the types of queries are known in
advance, it could be possible to rearrange the data to be optimal for
those queries. Currently, tables are just big serialized arrays.
On Fri, June 9, 2006
Hi,
Im trying to upgrade from 7.4 - 8.1 but it is failing with Unicode
errors. The offending character is the greek character mu (often used
for micro). Here is an offending string [EMAIL PROTECTED] (in case it doesn't
appear in the email, the mu is between the B and the G)
Any ideas why this
On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
Hi,
Im trying to upgrade from 7.4 - 8.1 but it is failing with Unicode
errors. The offending character is the greek character mu (often used
for micro). Here is an offending string [EMAIL PROTECTED] (in case it
doesn't
appear
This is not a large object. We are seeing rows with duplicate oids
because the OID counter is not changed after the dump (exported with
--oids) is being loaded.
How does 8.1 prevent to allocate duplicate OIDs?
Regards,
Dirk
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
Hi,
Im trying to upgrade from 7.4 - 8.1 but it is failing with Unicode
errors. The offending character is the greek character mu (often used
for micro). Here is an offending string [EMAIL PROTECTED]
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= [EMAIL PROTECTED] writes:
This is not a large object. We are seeing rows with duplicate oids
because the OID counter is not changed after the dump (exported with
--oids) is being loaded.
How does 8.1 prevent to allocate duplicate OIDs?
If there's a unique
On Fri, Jun 09, 2006 at 07:09:12AM -0400, Agent M wrote:
Well, the Date argument against NULLs (and he never endorsed them, or
so he claims) is that they are not data- they represent the absence of
data- so why put non-data in a _data_base.
At this point you could start a whole philosophical
Adam Witney wrote:
Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
Hi,
Im trying to upgrade from 7.4 - 8.1 but it is failing with Unicode
errors. The offending character is the greek character mu (often used
for micro). Here is an offending
On Fri, Jun 09, 2006 at 04:17:50PM +0100, Adam Witney wrote:
It's a valid unicode character, it's just you havn't encoded it in
unicode. It's probably in Latin-1. In that case, you need to specify it
in the client encoding...
Hi Martijn,
thanks for your quick response.
Ok i am a bit
On Fri, June 9, 2006 11:17 am, Adam Witney wrote:
Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
Hi,
Im trying to upgrade from 7.4 - 8.1 but it is failing with Unicode
errors. The offending character is the greek character mu (often used
for
I have to replace fields with this in it with a valid string that will
load into 8.1, do you know who i would do the conversion?
The database will do it for you. Note that the client encoding affects
input *and* output. So if you set it to latin1, the database will
convert all strings to
For migration, you should pg_dump- it's not clear from your email whether
you are doing that. If you typed up some sql in Windows which you want to
load into postgres, you might try:
set client_encoding to 'LATIN1';
at the top of your script.
yes this was how i spotted the problem. If i
True.
Dirk
Tom Lane wrote:
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= [EMAIL PROTECTED] writes:
This is not a large object. We are seeing rows with duplicate oids
because the OID counter is not changed after the dump (exported with
--oids) is being loaded.
How does 8.1 prevent to
On Fri, Jun 09, 2006 at 03:55:04PM +0200, Aaron Bingham wrote:
[EMAIL PROTECTED] wrote:
I'm reading, and enjoying immensely, Fabial Pascal's book
Practical Issues in Database Management.
If you're interested in the theory of RDBMSs, you can start with the
papers on Leonid Libkin's page and
On Fri, Jun 09, 2006 at 05:20:46PM +0200, Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 07:09:12AM -0400, Agent M wrote:
Well, the Date argument against NULLs (and he never endorsed them,
or so he claims) is that they are not data- they represent the
absence of data- so why put
On Fri, June 9, 2006 11:45 am, David Fetter wrote:
On Fri, Jun 09, 2006 at 05:20:46PM +0200, Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 07:09:12AM -0400, Agent M wrote:
Well, the Date argument against NULLs (and he never endorsed them,
or so he claims) is that they are not data-
Qingqing Zhou [EMAIL PROTECTED] writes:
A wild guess is that when we continue to sleep on the semaphore, magically
we get it, but how come?
Buggy SysV semaphore support in the kernel, maybe? What platform is
this exactly?
regards, tom lane
Yes, and all SQL products worth their salt include some languages to
provide iteration and other processing that SQL can't do or doesn't do
well. Why must the rules be different for a truly relational db. (see
http://dbappbuilder.sourceforge.net/Rel.html)
I may get interested if some actual
On Fri, Jun 09, 2006 at 12:29:59PM -0400, A.M. wrote:
Yes, and all SQL products worth their salt include some languages
to provide iteration and other processing that SQL can't do or
doesn't do well. Why must the rules be different for a truly
relational db. (see
On Fri, Jun 09, 2006 at 12:01:07PM -0400, A.M. wrote:
So you should normalize and add relations to represent the state
adequately. NULL doesn't give you enough information anyway- does NULL in
a birthday header mean no birthday, n/a (a business doesn't have a
birthday), not born yet, etc...
On Fri, Jun 09, 2006 at 04:32:35PM +0100, Adam Witney wrote:
The database will do it for you. Note that the client encoding affects
input *and* output. So if you set it to latin1, the database will
convert all strings to latin1 before sending them to you...
ok, so my current database
This tells me that you need to be vacuuming more. Autovac is your
friend.
On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote:
Yeah - I just did a reindex, that fixed the indexes at least.
Alex
On 6/8/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Thu, Jun 08, 2006 at 06:03:23PM
On Fri, Jun 09, 2006 at 04:27:41AM -0700, Bert wrote:
Thanks, so it seems that i can delete the OIDs but not insert them okay
so i have to recreate the table.
I think a better question would be: why are you using OIDs in the first
place? You'll almost certainly be much happier with a serial
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Sincerely,
Wei Weng
---(end of broadcast)---
TIP 6: explain analyze is your friend
In the future, please don't send the same email to a bunch of pgsql
lists; one is almost always sufficient. (In this case, -admin OR
-general woulud have been best).
On Fri, Jun 09, 2006 at 05:27:47PM +0200, Dirk Lutzeb?ck wrote:
True.
Dirk
Tom Lane wrote:
On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Slony, pgmirror, and I think there's another one.
google:postgresql replication
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
There is Slony http://www.slony.info/ which is OSS
and Replicator which is commercial and it is at:
http://www.commandprompt.com/
Joshua D. Drake
Sincerely,
Wei Weng
On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote:
On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Slony, pgmirror, and I think there's another one.
google:postgresql replication
pgpool does
Or pretty similar, check it out
http://www.glom.org/wiki/index.php?title=Main_Page
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of
On Fri, Jun 09, 2006 at 01:51:23PM -0500, Scott Marlowe wrote:
On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote:
On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Slony, pgmirror, and I think
On Friday 09 June 2006 12:39, David Fetter wrote:
On Fri, Jun 09, 2006 at 12:29:59PM -0400, A.M. wrote:
Yes, and all SQL products worth their salt include some languages
to provide iteration and other processing that SQL can't do or
doesn't do well. Why must the rules be different for a
On Fri, Jun 09, 2006 at 03:18:54PM -0400, Robert Treat wrote:
On Friday 09 June 2006 12:39, David Fetter wrote:
On Fri, Jun 09, 2006 at 12:29:59PM -0400, A.M. wrote:
Yes, and all SQL products worth their salt include some languages
to provide iteration and other processing that SQL
Hi,
On Fri, 09 Jun 2006 08:43:51 +0200, Philippe Lang wrote:
I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure
if what I found with pgxml is a feature of a bug:
[snip]
I get:
iddoc_num line_numval1val2val3
1 C1
On Friday 2006-06-09 09:50, Martijn van Oosterhout wrote:
On Fri, Jun 09, 2006 at 12:01:07PM -0400, A.M. wrote:
So you should normalize and add relations to represent the state
adequately. NULL doesn't give you enough information anyway- does NULL in
a birthday header mean no birthday, n/a
62 matches
Mail list logo
