Friends,
I wanted to select setof items from a plpgsql funtion.
I know that plpgsql funtion can return a setof items.
But i don't know how to write that kind of funtion.
Please help me in this reg.
advance thanks
rajaDo You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! M
Have a look at : http://joelburton.com/resources/pgaccess/faq.html
tere are some lines about OLE objects. I've got this working with Postgres
7.0, but never tested it in a working environment.
- Original Message -
From: "Daniel Bakken" <[EMAIL PROTECTED]>
To: "postgres group" <[EMAIL P
Hi,
We got similar problem with the Cygwin based implementation of version 7.1.3
in a NT machine. We are using Delphi as front end. Just the tables are not
showing up. Till date our work-around is - just writing the field-names
manually, at the designated place and everything is working fine. But
Thanks a lot Stephan,
dropping the right rule solved the problem.
Oleg
Oleg Lebedev wrote:
> I tried
> select * from pg_rewrite where ev_class=23945;
> No tuples were returned.
> What should I do next?
> thanks,
>
> Oleg
>
> Stephan Szabo wrote:
>
> > Oops, of course, the row in pg_class isn't t
Is there a way to easily store images or other large files into the DB over
a TCP/IP network. I would prefer Access/ODBC, but I could also use pgaccess
if necessary. It would really be nice if there was a GUI way to do it.
Basically, I want to copy a file from my hard drive directly to a PostgreS
I tried
select * from pg_rewrite where ev_class=23945;
No tuples were returned.
What should I do next?
thanks,
Oleg
Stephan Szabo wrote:
> Oops, of course, the row in pg_class isn't there so
> the pg_rules view won't show it.
>
> Okay, try
> select * from pg_rewrite where ev_class=23945;
>
> On
select * from pg_rules
returned NO tuples.
What should I do next?
thanks,
Oleg
Stephan Szabo wrote:
> On Thu, 30 Aug 2001, Oleg Lebedev wrote:
>
> > I can't find any reference to this table in my current database.
> > What's the best way to find this out?
> > thank you,
>
> Try a
> select * fr
On Thu, 30 Aug 2001, Oleg Lebedev wrote:
> I can't find any reference to this table in my current database.
> What's the best way to find this out?
> thank you,
Try a
select * from pg_rules;
And see if any of the rule definitions mention the table.
---(end of broadc
Oops, of course, the row in pg_class isn't there so
the pg_rules view won't show it.
Okay, try
select * from pg_rewrite where ev_class=23945;
On Thu, 30 Aug 2001, Oleg Lebedev wrote:
> select * from pg_rules
> returned NO tuples.
> What should I do next?
> thanks,
>
> Oleg
>
> Stephan Szab
I can't find any reference to this table in my current database.
What's the best way to find this out?
thank you,
Oleg
Stephan Szabo wrote:
> On Thu, 30 Aug 2001, Oleg Lebedev wrote:
>
> > Hi,
> > I am trying to upgrade to 7.1.2 and when I use:
> > pg_dumpall -o > file.bac
> > I get an error sa
On Thu, 30 Aug 2001, Oleg Lebedev wrote:
> Hi,
> I am trying to upgrade to 7.1.2 and when I use:
> pg_dumpall -o > file.bac
> I get an error saying:
> dumpRules(): SELECT failed for table setmedias. Explanation from backend:
> 'ERROR: cache lookup of attribute 5 in relation 23945 failed"
>
> As
I
think it will run on the cygwin package (a Unix-like environment for windows),
but not on native windows OS.
I'm
not sure where you can get Cygwin (maybe www.cygwin.org), but you can get the latest
Postgres at www.postgresql.org.
Daniel Bakken, Systems Administrator
[EMAIL PROTECTED
Yogesh Shahir wrote:
>
> Hello Sir,
>
>Is postgreSQL is available for windows ? If yes, from where I can downlo=
> ad it ?
PostgreSQL is a multiplatform DMBS. You can download the tarball from
ftp.postgresql.org and compile postgres for MS Windows. There are some
extra requirements for com
accept 9554-6639-3F19
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi,
I am trying to upgrade to 7.1.2 and when I use:
pg_dumpall -o > file.bac
I get an error saying:
dumpRules(): SELECT failed for table setmedias. Explanation from backend:
'ERROR: cache lookup of attribute 5 in relation 23945 failed"
As I understand setmedias table corresponds to relation 23945
Its inability to do OLAP (On-Line Analytical Processing) makes it a weak
tool to do so. It would be nice to see great bridge or some other
vendor create an OLAP engine that works well with Postgres. IBM has
embraced Hyperion to do this in thier DB2 suite.
-Derek
Sudheer Palaparambil wrote:
Hello,
Has anybody done datawarehousing using postgres?
Thank you.
Sudheer.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hello Sir,
Is postgreSQL is available for windows
? If yes, from where I can sownload it ?
Please help me.
Regards,
Yogesh
dear all
I have use pg_dump -Zx my database
can't pg_resotre -Z database
how to restore my database,thanks
--
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hi,
im using a jdbc connection to access postgres and somehow once i manage
transaction by myself i got some:
NOTICE: BEGIN: already a transaction in progress
NOTICE: COMMIT: no transaction
doing :
conn = ds.getConnection();
try
{
conn.setAutoCommit(false);
...
conn.commit();
}
ca
What is 'action' for. The script works fine on my system, if
remove the 'action ""' stuff and outcomment the line
. /etc/rc.d/functions.
So I guess there is a problem with this action procedure.
Arne
---(end of broadcast)---
TIP 5: Have you ch
> How about REVOKE ??
How can I use REVOKE to disallow a user to create a table?
Stefan
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hello Sir,
Is postgreSQL is available for windows
? If yes, from where I can download it ?
Thanking you
Regards,
Yogesh Shahir
Project Manager
CREDOTEK
www.credotek.com
David Stanaway writes:
> It appears that it was due to running out of space.
> Are there any quick tips for receiving notification of critical errors
> such as this, and how much breathing space to leave on the filesystem
> for the database transaction logs.
As you found out for yourself, at lea
You may look at this site:
http://www.greatbridge.org/project/pgreplication/projdisplay.php
Egon
Srinivasa Rao Chava wrote:
> Hai Friends,
> Does postgresql supports replication?
> Say, we want to install to servers , having the same databases. One of
> them will work as standby database. For
25 matches
Mail list logo
