pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery
31+ messages / 25 participants
[nested] [flat]
* Query
@ 2001-03-28 11:54 Mahesh Guleria <mahesh@himline.com>
0 siblings, 0 replies; 31+ messages in thread
From: Mahesh Guleria @ 2001-03-28 11:54 UTC (permalink / raw)
To: pgsql-admin
Is JDBC Driver 2.0 compatible with Postgres ???
-Mahesh Guleria
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2001-08-24 14:54 Vida Luz Arista <vlal@ideay.net.ni>
2001-08-24 15:59 ` Re: Query Richard Bayet <bayet@enseirb.fr>
2001-08-24 16:09 ` Re: Query Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 2 replies; 31+ messages in thread
From: Vida Luz Arista @ 2001-08-24 14:54 UTC (permalink / raw)
To: pgsql-admin
Hi All, I have two questions
1- I have a query but this is very slow, I need to acelerate the
consult, this result sill be show in the web.
My query is:
select user, descripcion from client where login not in (select
distinct(usr_cliente) from conexion where fecha between '$date_begin' and
'$date_end') order by user"
How can I to acelerate this consult?
2- I made this function:
CREATE FUNCTION list(date,date) RETURNS user
AS 'select distinct(usr_cliente) from conexion where fecha between
$date_begin and $date_end' LANGUAGE 'sql';
When I execute a query to this function like:
select select listado('08-10-2001', '08-13-2001') as user;
the result is just 1 row, however If I to execute the query this return
300 rows, why the function only return one row?
Thanks in advanced,
Regards,
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2001-08-24 14:54 Query Vida Luz Arista <vlal@ideay.net.ni>
@ 2001-08-24 15:59 ` Richard Bayet <bayet@enseirb.fr>
1 sibling, 0 replies; 31+ messages in thread
From: Richard Bayet @ 2001-08-24 15:59 UTC (permalink / raw)
To: Vida Luz Arista <vlal@ideay.net.ni>; +Cc: pgsql-admin
Vida Luz Arista a écrit :
> Hi All, I have two questions
>
> 1- I have a query but this is very slow, I need to acelerate the
> consult, this result sill be show in the web.
>
> My query is:
>
> select user, descripcion from client where login not in (select
> distinct(usr_cliente) from conexion where fecha between '$date_begin' and
> '$date_end') order by user"
>
> How can I to acelerate this consult?
>
> 2- I made this function:
>
> CREATE FUNCTION list(date,date) RETURNS user
> AS 'select distinct(usr_cliente) from conexion where fecha between
> $date_begin and $date_end' LANGUAGE 'sql';
>
> When I execute a query to this function like:
> select select list('08-10-2001', '08-13-2001') as user;
>
> the result is just 1 row, however If I to execute the query this return
> 300 rows, why the function only return one row?
>
The query's returning the exact opposite of your function, so if you have
301 rows in your table and the function returns you 1, the query'll get 300
:)
select user, descripcion from client where login not in (select
distinct(usr_cliente) from conexion where fecha between '$date_begin' and
'$date_end') order by user"
is equivalent to:
select user, descripcion from client where login not in (select
list('$date_begin', '$date_end'))
PS: a misused "not in" clause can result in very poor performances (it
depends actually of your table contents) : if "everything that is not ..."
is huge, it's quicker to get "everything that is ..." :)
>
> Thanks in advanced,
>
> Regards,
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2001-08-24 14:54 Query Vida Luz Arista <vlal@ideay.net.ni>
@ 2001-08-24 16:09 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
1 sibling, 0 replies; 31+ messages in thread
From: Stephan Szabo @ 2001-08-24 16:09 UTC (permalink / raw)
To: Vida Luz Arista <vlal@ideay.net.ni>; +Cc: pgsql-admin
On Fri, 24 Aug 2001, Vida Luz Arista wrote:
> Hi All, I have two questions
>
> 1- I have a query but this is very slow, I need to acelerate the
> consult, this result sill be show in the web.
>
> My query is:
>
> select user, descripcion from client where login not in (select
> distinct(usr_cliente) from conexion where fecha between '$date_begin' and
> '$date_end') order by user"
See FAQ entry 4.23. Short form is convert the query to use EXISTS rather
than IN.
> 2- I made this function:
>
> CREATE FUNCTION list(date,date) RETURNS user
> AS 'select distinct(usr_cliente) from conexion where fecha between
> $date_begin and $date_end' LANGUAGE 'sql';
>
> When I execute a query to this function like:
> select select listado('08-10-2001', '08-13-2001') as user;
>
> the result is just 1 row, however If I to execute the query this return
> 300 rows, why the function only return one row?
I think you'd need to say setof user as the return type, although I'm not
100% sure that'll give you back something meaningful (It gives me
something meaningful on my 7.2 devel machine, but I don't have an earlier
system to test on)
^ permalink raw reply [nested|flat] 31+ messages in thread
* query
@ 2002-11-15 20:47 Jodi Kanter <jkanter@virginia.edu>
0 siblings, 0 replies; 31+ messages in thread
From: Jodi Kanter @ 2002-11-15 20:47 UTC (permalink / raw)
To: pgsql-admin
I have a query that pulls two fields across three tables such that the results are in two columns:
layout.probe spot.signal
value1 some value
value2 some value
value3 some value
value1 some value
value2 some value
value3 some value
I have three tables: spot, measurement, layout. The measurement table exists in the query because it sits between the spot and layout tables which hold the data that I want.
My goal is to produce a report that lists the signal values in separate columns (instead of having the probe value repeat) such that the results look like this:
layout.probe signal signal
value1 some value some value
value2 some value some value
value3 some value some value
What is the most efficient way to do this? I assume it would require placing the data in temporary tables? Is there some complicate query design that could handle this?
Please contact me if my description is not clear.
Thank you
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
^ permalink raw reply [nested|flat] 31+ messages in thread
* query
@ 2004-01-05 14:20 ma101kg@gold.ac.uk
2004-01-07 05:07 ` Re: query A.Bhuvaneswaran <bhuvaneswaran@bksystems.co.in>
2004-01-07 05:13 ` Re: query A.Bhuvaneswaran <bhuvan@symonds.net>
0 siblings, 2 replies; 31+ messages in thread
From: ma101kg@gold.ac.uk @ 2004-01-05 14:20 UTC (permalink / raw)
To: pgsql-admin
Hi,
could you please let me know how to represent an image when creating a data
table using
postgresql
thanks
ganesh
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: query
2004-01-05 14:20 query ma101kg@gold.ac.uk
@ 2004-01-07 05:07 ` A.Bhuvaneswaran <bhuvaneswaran@bksystems.co.in>
1 sibling, 0 replies; 31+ messages in thread
From: A.Bhuvaneswaran @ 2004-01-07 05:07 UTC (permalink / raw)
To: ma101kg@gold.ac.uk; +Cc: pgsql-admin
> Hi,
> could you please let me know how to represent an image when creating a data
> table using
> postgresql
Refer the documentation for details on lo_import and lo_export
functions. It must help you.
regards,
bhuvaneswaran
---
Disclaimer: http://www.bksystems.co.in/email-policy/disclaimer.txt
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: query
2004-01-05 14:20 query ma101kg@gold.ac.uk
@ 2004-01-07 05:13 ` A.Bhuvaneswaran <bhuvan@symonds.net>
1 sibling, 0 replies; 31+ messages in thread
From: A.Bhuvaneswaran @ 2004-01-07 05:13 UTC (permalink / raw)
To: ma101kg@gold.ac.uk; +Cc: pgsql-admin
> could you please let me know how to represent an image when creating a data
> table using
> postgresql
Refer the documentation for details on lo_import and lo_export
functions. It must help you.
regards,
bhuvaneswaran
Attachments:
signature.asc (application/pgp-signature, 231B) download
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2004-01-05 14:26 ma101csn@gold.ac.uk
0 siblings, 0 replies; 31+ messages in thread
From: ma101csn@gold.ac.uk @ 2004-01-05 14:26 UTC (permalink / raw)
To: pgsql-admin
Hello!
Could you please let me know what is the data type for an image in
postgresql.
Thank you
Catherine
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2004-05-14 13:12 Jørgen Lie Pettersen <jorgen.lie.pettersen@isys.no>
2004-05-16 19:31 ` Re: Query Jim Seymour <jseymour@LinxNet.com>
0 siblings, 1 reply; 31+ messages in thread
From: Jørgen Lie Pettersen @ 2004-05-14 13:12 UTC (permalink / raw)
To: pgsql-admin
Dear Sir or Madam!
I am a student at a university in Norway, and I'm working on a project
where I shall be a "seller" for PostgreSQL.
I was just wondering, why the name PostgreSQL? Is it a shortening for
something?
Kind regards,
Jørgen Lie Pettersen
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2004-05-14 13:12 Query Jørgen Lie Pettersen <jorgen.lie.pettersen@isys.no>
@ 2004-05-16 19:31 ` Jim Seymour <jseymour@LinxNet.com>
0 siblings, 0 replies; 31+ messages in thread
From: jseymour@LinxNet.com @ 2004-05-16 19:31 UTC (permalink / raw)
To: pgsql-admin
=?iso-8859-15?Q?J=F8rgen_Lie_Pettersen?= <jorgen.lie.pettersen@isys.no> wrote:
>
> Dear Sir or Madam!
>
> I am a student at a university in Norway, and I'm working on a project
> where I shall be a "seller" for PostgreSQL.
> I was just wondering, why the name PostgreSQL? Is it a shortening for
> something?
http://www.postgresql.org/docs/faqs/FAQ.html#1.1
Jim
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2006-05-09 04:45 mindtree.chandana@daimlerchrysler.com
2006-05-10 08:02 ` Re: Query Andy Shellam <andy.shellam@mailnetwork.co.uk>
0 siblings, 1 reply; 31+ messages in thread
From: mindtree.chandana@daimlerchrysler.com @ 2006-05-09 04:45 UTC (permalink / raw)
To: pgsql-admin
Hi ,
Is it possible to create a local copy of PostgreSQL database that is
present in server even without installation of PostgreSQL in the local
machine.?
Thanks in advance
Regards
Chandana
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2006-05-09 04:45 Query mindtree.chandana@daimlerchrysler.com
@ 2006-05-10 08:02 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
0 siblings, 0 replies; 31+ messages in thread
From: Andy Shellam @ 2006-05-10 08:02 UTC (permalink / raw)
To: mindtree.chandana@daimlerchrysler.com; +Cc: pgsql-admin
You could copy the database cluster for sure, but you wouldn't be able to
read/write any data to it without PostgreSQL being installed.
If you're talking about a machine accessing a database on a different
PostgreSQL server, you need the ODBC drivers (for Windows) or client
libraries (Linux.)
Andy
_____
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
mindtree.chandana@daimlerchrysler.com
Sent: 09 May 2006 5:45 am
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Query
Hi ,
Is it possible to create a local copy of PostgreSQL database that is
present in server even without installation of PostgreSQL in the local
machine.?
Thanks in advance
Regards
Chandana
!DSPAM:14,4461541734491215912632!
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2008-06-25 09:51 kartik <kartik@v2technocrats.com>
2008-06-26 04:31 ` Re: Query Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 1 reply; 31+ messages in thread
From: kartik @ 2008-06-25 09:51 UTC (permalink / raw)
To: pgsql-admin
Hello there,
I was using oracle till now but now I have shifted to postgresql. Postgresql
is completely new for me.
I just want to know that there is sga(System Global Area) defined in oracle
, so do we have the same thing in postgresql.. and if its there how to
configure it.
And my second doubt is how to let other computer access the postgresql
server. What should be the settings done in the config files/.
Thanks
Waiting for your reply.
Kartik
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-25 09:51 Query kartik <kartik@v2technocrats.com>
@ 2008-06-26 04:31 ` Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 0 replies; 31+ messages in thread
From: Vishal Arora @ 2008-06-26 04:31 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; pgsql-admin
And my second doubt is how to let other computer access the postgresql server. What should be the settings done in the config files/.
- You need to make entries, for the clients you want to connect to the server, in pg_hba.conf file. you can search for the file default location is data directory under postgres installation. for more information refer to postgresql manual.
http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
- Vishal
Thanks
Waiting for your reply.
Kartik
_________________________________________________________________
No Harvard, No Oxford. We are here. Find out !!
http://ss1.richmedia.in/recurl.asp?pid=500=
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2008-06-25 10:01 kartik <kartik@v2technocrats.com>
2008-06-25 14:50 ` Re: Query Travis Smith <tsmith@optionshouse.com>
2008-06-25 15:11 ` Re: Query Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 2 replies; 31+ messages in thread
From: kartik @ 2008-06-25 10:01 UTC (permalink / raw)
To: pgsql-admin
Hello there,
I am installing postgresql on debian os.
So can anyone please tell me how to configure it .. and I have few windows
clients that needs to be connected to the database server.. can anyone
please tell me something about how to configure the server and the client
.
thanks
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-25 10:01 Query kartik <kartik@v2technocrats.com>
@ 2008-06-25 14:50 ` Travis Smith <tsmith@optionshouse.com>
1 sibling, 0 replies; 31+ messages in thread
From: Travis Smith @ 2008-06-25 14:50 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; pgsql-admin
Out the box installation will get you a system up and running, from there you have a choice of tools you can use such as Navicat to connect to the database. I am assuming you have networked machines. You then can create a new database, tables and populate them with data. The Oracle SGA is truthfully an Oracle feature as it is compromised of a group of Oracle specific structures. A lot of the functionality you get from a SGA in Oracle is closely tied to the operating system with postgres.
Configuration files you can find in the data directory of your postgres installation, postgres.conf would be the most mappable conf file to a init.ora
Running the unix command find postgres.conf will be helpful.
________________________________
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of kartik
Sent: Wednesday, June 25, 2008 5:01 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Query
Hello there,
I am installing postgresql on debian os.
So can anyone please tell me how to configure it .. and I have few windows clients that needs to be connected to the database server.. can anyone please tell me something about how to configure the server and the client
...
thanks
_______________________________________________________
The information in this email or in any file attached
hereto is intended only for the personal and confiden-
tial use of the individual or entity to which it is
addressed and may contain information that is propri-
etary and confidential. If you are not the intended
recipient of this message you are hereby notified that
any review, dissemination, distribution or copying of
this message is strictly prohibited. This communica-
tion is for information purposes only and should not
be regarded as an offer to sell or as a solicitation
of an offer to buy any financial product. Email trans-
mission cannot be guaranteed to be secure or error-
free. P6070214
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-25 10:01 Query kartik <kartik@v2technocrats.com>
@ 2008-06-25 15:11 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-06-25 17:17 ` Re: Query Carol Walter <walterc@indiana.edu>
1 sibling, 1 reply; 31+ messages in thread
From: Kevin Grittner @ 2008-06-25 15:11 UTC (permalink / raw)
To: pgsql-admin; kartik <kartik@v2technocrats.com>
>>> "kartik" <kartik@v2technocrats.com> wrote:
> can anyone please tell me how to configure it .. and I have few
windows
> clients that needs to be connected to the database server.. can
anyone
> please tell me something about how to configure the server and the
client
The PostgreSQL documentation is quite good. Start here:
http://www.postgresql.org/docs/8.3/interactive/index.html
You might want to read through the tutorial first.
Regarding the connections from other machines, see:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-connection.html
-Kevin
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-25 10:01 Query kartik <kartik@v2technocrats.com>
2008-06-25 15:11 ` Re: Query Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2008-06-25 17:17 ` Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 31+ messages in thread
From: Carol Walter @ 2008-06-25 17:17 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin; kartik <kartik@v2technocrats.com>
Greetings,
While the online documentation is the definitive document, I've found
the Apress book Beginning Databases with PostgreSQL: From Novice to
Professional very helpful. There is a section on connecting to
computers using a variety of languages.
Carol Walter
On Jun 25, 2008, at 11:11 AM, Kevin Grittner wrote:
>>>> "kartik" <kartik@v2technocrats.com> wrote:
>
>> can anyone please tell me how to configure it .. and I have few
> windows
>> clients that needs to be connected to the database server.. can
> anyone
>> please tell me something about how to configure the server and the
> client
>
> The PostgreSQL documentation is quite good. Start here:
>
> http://www.postgresql.org/docs/8.3/interactive/index.html
>
> You might want to read through the tutorial first.
>
> Regarding the connections from other machines, see:
>
> http://www.postgresql.org/docs/8.3/interactive/runtime-config-
> connection.html
>
> -Kevin
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2008-06-27 05:33 kartik <kartik@v2technocrats.com>
2008-06-27 20:12 ` Re: Query Travis Smith <tsmith@optionshouse.com>
2008-06-27 20:14 ` Re: Query Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 2 replies; 31+ messages in thread
From: kartik @ 2008-06-27 05:33 UTC (permalink / raw)
To: pgsql-admin
Hello there,
Can anyone tell me the differences between postgresql 8.1 and postgresql
8.3.3
Thanks
Waiting for your reply
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-27 05:33 Query kartik <kartik@v2technocrats.com>
@ 2008-06-27 20:12 ` Travis Smith <tsmith@optionshouse.com>
1 sibling, 0 replies; 31+ messages in thread
From: Travis Smith @ 2008-06-27 20:12 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; pgsql-admin
These docs are pretty good... .. release notes..
http://www.postgresql.org/docs/8.3/static/release.html
________________________________
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of kartik
Sent: Friday, June 27, 2008 12:33 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Query
Hello there,
Can anyone tell me the differences between postgresql 8.1 and postgresql 8.3.3
Thanks
Waiting for your reply
_______________________________________________________
The information in this email or in any file attached
hereto is intended only for the personal and confiden-
tial use of the individual or entity to which it is
addressed and may contain information that is propri-
etary and confidential. If you are not the intended
recipient of this message you are hereby notified that
any review, dissemination, distribution or copying of
this message is strictly prohibited. This communica-
tion is for information purposes only and should not
be regarded as an offer to sell or as a solicitation
of an offer to buy any financial product. Email trans-
mission cannot be guaranteed to be secure or error-
free. P6070214
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-27 05:33 Query kartik <kartik@v2technocrats.com>
@ 2008-06-27 20:14 ` Jeff Frost <jeff@frostconsultingllc.com>
1 sibling, 0 replies; 31+ messages in thread
From: Jeff Frost @ 2008-06-27 20:14 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; +Cc: pgsql-admin
kartik wrote:
>
> Hello there,
>
> Can anyone tell me the differences between postgresql 8.1 and
> postgresql 8.3.3
>
> Thanks
>
> Waiting for your reply
>
Sure, just have a look here:
http://www.postgresql.org/docs/8.3/static/release-8-3.html
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2008-06-30 09:55 kartik <kartik@v2technocrats.com>
2008-07-02 17:36 ` Re: Query Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 1 reply; 31+ messages in thread
From: kartik @ 2008-06-30 09:55 UTC (permalink / raw)
To: pgsql-admin
Hello ,
I am a beginner for postgresql. I want to activate a constraint for some
time and after that I want to deactivate it.
Or
I want to know whether a particular constraint exists and whether its
activated or not.
Waiting for yr reply
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-06-30 09:55 Query kartik <kartik@v2technocrats.com>
@ 2008-07-02 17:36 ` Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 0 replies; 31+ messages in thread
From: Lennin Caro @ 2008-07-02 17:36 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, kartik <kartik@v2technocrats.com>
--- On Mon, 6/30/08, kartik <kartik@v2technocrats.com> wrote:
> From: kartik <kartik@v2technocrats.com>
> Subject: [ADMIN] Query
> To: pgsql-admin@postgresql.org
> Date: Monday, June 30, 2008, 9:55 AM
> Hello ,
>
> I am a beginner for postgresql. I want to activate a
> constraint for some
> time and after that I want to deactivate it.
>
>
>
> Or
>
>
>
> I want to know whether a particular constraint exists and
> whether its
> activated or not.
>
>
>
> Waiting for yr reply
triggers and status
select tgname,tgenabled from pg_trigger
^ permalink raw reply [nested|flat] 31+ messages in thread
* query
@ 2008-07-02 14:59 kartik <kartik@v2technocrats.com>
2008-07-02 17:25 ` Re: query Alvaro Herrera <alvherre@commandprompt.com>
2008-07-02 17:28 ` Re: query paul socha <pawel.socha@gmail.com>
2008-07-02 17:33 ` Re: query Devrim GÜNDÜZ <devrim@gunduz.org>
2008-07-02 17:36 ` Re: query Lennin Caro <lennin.caro@yahoo.com>
0 siblings, 4 replies; 31+ messages in thread
From: kartik @ 2008-07-02 14:59 UTC (permalink / raw)
To: pgsql-admin
Hello there,
I am new to postgresql
I have installed postgresql -8.3.3 on debian etch os
While connecting to the db by the pgadmin I am getting the following error
1: ERROR: column op.oprlsortop does not exist at character 773
2: ERROR: column "opcamid" does not exist at character 170
Can anyone please help me to debug this error
Regards,kartik
Waiting for your reply
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: query
2008-07-02 14:59 query kartik <kartik@v2technocrats.com>
@ 2008-07-02 17:25 ` Alvaro Herrera <alvherre@commandprompt.com>
3 siblings, 0 replies; 31+ messages in thread
From: Alvaro Herrera @ 2008-07-02 17:25 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; +Cc: pgsql-admin
kartik wrote:
> Hello there,
>
> I am new to postgresql
>
> I have installed postgresql -8.3.3 on debian etch os
>
> While connecting to the db by the pgadmin I am getting the following error
>
> 1: ERROR: column op.oprlsortop does not exist at character 773
Update to a newer pgadmin.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: query
2008-07-02 14:59 query kartik <kartik@v2technocrats.com>
@ 2008-07-02 17:28 ` paul socha <pawel.socha@gmail.com>
3 siblings, 0 replies; 31+ messages in thread
From: paul socha @ 2008-07-02 17:28 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; +Cc: pgsql-admin
On 2008-07-02, at 16:59, kartik wrote:
> Hello there,
> I am new to postgresql
> I have installed postgresql -8.3.3 on debian etch os
> While connecting to the db by the pgadmin I am getting the
> following error
> 1: ERROR: column op.oprlsortop does not exist at character 773
> 2: ERROR: column "opcamid" does not exist at character 170
> Can anyone please help me to debug this error
> Regards,kartik
> Waiting for your reply
Upgrade pgadmin to latest release.
--
Pawel Socha
pawel.socha@gmail.com
perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-
{ a%%s%%$_%ee'
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: query
2008-07-02 14:59 query kartik <kartik@v2technocrats.com>
@ 2008-07-02 17:33 ` Devrim GÜNDÜZ <devrim@gunduz.org>
3 siblings, 0 replies; 31+ messages in thread
From: Devrim GÜNDÜZ @ 2008-07-02 17:33 UTC (permalink / raw)
To: kartik <kartik@v2technocrats.com>; +Cc: pgsql-admin
Hi,
On Wed, 2008-07-02 at 20:29 +0530, kartik wrote:
> While connecting to the db by the pgadmin I am getting the following
> error
>
> 1: ERROR: column op.oprlsortop does not exist at character 773
>
> 2: ERROR: column "opcamid" does not exist at character 170
You need to use latest (1.8.4) pgadmin3.
Regards,
--
Devrim GÜNDÜZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
Attachments:
signature.asc (application/pgp-signature, 196B) download
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: query
2008-07-02 14:59 query kartik <kartik@v2technocrats.com>
@ 2008-07-02 17:36 ` Lennin Caro <lennin.caro@yahoo.com>
3 siblings, 0 replies; 31+ messages in thread
From: Lennin Caro @ 2008-07-02 17:36 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, kartik <kartik@v2technocrats.com>
update the pgadmin to the new version
--- On Wed, 7/2/08, kartik <kartik@v2technocrats.com> wrote:
> From: kartik <kartik@v2technocrats.com>
> Subject: [ADMIN] query
> To: pgsql-admin@postgresql.org
> Date: Wednesday, July 2, 2008, 2:59 PM
> Hello there,
>
> I am new to postgresql
>
> I have installed postgresql -8.3.3 on debian etch os
>
> While connecting to the db by the pgadmin I am getting the
> following error
>
> 1: ERROR: column op.oprlsortop does not exist at character
> 773
>
> 2: ERROR: column "opcamid" does not exist at
> character 170
>
> Can anyone please help me to debug this error
>
> Regards,kartik
>
> Waiting for your reply
^ permalink raw reply [nested|flat] 31+ messages in thread
* Query
@ 2008-07-19 10:59 Kartik <kartik@v2technocrats.com>
2008-07-19 13:27 ` Re: Query Tino Schwarze <postgresql@tisc.de>
0 siblings, 1 reply; 31+ messages in thread
From: Kartik @ 2008-07-19 10:59 UTC (permalink / raw)
To: pgsql-admin
hello there,i am new to postgresql
i am using postgresql 8.3.3 and i am writing one whole transaction. i want
to know how to set auto commit off
because if any error occours i want the whole transaction to be rolled back.
when i tried alter database dbname set autocommit = off
then it gives me error saying autocommit not available
so can anyone suggest how to set autocommit as off so that i can rollback
the transaction..
thank you
waiting for your reply
regards
kartik
^ permalink raw reply [nested|flat] 31+ messages in thread
* Re: Query
2008-07-19 10:59 Query Kartik <kartik@v2technocrats.com>
@ 2008-07-19 13:27 ` Tino Schwarze <postgresql@tisc.de>
0 siblings, 0 replies; 31+ messages in thread
From: Tino Schwarze @ 2008-07-19 13:27 UTC (permalink / raw)
To: pgsql-admin
On Sat, Jul 19, 2008 at 04:29:00PM +0530, Kartik wrote:
> hello there,i am new to postgresql
> i am using postgresql 8.3.3 and i am writing one whole transaction. i want
> to know how to set auto commit off
> because if any error occours i want the whole transaction to be rolled back.
> when i tried alter database dbname set autocommit = off
> then it gives me error saying autocommit not available
> so can anyone suggest how to set autocommit as off so that i can rollback
> the transaction..
Simply issue the command "BEGIN" at the start of your transaction.
Then nothing will be commited until you issue "COMMIT" and you may abort
the transaction by sending "ROLLBACK" (or "ABORT").
HTH,
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
www.craniosacralzentrum.de
www.forteego.de
^ permalink raw reply [nested|flat] 31+ messages in thread
end of thread, other threads:[~2008-07-19 13:27 UTC | newest]
Thread overview: 31+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-28 11:54 Query Mahesh Guleria <mahesh@himline.com>
2001-08-24 14:54 Query Vida Luz Arista <vlal@ideay.net.ni>
2001-08-24 15:59 ` Richard Bayet <bayet@enseirb.fr>
2001-08-24 16:09 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-11-15 20:47 query Jodi Kanter <jkanter@virginia.edu>
2004-01-05 14:20 query ma101kg@gold.ac.uk
2004-01-07 05:07 ` Re: query A.Bhuvaneswaran <bhuvaneswaran@bksystems.co.in>
2004-01-07 05:13 ` Re: query A.Bhuvaneswaran <bhuvan@symonds.net>
2004-01-05 14:26 Query ma101csn@gold.ac.uk
2004-05-14 13:12 Query Jørgen Lie Pettersen <jorgen.lie.pettersen@isys.no>
2004-05-16 19:31 ` Jim Seymour <jseymour@LinxNet.com>
2006-05-09 04:45 Query mindtree.chandana@daimlerchrysler.com
2006-05-10 08:02 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2008-06-25 09:51 Query kartik <kartik@v2technocrats.com>
2008-06-26 04:31 ` Vishal Arora <aroravishal22@hotmail.com>
2008-06-25 10:01 Query kartik <kartik@v2technocrats.com>
2008-06-25 14:50 ` Travis Smith <tsmith@optionshouse.com>
2008-06-25 15:11 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-06-25 17:17 ` Carol Walter <walterc@indiana.edu>
2008-06-27 05:33 Query kartik <kartik@v2technocrats.com>
2008-06-27 20:12 ` Travis Smith <tsmith@optionshouse.com>
2008-06-27 20:14 ` Jeff Frost <jeff@frostconsultingllc.com>
2008-06-30 09:55 Query kartik <kartik@v2technocrats.com>
2008-07-02 17:36 ` Lennin Caro <lennin.caro@yahoo.com>
2008-07-02 14:59 query kartik <kartik@v2technocrats.com>
2008-07-02 17:25 ` Re: query Alvaro Herrera <alvherre@commandprompt.com>
2008-07-02 17:28 ` Re: query paul socha <pawel.socha@gmail.com>
2008-07-02 17:33 ` Re: query Devrim GÜNDÜZ <devrim@gunduz.org>
2008-07-02 17:36 ` Re: query Lennin Caro <lennin.caro@yahoo.com>
2008-07-19 10:59 Query Kartik <kartik@v2technocrats.com>
2008-07-19 13:27 ` Tino Schwarze <postgresql@tisc.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox