TigerNassau
2014-08-20 16:22:29 UTC
Even with latest upgrades on debian jessie after a new postgres installation typing the following: "su - postgres" requests a password and trying several such as postgres, blank, sudo password - all gives an auth error. How can this be fixed?
Sent from my LG Mobile
Sent from my LG Mobile
It worked when I included the parameter list in the DROP statement.
Thank you!
Lori
-----Original Message-----
Sent: Wednesday, August 20, 2014 11:54 AM
Subject: Re: [GENERAL] create function : change name of input parameter
^
id
----
(0 rows)
id
----
(0 rows)
List of relations
Schema | Name | Type | Owner
--------+---------------------+----------+----------
public | CamelCap_Quoted | table | aklaver
public | camelcap_not_quoted | table | aklaver
If the name is quoted the case is preserved and you have to quote the name to get the same object. A lot of frameworks/ORMS automatically quote object names so this something to watch out for. In the unquoted case the name is folded to lower case by default. So you can get in a situation where you have both the quoted and unquoted name and not be working on the object you think you are.
Adrian Klaver
The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.
--
http://www.postgresql.org/mailpref/pgsql-general
Thank you!
Lori
-----Original Message-----
Sent: Wednesday, August 20, 2014 11:54 AM
Subject: Re: [GENERAL] create function : change name of input parameter
OK...if I manually run this within psql it is fine.
But I have a shell script in which I am wrapping a call to 'psql'...and I guess it does not like how things are being passed in when I do it this way.
So, yes, it is working correctly when I copy/paste my script directly into psql.
Will try a different approach to my wrapper.
ERROR: relation "camelcap_quoted" does not exist LINE 1: select * from CamelCap_Quoted;But I have a shell script in which I am wrapping a call to 'psql'...and I guess it does not like how things are being passed in when I do it this way.
So, yes, it is working correctly when I copy/paste my script directly into psql.
Will try a different approach to my wrapper.
^
id
----
(0 rows)
id
----
(0 rows)
List of relations
Schema | Name | Type | Owner
--------+---------------------+----------+----------
public | CamelCap_Quoted | table | aklaver
public | camelcap_not_quoted | table | aklaver
If the name is quoted the case is preserved and you have to quote the name to get the same object. A lot of frameworks/ORMS automatically quote object names so this something to watch out for. In the unquoted case the name is folded to lower case by default. So you can get in a situation where you have both the quoted and unquoted name and not be working on the object you think you are.
Many thanks!
Lori
--Lori
Adrian Klaver
The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.
--
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.p
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.p
