[BUGS] BUG #2914: SELECT query has no destination for result data
The following bug has been logged online:
Bug reference: 2914
Logged by: prasad
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: windows
Description:SELECT query has no destination for result data
Details:
hi...
i'm created a function
-- Function: "Get_Inbox"("Message_Posted_To" "varchar", "Message_Posted_By"
"varchar")
-- DROP FUNCTION "Get_Inbox"("Message_Posted_To" "varchar",
"Message_Posted_By" "varchar");
CREATE OR REPLACE FUNCTION "Get_Inbox"("Message_Posted_To" "varchar",
"Message_Posted_By" "varchar")
RETURNS SETOF "vw_getAllMessages" AS
$BODY$DECLARE
Message_Inbox_Type alias for $2;
BEGIN
IF Message_Inbox_Type = ' ' OR Message_Inbox_Type = null THEN
Select *
from "vw_getAllMessages"
where "Message_Posted_To" = $1
order by "Message_ID" desc;
ELSE
Select *
from "vw_getAllMessages"
where "Message_Posted_To" = $1
and "Message_Posted_By" = Message_Inbox_Type
order by "Message_ID" desc;
END IF;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION "Get_Inbox"("Message_Posted_To" "varchar",
"Message_Posted_By" "varchar") OWNER TO postgres;
where vw_getAllMessages is view which i created using
CREATE OR REPLACE VIEW "vw_getAllMessages" AS
SELECT "Messages"."Message_ID", "Messages"."Message_Text",
"Messages"."Message_Date", ("Client"."Client_First_Name"::text || ' '::text)
|| "Client"."Client_Last_Name"::text AS "Sender Name",
("Portfolio_Manager"."PM_User_Name"::text || ' '::text) ||
"Portfolio_Manager"."PM_Last_Name"::text AS "Receiver Name",
"Messages"."Message_Posted_By", "Messages"."Message_Posted_To",
"Messages"."Message_Context", "Messages"."Message_Reply_To",
"Messages"."Message_Replied_Date", "Messages"."Message_Subject",
"Messages"."Message_InboxReadFlag", "Messages"."Message_SentReadFlag",
"Messages"."Message_Inbox_DeleteFlag", "Messages"."Message_Sent_DeleteFlag"
FROM "Messages"
JOIN "Client" ON "Messages"."Message_Posted_By"::text =
"Client"."Client_Depository_Client_ID"::text
JOIN "Portfolio_Manager" ON "Messages"."Message_Posted_To"::text =
"Portfolio_Manager"."PM_Registration_No"::text
ORDER BY "Messages"."Message_ID" DESC;
ALTER TABLE "vw_getAllMessages" OWNER TO postgres;
when i do
Select * From "Get_Inbox"('INC',' ');
or
select * from "Get_Inbox"('INC', '1')
i get error
ERROR: SELECT query has no destination for result data
HINT: If you want to discard the results, use PERFORM instead.
CONTEXT: PL/pgSQL function "Get_Inbox" line 5 at SQL statement
pls help me as soon as posible..
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
[BUGS] BUG #3385: Memory leak
The following bug has been logged online: Bug reference: 3385 Logged by: Prasad Email address: [EMAIL PROTECTED] PostgreSQL version: Some Operating system: Windows 2003 Description:Memory leak Details: When both postgre and our server application run on the same windows 2003 server, a memory leak of 1 MB per day in Non paged kernel memory is observed. But if we run them on seperate servers, no leak is noticed. What could be the problem? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[BUGS] Integrity check
Hello, Please can you assist on following questions. * do you any tool to check postgreSQL database integrity check? * how do we confirm that dump file is proper data? * do you any doc to check the integrity of psql db? Venkat Prasad CREDIT SUISSE SCM Systems Support The signature level 4 Changi Business Park Singapore 486066 Phone +65 6306 0310 == Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==
RE: [BUGS] Inheritance of functions shows unexpected behaviour
Thank you. I hope the fix will implement polymorphism also, i.e., if a superclass and subclass define an identically-named function, then calling the function on all records of the superclass should transparently call the subclass's function for the records corresponding to the subclass. Regards, Ganesh -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 May 2001 6:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [BUGS] Inheritance of functions shows unexpected behaviour [EMAIL PROTECTED] writes: > Inheritance of functions shows unexpected behaviour I agree, plpgsql is doing the wrong thing here. Fix committed for 7.1.1. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[BUGS] Polymorphism in the PostgreSQL object model
Let's try to use polymorphism in PostgreSQL. This could be quite a useful feature in many situations. We create two tables, one inheriting from the other, then define functions with the same name on both of them, but with different internal logic. When we call the function on all records of the parent class, we want the subclass's variant to be called for the records corresponding to the subclass. However, the syntax of function definitions for a table expects the table name to be passed to the function as an argument. Therefore, it does not seem possible to transparently call different functions depending on the class of a record. Is there a way to do this? Is the syntax described in this example wrong? Create a class "employee" with key "id" and attributes "name" and "salary". Define a function "getTax()" that calculates tax as 20% of salary. Insert a record into it. Now create a subclass of "employee" called "manager" with one extra attribute "dept", and insert a record into it. Define a function "getTax()" for "manager" that calculates tax as 25% of salary. (Let managers pay more tax ;-) If we call "getTax()" on all records of "employee", we want regular employees to be shown taxed at 20%, but managers taxed at 25%. That is polymorphic behaviour. However, we are only able to invoke the employee version of getTax() on the employee table. Application of the manager version is only possible (explicitly) on the manager table. STEPS: 1. Run the script "setup.sql". This creates the two tables, populates them with a record each, and creates the "getTax()" functions. 2. Run the script "test1.sql". This invokes the "getTax()" method on the "employee" table for all records. Only the employee version is called. gettax 2 2 (2 rows) This is not what we want. We want "test1.sql" to return the following result (i.e. applying the manager variant of getTax() to the manager record): gettax 2 25000 <-- Manager variant of getTax() should be used here (2 rows) 3. Run the script "test2.sql". This explicitly invokes the "getTax()" method on the "manager" table for all records corresponding to the child class (manager). This calls the manager variant. gettax 25000 (1 row) This is correct, but we shouldn't have to call this variant explicitly. Polymorphism should cause it to be called implicitly. -- Start of scripts setup.sql: -- drop function getTax( t_employee ); drop function getTax( t_manager ); drop table t_manager; drop table t_employee; /* Employees have an id (key), a name and a salary. */ create table t_employee ( id int4 primary key, namevarchar(50) not null, salary float8 ); /* Managers are employees who manage a department. */ create table t_manager ( deptchar(2) ) inherits (t_employee); /* An ordinary employee. */ insert into t_employee values ( 1, 'Joe Bloggs', 10.0 ); /* A manager. */ insert into t_manager values ( 2, 'John Doe', 10.0, 'HR' ); /* A "method" defined for the "employee" class, which should be inherited by the "manager" class. */ create function getTax( t_employee ) returns float8 as ' declare emp alias for $1; begin return emp.salary * 0.2; end; ' language 'plpgsql'; /* A "method" defined for the "manager" class, which should override that defined for the "employee" class. */ create function getTax( t_manager ) returns float8 as ' declare mgr alias for $1; begin return mgr.salary * 0.25; end; ' language 'plpgsql'; test1.sql: -- /* Calculate tax for all employees. */ select getTax( t_employee ) from t_employee; test2.sql: -- /* The "method" for managers has to be explicitly called. The "method" defined for managers should be implicitly called even if the record is in the "employee" table. */ select getTax( t_manager ) from t_manager; -- End of scripts Ganesh Prasad Chief Web Architect Reply2(tm) Ltd Tel (+ 61 2) 9339 2912 == PRIVILEGED - PRIVATE AND CONFIDENTIAL This electronic mail is solely for the use of the addressee and may contain information which is confidential or privileged. If you are not the intended recipient any use, distribution, disclosure or copying of this information is prohibited. If you receive this electronic mail in error, please delete it and any attachments from your system immediately and notify the sender by electronic mail or using any of the following contact details Except as required
[BUGS] BUG #2916: SELECT query has no destination for result data
The following bug has been logged online:
Bug reference: 2916
Logged by: prasad mahit
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: windows
Description:SELECT query has no destination for result data
Details:
Hi have created a function
CREATE OR REPLACE FUNCTION "Get_Inbox"("Message_Posted_To" "varchar",
"Message_Posted_By" "varchar")
RETURNS SETOF "vw_getAllMessages" AS
$BODY$DECLARE
Message_Inbox_Type alias for $2;
BEGIN
IF Message_Inbox_Type = ' ' OR Message_Inbox_Type = null THEN
Select *
from "vw_getAllMessages"
where "Message_Posted_To" = $1
order by "Message_ID" desc;
ELSE
Select *
from "vw_getAllMessages"
where "Message_Posted_To" = $1
and "Message_Posted_By" = Message_Inbox_Type
order by "Message_ID" desc;
END IF;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION "Get_Inbox"("Message_Posted_To" "varchar",
"Message_Posted_By" "varchar") OWNER TO postgres;
where vw_getAllMessages is a view
CREATE OR REPLACE VIEW "vw_getAllMessages" AS
SELECT "Messages"."Message_ID", "Messages"."Message_Text",
"Messages"."Message_Date", ("Client"."Client_First_Name"::text || ' '::text)
|| "Client"."Client_Last_Name"::text AS "Sender Name",
("Portfolio_Manager"."PM_User_Name"::text || ' '::text) ||
"Portfolio_Manager"."PM_Last_Name"::text AS "Receiver Name",
"Messages"."Message_Posted_By", "Messages"."Message_Posted_To",
"Messages"."Message_Context", "Messages"."Message_Reply_To",
"Messages"."Message_Replied_Date", "Messages"."Message_Subject",
"Messages"."Message_InboxReadFlag", "Messages"."Message_SentReadFlag",
"Messages"."Message_Inbox_DeleteFlag", "Messages"."Message_Sent_DeleteFlag"
FROM "Messages"
JOIN "Client" ON "Messages"."Message_Posted_By"::text =
"Client"."Client_Depository_Client_ID"::text
JOIN "Portfolio_Manager" ON "Messages"."Message_Posted_To"::text =
"Portfolio_Manager"."PM_Registration_No"::text
ORDER BY "Messages"."Message_ID" DESC;
ALTER TABLE "vw_getAllMessages" OWNER TO postgres;
when i try to run this
select * from "Get_Inbox" ('INC', ' ')
i get an error
ERROR: SELECT query has no destination for result data
HINT: If you want to discard the results, use PERFORM instead.
CONTEXT: PL/pgSQL function "Get_Inbox" line 5 at SQL statement
pls Help
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
[BUGS] Regarding Bug
Hello I am pati presently working iin research oraganisation(Fraunhofer),Germany.Recently i ahve deployed a web application connecting to the database postgre sql. When i am connecting to the database i am getting the error of postgresql.stream.flush and postgresql.stream.io some times. please let me know how to solve it. Thanking you pati ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[BUGS] BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
The following
bug has been logged online:Bug reference:
1726Logged by: Prasad
DuggineniEmail address: [EMAIL PROTECTED]PostgreSQL version: 8.03Operating system: Redhat Linux
9.0Description: Whenever i reboot
my tables indexes is gettingcorrupted.Details: It is throwing
the following ERROR "error index "clusters_pkey" is not a btree"I have
to reindex the tables every time whenever i reboot.Jun 22
10:52:56 lab5md9181 postgres[947]: [45-1] 2005-06-22 10:52:56 EDT LOG:
statement: select gethost()Jun 22 10:52:56 lab5md9181 postgres[947]:
[46-1] 2005-06-22 10:52:56 EDT LOG: statement: select
getphysicalip()Jun 22 10:52:56 lab5md9181 postgres[947]: [47-1] 2005-06-22
10:52:56 EDT LOG: statement: insert into Clusters (clusterID,
clusterName, clusterType, clusterState,Jun 22 10:52:56 lab5md9181
postgres[947]: [47-2] replicationState,
workingMode, maxClusterBw, gkType) values('lab5md9181',
'lab5md9181', 1, 0, 0, 1, 0, 0)Jun 22 10:52:56 lab5md9181 postgres[947]:
[48-1] 2005-06-22 10:52:56 EDT ERROR: index "clusters_pkey" is not
a btreeJun 22 10:52:56 lab5md9181 postgres[953]: [2-1] 2005-06-22 10:52:56
EDT LOG:statement:Jun 22 10:52:56 lab5md9181 postgres[953]:
[3-1] 2005-06-22 10:52:56 EDT LOG:statement: set DateStyle to
'ISO'Jun 22 10:52:56 lab5md9181 postgres[953]: [4-1] 2005-06-22 10:52:56 EDT
LOG:statement:Jun 22 10:52:56 lab5md9181 postgres[953]: [5-1]
2005-06-22 10:52:56 EDT LOG:statement: set geqo to 'OFF'Jun 22
10:52:56 lab5md9181 postgres[953]: [6-1] 2005-06-22 10:52:56 EDT
LOG:statement:Jun 22 10:52:56 lab5md9181 postgres[953]: [7-1]
2005-06-22 10:52:56 EDT LOG:statement: set ksqo to 'ON'Jun 22
10:52:56 lab5md9181 postgres[953]: [8-1] 2005-06-22 10:52:56 EDT
ERROR:unrecognized configuration parameter "ksqo"Jun 22 10:52:56
lab5md9181 postgres[953]: [9-1] 2005-06-22 10:52:56 EDT
LOG:statement: select oid from pg_type where typname='lo'Jun 22
10:52:56 lab5md9181 postgres[953]: [10-1] 2005-06-22 10:52:56 EDT LOG:
statement: select version()Jun 22 10:52:56 lab5md9181 postgres[953]:
[11-1] 2005-06-22 10:52:56 EDT LOG: statement: insert into
Clusters (clusterID, clusterName, clusterType, clusterState,Jun 22
10:52:56 lab5md9181 postgres[953]: [11-2] replicationState,
workingMode, maxClusterBw, gkType) values('lab5md9181',
'lab5md9181', 1, 0, 0, 1, 0, 0)Jun 22 10:52:56 lab5md9181 postgres[953]:
[12-1] 2005-06-22 10:52:56 EDT ERROR: index "clusters_pkey" is not
a btree
[BUGS] BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
The following bug has been logged online:
Bug reference: 1726
Logged by: Prasad Duggineni
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.03
Operating system: Redhat Linux 9.0
Description:Whenever i reboot my tables indexes is getting
corrupted.
Details:
It is throwing
the following ERROR "error index "clusters_pkey" is not a btree"
I have to reindex the tables every time whenever i reboot.
Jun 22 10:52:56 lab5md9181 postgres[947]: [45-1] 2005-06-22 10:52:56 EDT
LOG: s
tatement: select gethost()
Jun 22 10:52:56 lab5md9181 postgres[947]: [46-1] 2005-06-22 10:52:56 EDT
LOG: s
tatement: select getphysicalip()
Jun 22 10:52:56 lab5md9181 postgres[947]: [47-1] 2005-06-22 10:52:56 EDT
LOG: s
tatement: insert into Clusters (clusterID, clusterName, clusterType,
clusterStat
e,
Jun 22 10:52:56 lab5md9181 postgres[947]: [47-2] replicationState,
workingMode,
maxClusterBw, gkType) values('lab5md9181', 'lab5md9181', 1, 0, 0, 1, 0, 0)
Jun 22 10:52:56 lab5md9181 postgres[947]: [48-1] 2005-06-22 10:52:56 EDT
ERROR:
index "clusters_pkey" is not a btree
Jun 22 10:52:56 lab5md9181 postgres[953]: [2-1] 2005-06-22 10:52:56 EDT LOG:
st
atement:
Jun 22 10:52:56 lab5md9181 postgres[953]: [3-1] 2005-06-22 10:52:56 EDT LOG:
st
atement: set DateStyle to 'ISO'
Jun 22 10:52:56 lab5md9181 postgres[953]: [4-1] 2005-06-22 10:52:56 EDT LOG:
st
atement:
Jun 22 10:52:56 lab5md9181 postgres[953]: [5-1] 2005-06-22 10:52:56 EDT LOG:
st
atement: set geqo to 'OFF'
Jun 22 10:52:56 lab5md9181 postgres[953]: [6-1] 2005-06-22 10:52:56 EDT LOG:
st
atement:
Jun 22 10:52:56 lab5md9181 postgres[953]: [7-1] 2005-06-22 10:52:56 EDT LOG:
st
atement: set ksqo to 'ON'
Jun 22 10:52:56 lab5md9181 postgres[953]: [8-1] 2005-06-22 10:52:56 EDT
ERROR:
unrecognized configuration parameter "ksqo"
Jun 22 10:52:56 lab5md9181 postgres[953]: [9-1] 2005-06-22 10:52:56 EDT LOG:
st
atement: select oid from pg_type where typname='lo'
Jun 22 10:52:56 lab5md9181 postgres[953]: [10-1] 2005-06-22 10:52:56 EDT
LOG: s
tatement: select version()
Jun 22 10:52:56 lab5md9181 postgres[953]: [11-1] 2005-06-22 10:52:56 EDT
LOG: s
tatement: insert into Clusters (clusterID, clusterName, clusterType,
clusterStat
e,
Jun 22 10:52:56 lab5md9181 postgres[953]: [11-2] replicationState,
workingMode,
maxClusterBw, gkType) values('lab5md9181', 'lab5md9181', 1, 0, 0, 1, 0, 0)
Jun 22 10:52:56 lab5md9181 postgres[953]: [12-1] 2005-06-22 10:52:56 EDT
ERROR:
index "clusters_pkey" is not a btree
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Re: [BUGS] possible bug...
Try turning the enforcement mode off. - Original Message - From: "SriKumar Kareti" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 21, 2005 2:49 PM Subject: [BUGS] possible bug... Hello! I am trying to install postgres 8.0.3 from rpms. [EMAIL PROTECTED] ~]$ rpm -qa | grep postgres postgresql-8.0.3-1PGDG postgresql-server-8.0.3-1PGDG postgresql-libs-8.0.3-1PGDG [EMAIL PROTECTED] ~]$ After I install the RPMs, when I try to initdb I run into problems. I did set the data directory to belong to "postgres" and I am trying to initdb as "postgres". I have read through several postings and have not seen anyone have the same problem. Thank you for your help. SriKumar. Here is the run: bash-3.00$ ls -l /usr/local/ total 88 drwxr-xr-x 2 root root 4096 Apr 28 00:09 bin drwxr-xr-x 2 root root 4096 Apr 28 00:09 etc drwxr-xr-x 2 root root 4096 Apr 28 00:09 games drwxr-xr-x 2 root root 4096 Apr 28 00:09 include drwxr-xr-x 2 root root 4096 Apr 28 00:09 lib drwxr-xr-x 2 root root 4096 Apr 28 00:09 libexec drwxr-xr-x 3 root root 4096 Sep 16 10:01 man drwxr-xr-x 3 postgres postgres 4096 Sep 20 09:21 pgsql drwxr-xr-x 2 root root 4096 Apr 28 00:09 sbin drwxr-xr-x 4 root root 4096 Sep 14 16:59 share drwxr-xr-x 2 root root 4096 Apr 28 00:09 src bash-3.00$ ls -l /usr/local/pgsql/ total 8 drwx-- 2 postgres postgres 4096 Sep 21 13:37 data bash-3.00$ whoami postgres bash-3.00$ initdb -D /usr/local/pgsql/data/ The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.UTF-8. The default database encoding has accordingly been set to UNICODE. initdb: directory "/usr/local/pgsql/data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/usr/local/pgsql/data" or run initdb with an argument other than "/usr/local/pgsql/data". bash-3.00$ rm -R /usr/local/pgsql/data/* bash-3.00$ initdb -D /usr/local/pgsql/data/ The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.UTF-8. The default database encoding has accordingly been set to UNICODE. fixing permissions on existing directory /usr/local/pgsql/data ... ok creating directory /usr/local/pgsql/data/global ... ok creating directory /usr/local/pgsql/data/pg_xlog ... ok creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok creating directory /usr/local/pgsql/data/pg_clog ... ok creating directory /usr/local/pgsql/data/pg_subtrans ... ok creating directory /usr/local/pgsql/data/base ... ok creating directory /usr/local/pgsql/data/base/1 ... ok creating directory /usr/local/pgsql/data/pg_tblspc ... ok selecting default max_connections ... 10 selecting default shared_buffers ... 50 creating configuration files ... ok creating template1 database in /usr/local/pgsql/data/base/1 ... child process exited with exit code 1 initdb: removing contents of data directory "/usr/local/pgsql/data" bash-3.00$ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[BUGS] BUG #2182: Internal account lookup failure:
The following bug has been logged online: Bug reference: 2182 Logged by: Anantha Prasad Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2-1 Operating system: Win2000 Prof Description:Internal account lookup failure: Details: I had not installed PostGreSQL on this computer before. When I use the installer, it gives the foll. message and rolls back the installation. "Internal account lookup failure: No mapping between account names and security IDs was done." Tried with other user names etc. but cannot proceed. ---(end of broadcast)--- TIP 6: explain analyze is your friend
[BUGS] installation problem
I am finding it difficult to install postgresql7.3.2 on linux advanced server. Repeatedly its asking for some or other files. Please let me know the exact procedure and what are the dependency files required for the same. bye guruprasad ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[BUGS] pg_connect() problem
After upgrading postgres from 7.1 to 7.3.2 PHP 4.0.6 was working fine but after upgrading PHP from 4.0.6 to 4.3.2 version it was unable to connect to database as pg_connect() was not working. bye guru ---(end of broadcast)--- TIP 8: explain analyze is your friend
[BUGS] date validation problem
sir,
in postgresql 7.3.2 when we are trying to query like
select to_date('66555','ddmm');
the output is
5559-09-06
it is not validating the day and month and unknown format
is the output..
any help regarding this is greatful...
thank you
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[BUGS] decimal to integer, number to words
Hi, How to convert number format (with decimal) into integer only ex:to conver 100.00 to 100. One more Do we have any code to convert number to words ex: 1234 to one thousand two hundredn and thirty four. (I want to use for indian currency only, i will use crores instead of billions) Thank you ---(end of broadcast)--- TIP 8: explain analyze is your friend
[BUGS] (none)
Hi, How to convert number format (with decimal) into integer only ex:to conver 100.00 to 100. One more Do we have any code to convert number to words ex: 1234 to one thousand two hundredn and thirty four. (I want to use for indian currency only, i will use crores instead of billions) Thank you ---(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] substring problem
select trn_id,substr(hoa_id,1,13) from tbill_master where substr(hoa _id,1,13)='2202031040006'; trn_id |substr +--- 25001203000416 | 2202031040006 25001203000417 | 2202031040006 25001203000418 | 2202031040006 25001203000419 | 2202031040006 25001203000420 | 2202031040006 25001203000421 | 2202031040006 25001203000422 | 2202031040006 25001203000536 | 2202031040006 and select trn_id,substr(hoa_id,0,14) from tbill_master where substr(hoa _id,0,14)='2202031040006'; trn_id |substr +--- 25001203000416 | 2202031040006 25001203000417 | 2202031040006 25001203000418 | 2202031040006 25001203000419 | 2202031040006 25001203000420 | 2202031040006 25001203000421 | 2202031040006 25001203000422 | 2202031040006 25001203000536 | 2202031040006 both give the same result how? Is it query problem or postgress substring problem please clarify. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[BUGS] socket error while creating database in windows98
We have installed beta version of postgres 7.2.1 on windows98. Initdb went through. while createing c:\>pgsql>creatdb sample following error message is being displayed psql.exe: cound not connect to server: socket error, No decription available (0X274D) is the server running on host localhost and accepting TCP/IP connection on port 5432. Please kindly help us in solving this problem. regards guru ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[BUGS] Unable to run PostgreSQL 8 beta 3 on Windows XP Home
Hi, I downloaded PostgreSQL 8 beta 3 for my PC running Windows XP Home. Before installing PostgreSQL, I first created a normal user called "postgres" with no administrator privileges. Then, when setting up the software, I specified this user to run under. Unfortunately, I could never run postmaster even as "postgres" because it was failing to find "postgres" under "Power Users". I have no Power Users on my PC, only Administrator and Normal users. Please ignore this bug report if the problem has already been fixed. Regards, Ganesh Prasad ---(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
