At 01:51 PM 15/11/2002 -0500, Rod Taylor wrote:
7.4 should hold the fix for
pg_dump, although 7.3 has the dependency tracking mechanism.
Which means that in theory we can back-patch them for 7.3.1.
Philip Warner
Brian Harris <[EMAIL PROTECTED]> writes:
> id | integer | not null default nextval('T_Joint_id_seq'::text)
This default is wrong --- it should be
nextval('"T_Joint_id_seq"'::text)
Note the quotes.
regards, tom lane
---(
Peter Muhlberger <[EMAIL PROTECTED]> writes:
> I'm trying to drop and re-create a database using postgres 7.1.3. When I
> try to drop the database using postmaster, I get the following error:
You could try reindexing pg_database. I think that an update to 7.2.3
would be advisable too, as soon as
Paul Buder <[EMAIL PROTECTED]> writes:
> I made my input file by printing out a asciified number, a tab,
> the text above and a newline. This is the attached file.
The attached file is gobbledegook:
3653337 x»&j
b
---(end of broadcast)---
TIP
On Wed, 2002-11-13 at 07:51, Brian Harris wrote:
> Hello,
> I have just updated to PostgreSQL 7.2.2. I am utilising tables with
> mixed case table and field names. I can now no longer insert data into
> these tables as shown by the following psql interchange:
>
> sharetrack=> \d "T_Joint"
>
> If you know how this problem might be fixed, list the solution below:
> -
>
> Dump all functions and types before indexes
This causes errors in other ways. The true solution is to have pg_dump
use a decent dependency tracking
fixed, thanks ...
On Mon, 11 Nov 2002, web_admin wrote:
> Regard must be paid to...
>
> This link is not available :
> http://www.pgsql.com/cd-dist.html
>
> From url http://www3.ru.postgresql.org/software.html
>
> Best regards,
> VVS.
>
>
>
> ---(end of broadcast)
On Thu, 2002-11-14 at 03:40, ðÏÐÏ× áÎÄÒÅÊ wrote:
> Hi.
> I have problem with Postgres.
> I have perl script, that add 2 records in 2 tables. This script I run
> from web throught web server Apache (on FreeBSD).
> (perl version 5.005)
You would be better off using the sequence rather than trying to
You should try 7.3beta. It will work on that OS.
---
Pan Global wrote:
> Speaking of which, I can't seem to get my postgres 7.2.1 to run at all on my
> new OS X 10.2 system. That works fine on 10.1.5. Do I have to instal
Hello,
I have just updated to PostgreSQL 7.2.2. I am utilising tables with
mixed case table and field names. I can now no longer insert data into
these tables as shown by the following psql interchange:
sharetrack=> \d "T_Joint"
Table "T_Joint"
Column |
After upgrading the database from 7.2 to 7.2.2 both relative and absolute
paths
are not accepted by either createdb or SQL-CREATE. AFAIK our provider used a
default built.
Using createdb I created databases in custom locations everal times before,
and it
worked ('datenbank/db_cluster' being the r
Regard must be paid to...
This link is not available :
http://www.pgsql.com/cd-dist.html
>From url http://www3.ru.postgresql.org/software.html
Best regards,
VVS.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PRO
Hi.
I have problem with Postgres.
I have perl script, that add 2 records in 2 tables. This script I run
from web throught web server Apache (on FreeBSD).
(perl version 5.005)
Tables structure:
create table object_list
(
obj_id serial primary key,
obj_name varchar(100)
);
create table texts
(
POSTGRESQL BUG REPORT TEMPLATE
Your name : Robert John Shepherd
Your email address : [
Dear all,
I would like to know where can I get help or instructions about how to configure a database, for example size parameters etc.
Thanks,
C.Roberto Soares.
Goiânia - Brasil
I'm trying to drop and re-create a database using postgres 7.1.3. When I
try to drop the database using postmaster, I get the following error:
postgres% dropdb surveyDB
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
b
Have installed PostgreSQL 7.2.1 binary from SCO ftp site to my SCO
OpenServer Enterprise v 5.0.4. No problems reported with installation.
Hovever, when I try any of the commands I get the following message:
dynamic linker: error opening /usr/local/lib/libz.so.
I cannot find the file "libz.so" anyw
Hi,
I think there is no Pg.3* manpage,
so cp fails after succesfuly build.
could somebody fix this in postgresql.spec:
cp `find $RPM_BUILD_ROOT -name 'Pg.3*' -print`
$RPM_BUILD_ROOT%{_mandir}/man3
should be:
cp `find $RPM_BUILD_ROOT -name 'Pg.*' -print`
$RPM_BUILD_ROOT%{_mandir}/man3
thanx
O
It seems the psql \copy command doesn't work properly when dealing
with certain non-ascii characters (which ones I don't know). At any rate
I took some binary data and escaped it like so with perl.
$text=~s/\\//g;
$text=~s/\n/\\\n/g;
$text=~s/\t/\\\t/g;
In other words I escaped escape chara
Using postgres 7.2.3 the query planner seems to lose interest in using
indexes when DISTINCT is used.
Sample query without DISTINCT:
SELECT
ps_7.id,
FROM
ps_7,
page
WHERE
page.id = ps_7.id
ORDER BY
ps_7.id DESC
LIMIT 5;
NOTICE: QUERY PLAN:
Limit (cost=0.00..33.22 rows=5 width=16)
it has already been fixed in 7.3b2
-ÓʼþÔ¼þ-
·¢¼þÈË: [EMAIL PROTECTED]
[mailto:pgsql-bugs-owner@;postgresql.org] ´ú±í [EMAIL PROTECTED]
·¢ËÍʱ¼ä: 2002Äê11ÔÂ14ÈÕ 21:50
ÊÕ¼þÈË: [EMAIL PROTECTED]
Ö÷Ìâ: [BUGS] Bug #818: There are no aggregate functions for type RELTIME
Paul Mamin ([EMAIL PR
Dear Support,
I was unsuccessfull with the OpenNMS deployment. I believe it might have
something to with the RedHat psyche 8.0 version incompatibility or something
else I am going to unstall all the rpm's and see if that makes a
difference. I have attached the discovery.log file that has error
Title: Óʼþ
Hello,
when I learn how to use the
varbit(n) datatype, I got the error:
test=# create table testdt ( b
varbit(2) );ERROR: parser: parse error at or near
"("
but can use as below
:
test=# create table testdt ( b
bit varying(2) );CREATE
The version
is:
test=# select
versi
Speaking of which, I can't seem to get my postgres 7.2.1 to run at all on my
new OS X 10.2 system. That works fine on 10.1.5. Do I have to install a
new version of postgres?
Peter
_
Protect your PC - get McAfee.com VirusScan Onli
Theodore Petrosky wrote:
> I just upgraded to system 10.2.2 for Mac OSX. I saw in
> the documentation that they have added a new
> Journaling File System so on a lark I turned it on.
>
> I see that when postgresql is starting up it now takes
> it quite a while (from about 2 seconds to 12-15
> seco
I just upgraded to system 10.2.2 for Mac OSX. I saw in
the documentation that they have added a new
Journaling File System so on a lark I turned it on.
I see that when postgresql is starting up it now takes
it quite a while (from about 2 seconds to 12-15
seconds). I don't see anything else 'weird'
26 matches
Mail list logo
