[SQL] psql win32 version
Is there a win32 version for psql? JACK ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[SQL] Re: psql win32 version
The URL shown below can not get through. Would you please check again. Thank You JACK - Original Message - From: "Marc Cromme" <[EMAIL PROTECTED]> To: "'datactrl'" <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 6:58 PM Subject: RE: psql win32 version > Yes - check > > http://www.zeos.dn.ua/download/ipgsql-latest.zip > > > your's Marc Cromme > > > -Original Message- > From: datactrl [mailto:[EMAIL PROTECTED]] > Sent: 12. marts 2001 02:19 > To: [EMAIL PROTECTED] > Subject: psql win32 version > > > Is there a win32 version for psql? > > JACK > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] Some questions about PLpgSql
Hi, all By using 'PLpgsql', is that possible to 1) check if a specific table exists? 2) check if an INSERT/UPDATE/ DELETE has done successfully? Is there some more documents or samples for PLpgsql except USER GUIDE and PostgreSQL Introduction & concept? THANK YOU JACK ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] how do I find which ...
I write some functions inPL/pgSQL. If I drop a function B , which is called by function A, and create function B again, then function A won't work unless I drop function A and re-create again. How about if there are lots functions call to function B, is there any way to search system table to find out those functions call to A? JACK ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [SQL] Re: psql win32 version
Hi, Christopher Thank you for your help, but the URL http://www.zeos.dn.ua/download/ipgsql-1.6.2.zip is a broken link. Would you please check again. Thank you very much. Jack - Original Message - From: "Christopher Sawtell" <[EMAIL PROTECTED]> Newsgroups: comp.databases.postgresql.sql Sent: Thursday, March 15, 2001 1:19 PM Subject: Re: [SQL] Re: psql win32 version > This one worked a minute ago:- > > http://www.zeos.dn.ua/download/ipgsql-1.6.2.zip > > > On Thu, 15 Mar 2001 14:14, datactrl wrote: > > The URL shown below can not get through. Would you please check again. > > > -- > Sincerely etc., > > NAME Christopher Sawtell > CELL PHONE 021 257 4451 > ICQ UIN45863470 > EMAIL csawtell @ xtra . co . nz > CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz > > -->> Please refrain from using HTML or WORD attachments in e-mails to me > <<-- > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] database log
Since "raise exception" in pl/pgSQL will write error message to database log, how can I read database log. If I do "select * from pg_log;", it will show an error message as "pg_log can not be accessed by user". JACK ---(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
[SQL] drop table in PL/pgSQL
When I use "drop Table ..." in PL/pgSQL, it always causes an error as "ERROR copyObject: don't know how to copy 614" JACK ---(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
[SQL] SOME PL/PGSQL PROBLEMS
I found there are some problems with PL/pgSQL. 1) 'Drop Table' doesn't work at all 2) '--' comment causes parsing error 3) Execute doesn't work at all. It always causes parsing error! Some questions 1) Can I use variable in FROM clause for a table name? 2) Can I use variable in WHERE such as xxx = variable? JACK ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] how do I check if a temporary table exists?
How do I check if a temporary table exists? Searching pg_tables with a temporary table name we chose always fails. JACK ---(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
[SQL] About Raise Exception
According to user guide, both Raise Notice & Raise Exception will write message to database log. Which system table is the database log about? By the way what is the difference between Raise Notice & Raise Exception? Jack ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] Re: [GENERAL] install pgSQL 7.1
No, I'm still at sea. Please help ! JACK - Original Message - From: "Justin Clift" <[EMAIL PROTECTED]> To: "datactrl" <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 3:18 AM Subject: Re: [GENERAL] install pgSQL 7.1 > Hi, > > Have people answered you regarding this? > > Regards and best wishes, > > Justin Clift > > > datactrl wrote: > > > > I down load pgSQL v 7.1rc1-1 rpm from > > ftp://ftp.postgresql.org/pub/dev/test-rpms/. When I install it, > > there is a dependency check error for libpg.so.2 & libreadline.so.4.1. > > My server is running RH 6.2. Do I have to upgrade to RH 7.x? > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] Question about Committed Isolation
Regarding "Committed Isolation" on PostgreSql Ver 7.1 Users Guide, is that possible a "Dead Lock" happened when two concurrent transactions are waiting each other? And how to avoid or fix it? Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] Client Applications come with PostGreSQL V7.1
Is there any Windows version of all Client Applications come with PostGreSQL V7.1? Jack ---(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: [SQL] execute client application from PL/pgSql
Thank You Jeff, What is phpPgAdmin and where can get it? Jack - Original Message - From: "Jeff MacDonald" <[EMAIL PROTECTED]> To: "Jack" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, May 12, 2001 2:28 AM Subject: Re: [SQL] execute client application from PL/pgSql > you could hack the pg_dump bit out of phpPgAdmin > i think the license permits it. > > just my 2 cents. > > jeff > > On Wed, 9 May 2001, Jack wrote: ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] question about PL/pgSQL function
With postgres 7.1 1. Function like example found on 24.4 Example in Programmer Guide CREATE FUNCTION xxx (EMP, integer) RETURNS boolean AS'.. (which EMP is a table ) How do I pass a record to this function in PL/PGSQL? I try this select into rec1 * from EMP where empNo =''''; i1 := xxx(rec1,5); But it won't work! 2. Is that possible to return a record from a function? And how do I get the returned record in PL/pgSql JACK ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[SQL] When using COPY
By using ...
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
[BINARY]: If I use it instead of choosing a delimiter, is that safe for
copied data and more quick to copy?
[WITH OIDS] : If my application didn't use any oid, do I need to specify it?
Which one (specify it or not ) will be more quick to copy?
THANK YOU
JACK
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
[SQL] problem with date/time constants
Hi, server:PostgreSQl 7.1 why doesn't following statement work? "select now;" THANK YOU! JACK LIU ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] array variable in pl/pgsql
Hi all Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] array variable in pl/pgsql
Hi all Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack ---(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
