On Monday 11 January 2010 3:08:27 am Fernando Morgenstern wrote:
> Em 11/01/2010, às 09:04, hubert depesz lubaczewski escreveu:
> >> Hi,
> >>
> >> I have done:
> >>
> >> # psql -U postgres -p 4000 -l | hexdump -C
> >>
> >> And got the two databases: http://pastebin.ca/1746711
> >>
> >> I couldn't f
On Mon, Jan 11, 2010 at 09:08:27AM -0200, Fernando Morgenstern wrote:
> Same result: http://pastebin.ca/1746714
It looks like there is problem with system catalogs. I would suggest to
pg_dump what you can, rm $PGDATA, initdb, and load from backup.
Best regards,
depesz
--
Linkedin: http://www.l
Em 11/01/2010, às 09:04, hubert depesz lubaczewski escreveu:
>> Hi,
>>
>> I have done:
>>
>> # psql -U postgres -p 4000 -l | hexdump -C
>>
>> And got the two databases: http://pastebin.ca/1746711
>>
>> I couldn't find any difference here.
>
> Could you add -qAt to psql options and rerun the
On Mon, Jan 11, 2010 at 08:58:57AM -0200, Fernando Morgenstern wrote:
> Em 09/01/2010, às 19:40, hubert depesz lubaczewski escreveu:
>
> > On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
> >> postgres=# drop database skynet;
> >> ERROR: database "skynet" does not exist
> >
Em 09/01/2010, às 19:40, hubert depesz lubaczewski escreveu:
> On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
>> postgres=# drop database skynet;
>> ERROR: database "skynet" does not exist
>
> do:
>
> psql -l | hexump -C
> and examine output.
>
> Best regards,
>
> depes
Em 08/01/2010, às 15:58, Adrian Klaver escreveu:
>
> Actually what is strange is that your previous listing :
> postgres=# select '"' || datname || '"' from pg_database;
> ?column?
> -
> "template1"
> "template0"
> "t1"
> "skynet"
>
> is not the same as the one above:
>
> post
On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
> postgres=# drop database skynet;
> ERROR: database "skynet" does not exist
do:
psql -l | hexump -C
and examine output.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
Rikard Bosnjakovic writes:
> Is there a particular reason space is allowed in name identifiers? I
> see nothing but confusion if a space exists.
The SQL standard requires that double-quoted identifiers be allowed to
contain anything.
regards, tom lane
--
Sent via pgsql-
On Fri, Jan 8, 2010 at 17:44, Sam Mason wrote:
> There's an extra space at the beginning of the "skynet" line, could it
Is there a particular reason space is allowed in name identifiers? I
see nothing but confusion if a space exists.
--
- Rikard - http://bos.hack.org/cv/
--
Sent via pgsql-g
On Fri, Jan 8, 2010 at 9:58 AM, Adrian Klaver wrote:
> On 01/08/2010 09:53 AM, Fernando Morgenstern wrote:
>
>>
>>
>
> Actually what is strange is that your previous listing :
>
> postgres=# select '"' || datname || '"' from pg_database;
> ?column?
> -
> "template1"
> "template0"
On 01/08/2010 09:53 AM, Fernando Morgenstern wrote:
Em 08/01/2010, às 15:49, Adrian Klaver escreveu:
On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
Hello,
Thanks for your quick answers. The extra space is indeed a copy-and-paste
issue. Here it is the select that you suggested:
postgre
Em 08/01/2010, às 15:49, Adrian Klaver escreveu:
> On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
>
>> Hello,
>>
>> Thanks for your quick answers. The extra space is indeed a copy-and-paste
>> issue. Here it is the select that you suggested:
>>
>> postgres=# select '"' || datname || '"' f
On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
Hello,
Thanks for your quick answers. The extra space is indeed a copy-and-paste
issue. Here it is the select that you suggested:
postgres=# select '"' || datname || '"' from pg_database;
?column?
-
"template1"
"template0"
Em 08/01/2010, às 14:48, Tom Lane escreveu:
> Adrian Klaver writes:
>> On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
>>> Name| Owner | Encoding | Collation |Ctype| Access
>>> privileges
>>> ---+--+--+-+-+---
Adrian Klaver writes:
> On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
>> Name| Owner | Encoding | Collation |Ctype| Access
>> privileges
>> ---+--+--+-+-+---
>> skynet| postgres | UTF8 | en_US.UT
On Fri, Jan 08, 2010 at 02:39:03PM -0200, Fernando Morgenstern wrote:
> postgres=# \l
> List of databases
>Name| Owner | Encoding | Collation |Ctype| Access
> privileges
> ---+--+--+-+-+
On 01/08/2010 08:39 AM, Fernando Morgenstern wrote:
Hello,
I'm running version 8.4.1 and have a table that appears on listing ( when i
run \l ) but i can't drop it. Example:
postgres=# \l
List of databases
Name| Owner | Encoding | Collation |
17 matches
Mail list logo
