"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 return
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
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
$$
@i
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. The
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 wit
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
# [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
Hello.I think this short manual can help youhttp://archives.postgresql.org
/pgsql-hackers-win32/2005-07/msg00022.phpI've installed version 8.1.4 without win-service registration and automatic account creation, if you meant this.--Sorry for poor English.
On 6/9/06, Michael Louie Loria <[EMAIL PRO
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" i
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;
wit
[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: ++31(0)
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 0
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
>
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 attribut
[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 W
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 broadca
"[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 a
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] so
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 notio
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 Herrerahttp:/
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
[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 D
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" BASEDIR=
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 9:55
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
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
=?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 uni
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 philosophic
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 stri
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
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 charac
>> 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 stri
> 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
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 allo
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
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 pu
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
"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
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 http://dbappbui
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",
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 databa
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
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 co
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:
> >=?ISO-8859-1?Q?Dirk_Lutzeb
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]
Perv
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 doe
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 broadcast)
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, a
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 diff
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 t
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
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 birthda
61 matches
Mail list logo
