On Thu, May 29, 2003 at 17:37:19 +0800,
Abdul Wahab Dahalan <[EMAIL PROTECTED]> wrote:
> How can I undelete the deleted data from a table;
If you notice before you commit, you issue a rollback. Otherwise you need
to recover from backup. If you don't have a backup, then you might be
able to do so
I've accidentally deleted the data in my table. So How to recover it back.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
How can I undelete the deleted data from a table;
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
"jack" <[EMAIL PROTECTED]> writes:
> A view is created with a normal table xx without a schema specified. And
> before using the view, a temporary table xx , which has the same name as the
> normal table xx used by the view. In the same connection session, it
> supposes the view would read the temp
Hi All
A view is created with a normal table xx without a schema specified. And
before using the view, a temporary table xx , which has the same name as the
normal table xx used by the view. In the same connection session, it
supposes the view would read the temporary table. But actually it always
Charlie Toohey <[EMAIL PROTECTED]> writes:
> Why can't my primary user (ttvuser) access tables (owned by owneruser) for
> which they've been granted access? I can describe the table, but can't
> read it.
> ttvdev=> select count(*) from owneruser.users;
> ERROR: owneruser: permission denied
You
Working on my first set returning function... So far the examples from
http://techdocs.postgresql.org/guides/SetReturningFunctions have worked well
for me...
I'd like to see what kind of performance I get from a particularly slow
piece of code by replacing it with a recursive srf (right now, I do
Why can't my primary user (ttvuser) access tables (owned by owneruser) for
which they've been granted access? I can describe the table, but can't
read it.
===
Here's what I'm getting:
ttvdev=> \c - owneruser
Password:
You are now connected as new user owneruser.
ttvdev=> \d
On Tue, 2003-05-27 at 10:30, Jodi Kanter wrote:
> I also need a Perl programming book to use as a reference but also as a
> means to learning the product. I am a DBA but fairly new to coding in
> Perl.
> Does anyone have a recommendation?
> Thanks
> Jodi
>
You might want to give "PostgreSQL" by K
Have a look at translate(). It behaves like the unix command 'tr'.
Randall Lucas wrote:
>
> Hi Mallah,
>
> I had this problem once, and put together this bunch of regexes. It's
> by no means optimal, but should solve 90% and would easily be adapted
> into a plperl function.
>
> Begin perl:
>
10 matches
Mail list logo
