[BUGS] Upgrade to 7.1.2 problem
hi i recently upgraded to postgresql-7.1.2 but when i start the service, i get the folllowing error message! An old version of the database format was found.\nYou need to upgrade the data format before using PostgreSQL.\nSee / usr/share/doc/postgresql-7.1.2/README.rpm-dist for more information. As far as i know the old databases have been upgraded! Whatsover, if there are any other databases in there and i dont want any of those older databases, what do i do! thanks in advance Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] bug report: tuple is too big
Sir: I was testing my php web content manager yesterday when an error suddenly popped out as I was trying to save my article to the database. The error was "PostgreSQL query failed: Error: Tuple is too big: size 8812". My table schema for the news article: neid serial netitlevarchar(120) nebody text I am using PostgreSQL version 6.5 (included in Red Hat Linux 6.2). The article I was trying to insert into the database was fairly large. Is there an official patch I can apply to overcome this limit. Or is the new version of PostgreSQL capable of handling larger inputs. Any help will be greatly appreciated. Thanks in advance. Regards, Joel G. Guevara Programmer IBM Solutions Delivery, Inc. 5/F IBM Plaza, Eastwood City Cyberpark Libis, Quezon City Philippines, 1110 Phone: (63)-2-9950220 local 563 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] Re: [PORTS] Compilation on Solaris 2.8
Hi, Postgres 7.1.2 is runing fine at my site (Solaris 2.6 ans Solaris 2.6). I used gcc-2.95.3 and make-3.79.1 (both downloaded from www.sunfreeware.com). I had just one problem: during compilation you need the ar - command in your PATH. Look at the manpages of ar for the proper Path. CU Andre - Original Message - From: Manoj Nair To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Monday, July 09, 2001 1:41 PM Subject: [PORTS] Compilation on Solaris 2.8 Hi : I am having problems in compiling Postgres 7.1. I am using the following compilers on Solaris 2.8 on a Sparc Ultra 60 machine. Sun WorkShop 6 update 1 C++ 5.2 2000/09/11 Sun WorkShop 6 update 1 C 5.2 2000/09/11 Is there a port available for this configuration ? Thanks, Manoj Nair ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] Re: [PORTS] Compilation on Solaris 2.8
Hi Andre, We have also compiled postgres with gcc. Our development environment uses Solaris Workshop, and we tried some test programs, compiled with Sun's Forte compiler, and using the gcc compiled postgres libraries. This did not work. We got linker errors like the following Undefined first referenced symbol in file PgConnection::PgConnection #Nvariant 1(const char*) testlibpq0.o PgConnection::~PgConnection #Nvariant 1() testlibpq0.o int PgConnection::ConnectionBad() testlibpq0.o void PgDatabase::DisplayTuples(__FILE*,int,const char*,int,int) testlibpq0.o ExecStatusType PgConnection::Exec(const char*) testlibpq0.o const char*PgConnection::ErrorMessage() testlibpq0.o ld: fatal: Symbol referencing errors. No output written to testlibpq0 make: *** [testlibpq0] Error 1 Hence our attempt to compile Postgres with Sun's compiler... Thanks, Manoj Andre Schnabel wrote: > Hi, > > Postgres 7.1.2 is runing fine at my site (Solaris 2.6 ans Solaris 2.6). > I used gcc-2.95.3 and make-3.79.1 (both downloaded from > www.sunfreeware.com). > I had just one problem: > during compilation you need the ar - command in your PATH. > Look at the manpages of ar for the proper Path. > > CU > Andre > > - Original Message - > From: Manoj Nair > To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] > Sent: Monday, July 09, 2001 1:41 PM > Subject: [PORTS] Compilation on Solaris 2.8 > > Hi : > > I am having problems in compiling Postgres 7.1. > I am using the following compilers on Solaris 2.8 on a Sparc Ultra 60 > machine. > > Sun WorkShop 6 update 1 C++ 5.2 2000/09/11 > Sun WorkShop 6 update 1 C 5.2 2000/09/11 > > Is there a port available for this configuration ? > > Thanks, > Manoj Nair > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] src/interfaces/odbc on solaris 7
Greetings. In order to build the odbc library, I had to change the GNUMakefile entry of: SHLIB_LINK = $(filter -lm, $(LIBS)) To SHLIB_LINK = $(filter -lm, $(LIBS)) -lz -lresolv -lgen -lnsl -lsocket -ldl -lm -lxnet -shared Using , GNU Make version 3.78.1, gcc version 2.95.2 19991024 (release), native solaris 7 ld and ar. The odbc build linking process failed altogether, couldn't resolve any of the networking symbols, so I added them ALL, plus the -shared flag. Aside from that, WOW nice software folks. FYI only cause you probably know about his one. -- Rocke Robertson NCS/GTIS/PWGSC 700 Montreal Rd. [EMAIL PROTECTED] (613) 748-4604 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [BUGS] your web site register is broken, cannot download Win32distribution needed
these errors *should* be fixed ... we had problems with the database
server this morning, but we think we've exorcised the demons ...
On Fri, 13 Jul 2001 [EMAIL PROTECTED] wrote:
> Jill Gemmill ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> your web site register is broken, cannot download Win32 distribution needed
>
> Long Description
> (1) I went to http://www.ca.postgresql.org/ftpsite/odbc/download.html to
> download the Win32 Binary Distribution and it wants me to log in (anonymous
> login not accepted).
>
> (2) I could not find any information suggesting how to register. It would
> be helpful to have a link that took you to the registration page so that you
> didn't have to hunt around for it.
>
> (3) On your home page, there is a link: http://www.pgsql.com/register but it
> goes to an error page and there is no way to register. Here are the error messages
>caused by clicking on the register link:
>
>
> Warning: Unable to connect to PostgreSQL server: PQconnectPoll() -- connect()
>failed: Operation timed out Is the postmaster running (with -i) at 'db.hub.org' and
>accepting connections on TCP/IP port 5432? in /usr/local/www/php-global/global.php on
>line 10
>
> Warning: Supplied argument is not a valid PostgreSQL link resource in
>/usr/local/www/php-global/global.php on line 15
>
> Warning: Supplied argument is not a valid PostgreSQL result resource in
>/usr/local/www/php-global/global.php on line 16
>
> Warning: Supplied argument is not a valid PostgreSQL link resource in
>/usr/local/www/php-global/global.php on line 17
>
>
> What I'm looking for is the Win32 Binary Distribution. Thanks.
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[BUGS] OpenSSH, Windows Clients, and Incoming Tunnels
Hi Folks I've got the built-in OpenSSH (2.2.0) running on FreeBSD 4.2, and I connect to it from Windows with SSH Security Corp.'s SSH Secure Shell 2.4. As a terminal, it works fine. I want to use this product to encrypt data between a PostgreSQL backend and Windows clients. The Windows clients use ODBC to talk to PostgreSQL. When I define an OUTGOING tunnel, it works fine. For example: :freebsd.box:5432. PostgreSQL listens and sends at port 5432 and the Windows ODBC driver looks for PostgreSQL at 127.0.0.1, port . When I define an INCOMING tunnel (same local_port:server:remote_port), it appears to work fine, but the 'BSD box console displays an error message 3 times: sshd[436]: error: Hm, dispatch protocol error: type 80 plen 33 The log, though listing this same error (3 times), does not indicate any other problems. This error only appears if I define an incoming tunnel in the Windows SSH client. My application works (quite well), but I'm worried that the incoming data stream, which will contain sensitive data, is not encrypted. By the way, the Van Dyke product (SecureCRT) does the exact same thing. Can anyone advise? Thankyou in advance... -- Paul Lender Paul A. Lender Univ. of Minnesota Dept. Orthopaedic Surgery [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] No subselects in constraint (bug?)
Hello there! [Please Cc: me in followups.] I tried the following: CREATE TABLE a ( int4 id ); CREATE TABLE b ( int4 id CHECK (id = ANY(SELECT a.id FROM a)) ); Tables are created ok, checking with '\d table' confirms it. But when I try to insert into table b, e.g.: INSERT INTO b (id) VALUES (0); I get: ERROR: ExecEvalExpr: unknown expression type 108 Of course, the tuple is not inserted. As quick dig of code showed, type 108 is T_SubLink which is created for ANY() subselect, and ExecEvalExpr() function does not handle this type of node. Is it intentional or a bug? I use 7.0.3, but 7.1.2 code looks pretty the same in ExecEvalExpr(). The platform is FreeBSD 4.3-R. TIA for responses, Alexey. -- -+--- Yes. We have good news!| Regards, Alexey V. Neyman Well, that is to say, we have no news. | mailto: [EMAIL PROTECTED] --( Pkunk, SC2 )-+--- ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [BUGS] Upgrade to 7.1.2 problem
On Wednesday 11 July 2001 13:57, Kannan The Barbarian wrote: > i recently upgraded to postgresql-7.1.2 but when i start the service, i get > the folllowing error message! > An old version of the database format was found.\nYou need to upgrade the > data format before using PostgreSQL.\nSee / > usr/share/doc/postgresql-7.1.2/README.rpm-dist for more information. > As far as i know the old databases have been upgraded! Whatsover, if there > are any other databases in there and i dont want any of those older > databases, what do i do! Check to see where it thinks the old data is -- 'it' being the RPM init script that is issuing that error message. The two choices of a default RPM install are /var/lib/pgsql and /var/lib/pgsql/data -- you need to remove the whole tree, leaving /var/lib/pgsql/data and /var/lib/pgsql/backups left empty. Now rerun the initscript, and it will happily create a new,empty, database tree for you that you can start working with. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [BUGS] bug report: tuple is too big
Joel G Guevara writes: > I am using PostgreSQL version 6.5 (included in Red Hat Linux 6.2). bug report: version is too old -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] No subselects in constraint (bug?)
On Fri, 13 Jul 2001, Alexey V. Neyman wrote: > Hello there! > > [Please Cc: me in followups.] > > I tried the following: > > CREATE TABLE a ( > int4 id > ); > CREATE TABLE b ( > int4 id > CHECK (id = ANY(SELECT a.id FROM a)) > ); > > Tables are created ok, checking with '\d table' confirms it. But when I > try to insert into table b, e.g.: > INSERT INTO b (id) > VALUES (0); > I get: > ERROR: ExecEvalExpr: unknown expression type 108 > Of course, the tuple is not inserted. > > As quick dig of code showed, type 108 is T_SubLink which is created for > ANY() subselect, and ExecEvalExpr() function does not handle this type of > node. Is it intentional or a bug? It's unimplemented, and really should fail at create time (I'm not sure if it does in 7.1). IIRC, it's only required at FULL SQL92 level (intermediate level has a no subqueries limitation). The reason is that the constraint you are making as part of b also constrains table a and it's not entirely trivial to support complicated subquery constraints within the current system. As a workaround for now, you'll probably have to use triggers on a and b to do the check. (before insert trigger on b and a delete/update trigger on a). ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] No subselects in constraint (bug?)
"Alexey V. Neyman" <[EMAIL PROTECTED]> writes: > CREATE TABLE b ( > int4 id > CHECK (id = ANY(SELECT a.id FROM a)) > ); > ERROR: ExecEvalExpr: unknown expression type 108 More recent versions say ERROR: Cannot use subselect in CHECK clause It seems to me that what you really want here is a foreign key reference, anyway, not a handmade CHECK constraint. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple(0,9) not found
> So that raises this from an unimplemented feature to a real bug, or at > least higher priority in my eyes. You can't do a CREATE/ALTER USER > followed by an UPDATE on pg_shadow in a single transaction: I'm glad I could be of some help. I don't know if the following means anything to you (or the pgsql-odbc folks), but in the past (I don't recall if that was postgres 7.0.3, 7.1.1 or 7.1.2) I used to get the following error message while issuing a "BEGIN, ALTER USER ..., COMMIT" block, coming in through an ODBC connection using VC++ 6 with the 7.01.00.05 driver: ERROR: ALTER USER: may not be called in a transaction block Doing a BEGIN, ALTER USER.., COMMIT (not through ODBC, through the psql client) now on 7.1.2 *seems* to work fine though. Should I take it that ALTER USER may indeed be used in a transaction block? I don't know if this was actually fixed or bugfixes to this might have something to do with the system trigger on pg_shadow, but I just thought I'll mention it in case it rings any more bells. I'm sure you know best. > The workaround I'd recommend to you for now is to use ALTER USER, not > UPDATE, to perform the second step in your function. So, how would I go about using the ALTER USER statement to clear out the valuntil value from the pg_shadow table? If I want to set an expiration date for the user, I can use a statement such as: ALTER USER test VALID UNTIL '2001-07-11 10:23:23-07' but if I want to clear the valuntil completely, how should I issue the ALTER USER statement? I have tried (with no success) the following so far: ALTER USER test VALID UNTIL NULL; ALTER USER test VALID UNTIL 'NULL'; ALTER USER test VALID UNTIL ''; Me failing to use the "ALTER USER" command successfully caused be to use the "UPDATE pg_shadow" instead. Thanks, -Kristis ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple(0,9) not found
Hi Tom, thanks for your feedback on this. On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found > > Hmm, are you trying to create triggers on pg_shadow? It's hard to see > how that message could come from an "UPDATE pg_shadow" otherwise. I'm not trying to explicitly create triggers on pg_shadow. None of the triggers/tables/sequences/functions I've created so far try to reference the pg_shadow in any way, so I don't *believe* (but I could be wrong) that I've even implicitly created a trigger on pg_shadow; > Triggers on system catalogs don't work very well, because they won't > be invoked as a side effect of system-initiated operations. In this > situation, it appears that the trigger code sees that the pg_shadow row > was inserted in the current transaction, so it tries to look up the row > in the list of pending trigger events --- and doesn't find an entry, > because CREATE USER didn't invoke the trigger code. Before I came across this error, the approach I was following was: -Call the WATSUSer_iou() plpgsql function that contained "CREATE USER" statements to create the new user -Call a plpgsql function after that, that contained "UPDATE pg_shadow" statements to update the "valuntil" field from the pg_shadow table. This approach was working fine. I get the feeling that this approach had the effect of each function call being considered a separate transaction, thus there were no errors when the "UPDATE pg_shadow" statement was called (the "CREATE USER" transaction was commited by that time) > In a perfect world we'd support user-defined triggers on the system > catalogs, but given the potential circularity problems, I doubt it's > going to happen real soon. I'd suggest finding another approach. Sounds reasonable. I can stick to the old approach. In case you guys ever need to debug/ look into this I have a schema and a sequence of commands executed that I'll keep around. Thanks for your help. -Kristis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple(0,9) not found
On 11 Jul 2001 12:07:09 -0400, Tom Lane wrote: > Kristis Makris <[EMAIL PROTECTED]> writes: > > On 11 Jul 2001 11:21:35 -0400, Tom Lane wrote: > >> Hmm, are you trying to create triggers on pg_shadow? It's hard to see > >> how that message could come from an "UPDATE pg_shadow" otherwise. > > > I'm not trying to explicitly create triggers on pg_shadow. None of the > > triggers/tables/sequences/functions I've created so far try to reference > > the pg_shadow in any way, so I don't *believe* (but I could be wrong) > > that I've even implicitly created a trigger on pg_shadow; > > Maybe you made a table with a foreign key reference to pg_shadow? I suspected that, grep'ed all my sql source for "pg_shadow" and the only place where I use the pg_shadow table is on the "UPDATE pg_shadow" statement. So if I haven't referenced the pg_shadow table, is there any other way I might have implicitly created a trigger for it? -Kristis ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[BUGS] your web site register is broken, cannot download Win32 distribution needed
Jill Gemmill ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description your web site register is broken, cannot download Win32 distribution needed Long Description (1) I went to http://www.ca.postgresql.org/ftpsite/odbc/download.html to download the Win32 Binary Distribution and it wants me to log in (anonymous login not accepted). (2) I could not find any information suggesting how to register. It would be helpful to have a link that took you to the registration page so that you didn't have to hunt around for it. (3) On your home page, there is a link: http://www.pgsql.com/register but it goes to an error page and there is no way to register. Here are the error messages caused by clicking on the register link: Warning: Unable to connect to PostgreSQL server: PQconnectPoll() -- connect() failed: Operation timed out Is the postmaster running (with -i) at 'db.hub.org' and accepting connections on TCP/IP port 5432? in /usr/local/www/php-global/global.php on line 10 Warning: Supplied argument is not a valid PostgreSQL link resource in /usr/local/www/php-global/global.php on line 15 Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/www/php-global/global.php on line 16 Warning: Supplied argument is not a valid PostgreSQL link resource in /usr/local/www/php-global/global.php on line 17 What I'm looking for is the Win32 Binary Distribution. Thanks. Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
